Re: pg_dump vs pg_dumpall - small database cluster,

>>   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.

Thanks much!

Benny


--
"Hey, get in here, Boozy!  You're late for your drunkening!"
                                                    -- Moe, "The Simpsons"