How can I restore a postgresql db dump from a local db to a server via psql?

Question

I have building and testing a psql database on my local machine, and the time is come to move it to a server. I have my dump file, but I'm not sure how to actually get it on the server to restore it there. Obviously something like the following doesn't work:

psql -U user -d datbase < C:/dbbackups/dbbackup.dump

But what is the proper way to get my dump on the server from my local to properly restore it?

Mushroomator · Accepted Answer · 2022-03-16 14:03:15Z

1

You can use pg_dump.

pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname

If you want to use your dump you could of course also transfer your dump file over to the new server securly using e.g. SFTP and then restore it there as you would on your local machine.

answered Mar 16, 2022 at 14:03

Mushroomator

9,6881 gold badge26 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I restore a postgresql db dump from a local db to a server via psql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related