Re: Full backup - pg_dumpall sufficient?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Full backup - pg_dumpall sufficient?
Date: 2009-01-29 17:01:09
Message-ID: 25763.1233248469@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gerhard Wiesinger <lists(at)wiesinger(dot)com> writes:
> Any ideas what additionally has to be dumped to pg_dumpall for a full
> backup?

The configuration files (postgresql.conf, pg_hba.conf, pg_ident.conf),
plus any SSL server keys/certs you might be using --- basically, all
the static text files in the toplevel $PGDATA directory. Those things
are not accessible to a client so pg_dump can't dump them.

Some people put these files in a different directory where they'll be
caught by their regular filesystem backup procedures for the server.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gerhard Wiesinger 2009-01-29 17:01:52 Re: Full backup - pg_dumpall sufficient?
Previous Message David Fetter 2009-01-29 16:57:26 Re: Pet Peeves?