backing up pgsql
Started by Gerard Saraberabout 27 years ago2 messagesgeneral
Hi,
I was wondering what kind of backup "system" you guys are using/would
recommend..
Do I take the database offline and just backup the entire
data-directory? Or do I use some pg_dump solution? any pros/cons ?
Thanks,
Gerard Saraber
gsaraber@glasscity.net
Re: [GENERAL] backing up pgsql
pg_dump -zd database_name > /home/myfolder/backupfile
works great for me
pete
Gerard Saraber wrote:
Show quoted text
Hi,
I was wondering what kind of backup "system" you guys are using/would
recommend..
Do I take the database offline and just backup the entire
data-directory? Or do I use some pg_dump solution? any pros/cons ?Thanks,
Gerard Saraber
gsaraber@glasscity.net