Tks
T
---------- Forwarded message ----------
From: Terry Khatri <terrykhatri531@xxxxxxxxx>
Date: 22 October 2012 00:20
Subject: Errors on pg_dumpall
To: pgsql-admin-owner@xxxxxxxxxxxxxx
Hi
From: Terry Khatri <terrykhatri531@xxxxxxxxx>
Date: 22 October 2012 00:20
Subject: Errors on pg_dumpall
To: pgsql-admin-owner@xxxxxxxxxxxxxx
Hi
I am getting the following error msg when I do a pg_dumpall
-----
TK@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
