Re: pg_dump vs pg_dumpall - small database cluster,

On Sat, 20 Dec 2003, C. Bensend wrote:

>
> >>   pg_dumpall seems to do this for me, without any command-line args
> >> needed.  Am I correct in saying that 'pg_dumpall > filename' will
> >> produce
> >> a PostgreSQL dump that includes _everything_ I need to go from a clean
> >> PG install to accepting connections again with data intact?  Users,
> >> passwords, etc?
> >>
> >
> > and the owner of pg_dumpall process must be a database superuser.
>
> Absolutely...  I'm running this directly on the database server, as the
> PostgreSQL superuser, so permissions aren't an issue.  I just want to be
> very sure that pg_dumpall is getting absolutely everything I need,
> because I don't have the resources at this site to do full filesystem
> backups of this host.

Note that in the past, occasional dependency issues have cause pg_dumpall
to fail for certain users.  I myself had it happen with a customer
sequence a little while ago on 7.2.4.  Unfortunately, I'm unable to
reproduce the sequence of events that caused it, so I can't really report
it as a bug.