Jump to content

Postgresql

Hikaru12

Just bought a VPS (remote) and installed PostGRESQL. I'm new to it but it seems very similar to MYSQL which I am familiar with. Is this command correct? I'm trying to backup the database and save it to the /home/backups directory. Thanks!

pg_dump test_db | gzip > testbak.gz -D /home/backups
Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×