Skip site navigation (1) Skip section navigation (2)

Re: backups

From: Richard Welty <rwelty(at)averillpark(dot)net>
To: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: backups
Date: 2004-06-30 20:45:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Wed, 30 Jun 2004 15:34:12 -0500 Bruno Wolff III <bruno(at)wolff(dot)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 Welty                                         rwelty(at)averillpark(dot)net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

In response to

  • Re: backups at 2004-06-30 20:34:12 from Bruno Wolff III

pgsql-general by date

Next:From: Simon WindsorDate: 2004-06-30 21:02:03
Subject: Postgres index performance
Previous:From: Bruno Wolff IIIDate: 2004-06-30 20:34:12
Subject: Re: backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group