Error on pg_dumpall

From: Terry Khatri <terrykhatri531(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error on pg_dumpall
Date: 2012-10-21 19:24:23
Message-ID: CANH4f+jodV27BeU7mgX=gzFfOViBWwN7Bd9RDcBFXjceG5wmBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I am getting the following error msg when I do a pg_dumpall

-----

TK(at)OraLinux /usr/local/pgsql/backups
$ pg_dumpall -U sns84 > completebackup20121020,sql
pg_dump: schema with OID 74363 does not exist
pg_dumpall: pg_dump failed on database "bihistory", exiting

-----

I have set the logs to debug5 to catch where the problem is while taking
the dump but nothing shows up there.

If you have any ideas please help me.

And thanks to all for responding to my earlier post.

Rgds
T

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Craig Ringer 2012-10-22 02:47:54 Re: Database in psql
Previous Message teyking2003 2012-10-20 00:18:47 Re: Database in psql