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

• Full backup - pg_dumpall sufficient? at 2009-01-29 16:31:07 from Gerhard Wiesinger

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?