>> pg_dumpall seems to do this for me, without any command-line args
>> needed. Am I correct in saying that 'pg_dumpall > filename' will
>> 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.
"Hey, get in here, Boozy! You're late for your drunkening!"
-- Moe, "The Simpsons"
In response to
pgsql-admin by date
|Next:||From: Ray Ontko||Date: 2003-12-20 14:47:52|
|Subject: Re: Index is not used|
|Previous:||From: kopra||Date: 2003-12-20 14:03:54|
|Subject: Re2: Problm Drop Table :: 748580 |