I’m new to postgresql, and locally, I use pgadmin3. On the remote server, however, I have no such luxury.
I’ve already created the backup of the database and copied it over, but, is there a way to restore a backup from the command line? I only see things related to GUI or to pg_dumps, so, if someone can tell me how to go about this, that’d be terrific!