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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
