Re: One DB not backed up by pg_dumpall

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.

> I do a nightly dump and have checked several days so far and the database
> is missing in all so far. :-(

Is this a new procedure that has never worked, or is it an old
procedure with a new problem?

> The only thing, for that DB, that got backed up was the database, but not a
> single table. So far from what I see other DBs were restored ok (At least
> the ones I have checked so far).

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?

--
Michael Fuhr