# let's create a backup from remote postgresql database using pg_dump:
#   pg_dump -h [host address] -Fc -o -U [database user] <database name> > [dump file]
# later it could be restored at the same remote server using:
#   sudo -u postgres pg_restore -C mydb_backup.dump

pg_dump -h -p 5432 -Fc -o -U myuser mydb > mydb_backup.dump

pg_restore -C mydb_backup.dump

#complete (all databases and objects)

pg_dumpall -U myuser -h -p 5432 --clean --file=mydb_backup.dump

#restore from pg_dumpall --clean:

psql -f mydb_backup.dump postgres #it doesn't matter which db you select here
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter