pg_dump -zd database_name > /home/myfolder/backupfile
works great for me
pete
Gerard Saraber wrote:
> 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