For a single database mybase located on a server dbserver.local, from a user john :
pg_dump -h dbserver.local -U john mybase > backup_db_mybase.`date +%Y.%m.%d`.sql
This simple trick may do a great deal for you.
Tags: backup, postgresql, sql
For a single database mybase located on a server dbserver.local, from a user john :
pg_dump -h dbserver.local -U john mybase > backup_db_mybase.`date +%Y.%m.%d`.sql
This simple trick may do a great deal for you.
Tags: backup, postgresql, sql