pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFwd: Errors on pg_dumpall
8+ messages / 6 participants
[nested] [flat]
* Fwd: Errors on pg_dumpall
@ 2012-11-01 14:05 Terry Khatri <terrykhatri531@gmail.com>
2012-11-01 21:06 ` Re: Fwd: Errors on pg_dumpall Fernando Hevia <fhevia@gmail.com>
2012-11-02 08:06 ` Re: Fwd: Errors on pg_dumpall raghu ram <raghuchennuru@gmail.com>
2012-11-03 02:54 ` Re: Fwd: Errors on pg_dumpall Craig Ringer <ringerc@ringerc.id.au>
0 siblings, 3 replies; 8+ messages in thread
From: Terry Khatri @ 2012-11-01 14:05 UTC (permalink / raw)
To: pgsql-admin
Somebody PLEASE HELP ! is Tome Lane around !
Tks
T
---------- Forwarded message ----------
From: Terry Khatri <terrykhatri531@gmail.com>
Date: 22 October 2012 00:20
Subject: Errors on pg_dumpall
To: pgsql-admin-owner@postgresql.org
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
@ 2012-11-01 21:06 ` Fernando Hevia <fhevia@gmail.com>
2012-11-01 21:23 ` Re: Fwd: Errors on pg_dumpall Fernando Hevia <fhevia@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Fernando Hevia @ 2012-11-01 21:06 UTC (permalink / raw)
To: Terry Khatri <terrykhatri531@gmail.com>; +Cc: pgsql-admin
You are posting to the wrong list.
You should address this in the
pgsql-admin<http://archives.postgresql.org/pgsql-admin/;
list.
On Thu, Nov 1, 2012 at 11:05 AM, Terry Khatri <terrykhatri531@gmail.com>wrote:
> Somebody PLEASE HELP ! is Tome Lane around !
> Tks
> T
>
> ---------- Forwarded message ----------
> From: Terry Khatri <terrykhatri531@gmail.com>
> Date: 22 October 2012 00:20
> Subject: Errors on pg_dumpall
> To: pgsql-admin-owner@postgresql.org
>
>
> 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
>
>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
2012-11-01 21:06 ` Re: Fwd: Errors on pg_dumpall Fernando Hevia <fhevia@gmail.com>
@ 2012-11-01 21:23 ` Fernando Hevia <fhevia@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Fernando Hevia @ 2012-11-01 21:23 UTC (permalink / raw)
To: Terry Khatri <terrykhatri531@gmail.com>; +Cc: pgsql-admin
Oops. You were posting to the right list.
I took it for the pgAdmin list. Sorry. :)
On Thu, Nov 1, 2012 at 6:06 PM, Fernando Hevia <fhevia@gmail.com> wrote:
> You are posting to the wrong list.
> You should address this in the pgsql-admin<http://archives.postgresql.org/pgsql-admin/;
> list.
>
>
>
>
> On Thu, Nov 1, 2012 at 11:05 AM, Terry Khatri <terrykhatri531@gmail.com>wrote:
>
>> Somebody PLEASE HELP ! is Tome Lane around !
>> Tks
>> T
>>
>> ---------- Forwarded message ----------
>> From: Terry Khatri <terrykhatri531@gmail.com>
>> Date: 22 October 2012 00:20
>> Subject: Errors on pg_dumpall
>> To: pgsql-admin-owner@postgresql.org
>>
>>
>> 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
>>
>>
>>
>>
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
@ 2012-11-02 08:06 ` raghu ram <raghuchennuru@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: raghu ram @ 2012-11-02 08:06 UTC (permalink / raw)
To: Terry Khatri <terrykhatri531@gmail.com>; +Cc: pgsql-admin
>
>
> 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.
>
>
Below URL provides more information about this issue:
http://archives.postgresql.org/pgsql-bugs/2005-11/msg00307.php
--
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
@ 2012-11-03 02:54 ` Craig Ringer <ringerc@ringerc.id.au>
2012-11-05 09:09 ` Re: Fwd: Errors on pg_dumpall Lukasz Brodziak <lukasz.brodziak@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Craig Ringer @ 2012-11-03 02:54 UTC (permalink / raw)
To: Terry Khatri <terrykhatri531@gmail.com>; +Cc: pgsql-admin
On 11/01/2012 10:05 PM, Terry Khatri wrote:
> Somebody PLEASE HELP ! is Tome Lane around !
>
http://www.postgresql.org/support/professional_support/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
2012-11-03 02:54 ` Re: Fwd: Errors on pg_dumpall Craig Ringer <ringerc@ringerc.id.au>
@ 2012-11-05 09:09 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
2012-11-05 09:40 ` Re: Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Lukasz Brodziak @ 2012-11-05 09:09 UTC (permalink / raw)
To: Craig Ringer <ringerc@ringerc.id.au>; +Cc: Terry Khatri <terrykhatri531@gmail.com>; pgsql-admin
2012/11/3 Craig Ringer <ringerc@ringerc.id.au>:
> On 11/01/2012 10:05 PM, Terry Khatri wrote:
>
> Somebody PLEASE HELP ! is Tome Lane around !
>
>
> http://www.postgresql.org/support/professional_support/
Hi,
Run the following SELECT on the database: select oid,* from
pg_namespace this will bring up all the schemas in the db along with
the OIDs. Check what schema name is under the OID given in error then
try to delete all the referrences to this schema name from db and run
pg_dumpall again.
Of course before doing so stop the PostgreSQL server and make a copy
of the data folder just in case.
Regards
--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
2012-11-03 02:54 ` Re: Fwd: Errors on pg_dumpall Craig Ringer <ringerc@ringerc.id.au>
2012-11-05 09:09 ` Re: Fwd: Errors on pg_dumpall Lukasz Brodziak <lukasz.brodziak@gmail.com>
@ 2012-11-05 09:40 ` Terry Khatri <terrykhatri531@gmail.com>
2012-11-05 15:22 ` Re: Fwd: Errors on pg_dumpall Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Terry Khatri @ 2012-11-05 09:40 UTC (permalink / raw)
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>; +Cc: pgsql-admin
Hi
Okay, I have found a reference to that oid in pg_type as under :
select * from pg_type where typnamespace=74363 ;
-[ RECORD 1 ]--+-----------------
typname | city
typnamespace | 74363
typowner | 10
typlen | -1
typbyval | f
typtype | c
typcategory | C
typispreferred | f
typisdefined | t
typdelim | ,
typrelid | 74364
typelem | 0
typarray | 74365
typinput | record_in
typoutput | record_out
typreceive | record_recv
typsend | record_send
typmodin | -
typmodout | -
typanalyze | -
typalign | d
typstorage | x
typnotnull | f
typbasetype | 0
typtypmod | -1
typndims | 0
typcollation | 0
typdefaultbin |
typdefault |
typacl |
-[ RECORD 2 ]--+-----------------
typname | _city
typnamespace | 74363
typowner | 10
typlen | -1
typbyval | f
typtype | b
typcategory | A
typispreferred | f
typisdefined | t
typdelim | ,
typrelid | 0
typelem | 74366
typarray | 0
typinput | array_in
typoutput | array_out
typreceive | array_recv
typsend | array_send
typmodin | -
typmodout | -
typanalyze | array_typanalyze
typalign | d
typstorage | x
typnotnull | f
typbasetype | 0
typtypmod | -1
typndims | 0
typcollation | 0
typdefaultbin |
typdefault |
typacl |
Here is what I have in pg_namespace :
oid | nspname | nspowner | nspacl
-------+--------------------+----------+----------------------------
99 | pg_toast | 10 |
11194 | pg_temp_1 | 10 |
11195 | pg_toast_temp_1 | 10 |
11 | pg_catalog | 10 | {sns84=UC/sns84,=U/sns84}
2200 | public | 10 | {sns84=UC/sns84,=UC/sns84}
11459 | information_schema | 10 | {sns84=UC/sns84,=U/sns84}
82537 | world | 10 |
(7 rows)
What I should do next ?
Please help
Thanks
T
On 5 November 2012 14:09, Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote:
> 2012/11/3 Craig Ringer <ringerc@ringerc.id.au>:
> > On 11/01/2012 10:05 PM, Terry Khatri wrote:
> >
> > Somebody PLEASE HELP ! is Tome Lane around !
> >
> >
> > http://www.postgresql.org/support/professional_support/
>
> Hi,
>
> Run the following SELECT on the database: select oid,* from
> pg_namespace this will bring up all the schemas in the db along with
> the OIDs. Check what schema name is under the OID given in error then
> try to delete all the referrences to this schema name from db and run
> pg_dumpall again.
> Of course before doing so stop the PostgreSQL server and make a copy
> of the data folder just in case.
>
> Regards
>
> --
> Łukasz Brodziak
> "Do you bury me when I'm gone
> Do you teach me while I'm here
> Just as soon I belong
> Then it's time I disappear"
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: Errors on pg_dumpall
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
2012-11-03 02:54 ` Re: Fwd: Errors on pg_dumpall Craig Ringer <ringerc@ringerc.id.au>
2012-11-05 09:09 ` Re: Fwd: Errors on pg_dumpall Lukasz Brodziak <lukasz.brodziak@gmail.com>
2012-11-05 09:40 ` Re: Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
@ 2012-11-05 15:22 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2012-11-05 15:22 UTC (permalink / raw)
To: Terry Khatri <terrykhatri531@gmail.com>; +Cc: Lukasz Brodziak <lukasz.brodziak@gmail.com>; pgsql-admin
Terry Khatri <terrykhatri531@gmail.com> writes:
> Okay, I have found a reference to that oid in pg_type as under :
> select * from pg_type where typnamespace=74363 ;
Okay, so you have a composite type named "city" (either a table's
rowtype, or a standalone composite type --- hard to tell from just this
entry) that somehow escaped deletion when the containing schema was
deleted. Do you have an idea what triggered that? A reproducible test
case would be even better.
> What I should do next ?
Well, you can just manually delete those rows in pg_type, if you're sure
that there's nothing else linking to them. It might be safer to try to
do it as "drop type city" first.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2012-11-05 15:22 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-01 14:05 Fwd: Errors on pg_dumpall Terry Khatri <terrykhatri531@gmail.com>
2012-11-01 21:06 ` Fernando Hevia <fhevia@gmail.com>
2012-11-01 21:23 ` Fernando Hevia <fhevia@gmail.com>
2012-11-02 08:06 ` raghu ram <raghuchennuru@gmail.com>
2012-11-03 02:54 ` Craig Ringer <ringerc@ringerc.id.au>
2012-11-05 09:09 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
2012-11-05 09:40 ` Terry Khatri <terrykhatri531@gmail.com>
2012-11-05 15:22 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox