PostgreSQL: backup remote database with pg_dump

#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 # #Ex: pg_dump -h 67.8.78.10 -Fc -o -U myuser mydb > mydb_backup.dump
Command I use to backup my remote postgres databases

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.