Re: [GENERAL] backing up pgsql

From: pete collins <pcollins(at)ocsny(dot)com>
To: Gerard Saraber <gsaraber(at)glasscity(dot)net>
Cc: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] backing up pgsql
Date: 1999-03-29 22:14:43
Message-ID: 36FFFB52.8171993A@ocsny.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)glasscity(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rick Dearman 1999-03-30 07:47:14 User built functions?
Previous Message Herouth Maoz 1999-03-29 17:26:37 Re: [GENERAL] problems with a sub-select (takes donkeys' years)