Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
As the operating system superuser or as a database superuser?
There's a difference.
As the database superuser.
Is this a new procedure that has never worked, or is it an old
procedure with a new problem?
Old procedure with a new problem.
What are the exact commands you're using to dump and restore? Have
you examined the output and the server's logs for errors and warnings?
The nightly script is:
#!/bin/csh
setenv PGUSER pgsql
setenv PGPASSWORD <password>
/usr/local/bin/pg_dumpall |/usr/bin/bzip2 -c ><file>
Where <file> is
/vol1/backs/pgsql/dump_all.sql.bz2
This procedure has been running for a while.
Last night before upgrading from 8.0.x to 8.1 I ran the script, then
proceeded to upgrade. So far from what I can tell only lost that one
database. :-(
However it deeply worries me. I will need to find if the script above is the
problem or something else. In coming days will keep an eye on the dump. This
one db I lost was bad to loose, but not critical (personal wiki), however it
would have been horrible if had lost other databases.
