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
