Gerhard Wiesinger <lists(at)wiesinger(dot)com> writes:
> Any ideas what additionally has to be dumped to pg_dumpall for a full
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
pgsql-general by date
|Next:||From: Gerhard Wiesinger||Date: 2009-01-29 17:01:52|
|Subject: Re: Full backup - pg_dumpall sufficient?|
|Previous:||From: David Fetter||Date: 2009-01-29 16:57:26|
|Subject: Re: Pet Peeves?|