Re: backups - Mailing list pgsql-general

From Richard Welty
Subject Re: backups
Date
Msg-id Mahogany-0.66.0-16045-20040630-164552.00@averillpark.net
Whole thread Raw
In response to Re: backups  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Wed, 30 Jun 2004 15:34:12 -0500 Bruno Wolff III <bruno@wolff.to> wrote:
> Those are configuration files (along with pg_ident.conf) and don't contain
> your data. You probably want a back of those as well, but you may not need
> them when restoring your data if that instance of postgres has already
> been configured. Also if the machine you are restoring to is significantly
> different than the original machine, you may want to tweak those files.

yes. what actually makes sense is to set up a backup area for postgresql
on another partition, and pg_dump or pg_dumpall to a file system there,
rsync the config files to that file system in case they've changed, and then
run dump or whatever against the partition containing the backup data.

running dump against an active, live database won't produce anything
of value.

richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: backups
Next
From: Simon Windsor
Date:
Subject: Postgres index performance