pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: pg_dump error
5+ messages / 5 participants
[nested] [flat]
* Re: pg_dump error
@ 2003-07-29 15:59 Vasko Miovski <vasko.miovski@cybertechne.com>
0 siblings, 0 replies; 5+ messages in thread
From: Vasko Miovski @ 2003-07-29 15:59 UTC (permalink / raw)
To: pgsql-bugs
Hi
I get this error when I try to backup my DB
C:\cygwin\bin>pg_dump -f nji.dump -F p NJI
pg_dump: [archiver (db)] connection to database "NJI" failed: server
closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Any help is appreciated
V
^ permalink raw reply [nested|flat] 5+ messages in thread
* pg_dump Error
@ 2004-01-30 13:40 yogesh sailukar <sailukar_yogesh@yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: yogesh sailukar @ 2004-01-30 13:40 UTC (permalink / raw)
To: pgsql-bugs
Hello Sir !
I am really greate ful for Postgresql. It's realy a good open source database. I am using it from six months. But now a days I am getting one strange error while using pg_dump.i.e. while dumping the data from the database.
I have created procedural language through CREATELANG command.Procedural language is PLPGSQL.Now i am getting Error while dumping the data in plain text format regarding the procedural language , though i have created the language.Error is given bellow.
pg_dump: procedural language for function fun_update_tptype_master not found
Waiting for positive respoce from your side.
Regards,
Yogesh.
---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
^ permalink raw reply [nested|flat] 5+ messages in thread
* pg_dump: error
@ 2023-02-22 16:17 Alessandro Papa - Infolab <a.papa@infolabonline.com>
0 siblings, 2 replies; 5+ messages in thread
From: Alessandro Papa - Infolab @ 2023-02-22 16:17 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; +Cc: Silvio Scattaglia - Infolab <s.scattaglia@infolabonline.com>
Hi, i have a PostgreSQL db with 9.8 version,
When I try to make a backup I get this error:
<pg_dump: error: schema with OID 2535211008 does not exist>
I had already searched on the table "pg_conversion" but didn't find that OID, idem on "pg_namespace" or "pg_type"
I had searched on forum but I have not found anything.
Thank you for your help
Disclaimer :
Le informazioni contenute nella presente comunicazione e i relativi allegati possono contenere informazioni riservate e sono, comunque, destinate dalla Infolab s.n.c. esclusivamente alle persone o alla Societ? destinatarie del messaggio stesso. Qualsiasi utilizzo non autorizzato del presente messaggio e/o dei suoi allegati da parte di qualsiasi soggetto diverso dal destinatario ? proibita, sia ai sensi dell'art. 616 c.p., che ai sensi del D.Lgs. n. 196/2003. Se avete ricevuto questo messaggio per errore, vi preghiamo di distruggerlo e di informarci immediatamente per telefono allo +39 0523 716018 o inviando un messaggio all'indirizzo e-mail info@infolabonline.com <mailto:info@infolabonline.com>
This message contains confidential information and is intended only for the Recipients. If you are not the Recipients you should not disseminate, distribute or copy this e-mail. Please notify info@infolabonline.com <mailto:info@infolabonline.com> immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Infolab therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump: error
@ 2023-02-22 16:44 David G. Johnston <david.g.johnston@gmail.com>
parent: Alessandro Papa - Infolab <a.papa@infolabonline.com>
1 sibling, 0 replies; 5+ messages in thread
From: David G. Johnston @ 2023-02-22 16:44 UTC (permalink / raw)
To: Alessandro Papa - Infolab <a.papa@infolabonline.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; Silvio Scattaglia - Infolab <s.scattaglia@infolabonline.com>
On Wed, Feb 22, 2023 at 9:39 AM Alessandro Papa - Infolab <
a.papa@infolabonline.com> wrote:
> Hi, i have a PostgreSQL db with 9.8 version,
>
> When I try to make a backup I get this error:
>
> <pg_dump: error: schema with OID 2535211008 does not exist>
>
>
>
> I had already searched on the table “pg_conversion” but didn’t find that
> OID, idem on “pg_namespace” or “pg_type”
>
> I had searched on forum but I have not found anything.
>
>
>
> Thank you for your help
>
>
>
"Version 9.8" isn't one of our release versions.
But if your catalog is corrupted that is not good and may require invasive
surgery. But in any case this is not a valid bug report. Please ask for
assistance in repairing your system in a more appropriate forum - the
pgsql-admin list being probably the most appropriate choice.
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump: error
@ 2023-02-22 17:15 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: Alessandro Papa - Infolab <a.papa@infolabonline.com>
1 sibling, 0 replies; 5+ messages in thread
From: Alvaro Herrera @ 2023-02-22 17:15 UTC (permalink / raw)
To: Alessandro Papa - Infolab <a.papa@infolabonline.com>; +Cc: pgsql-admin@lists.postgresql.org, Silvio Scattaglia - Infolab <s.scattaglia@infolabonline.com>
CCing pgsql-admin, removed -bugs.
On 2023-Feb-22, Alessandro Papa - Infolab wrote:
> Hi, i have a PostgreSQL db with 9.8 version,
You'll have to figure out exactly what version it is, because 9.8 it is
not.
> When I try to make a backup I get this error:
> <pg_dump: error: schema with OID 2535211008 does not exist>
>
> I had already searched on the table "pg_conversion" but didn't find that OID, idem on "pg_namespace" or "pg_type"
> I had searched on forum but I have not found anything.
A reference to a schema could come from almost any other catalog, not
just pg_conversion. (Note that a "namespace" is essentially the same as
a "schema" in our usage). That particular error in the 9.6.24 pg_dump
source could come from
1 4218 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTypes>>
2 4432 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getOperators>>
3 4519 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getCollations>>
4 4600 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getConversions>>
5 4765 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getOpclasses>>
6 4853 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getOpfamilies>>
7 5060 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getAggregates>>
8 5328 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getFuncs>>
9 6114 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTables>>
10 8450 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSParsers>>
11 8534 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSDictionaries>>
12 8615 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSTemplates>>
13 8693 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getTSConfigurations>>
14 9142 /pgsql/source/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c <<getDefaultACLs>>
which are the places that call findNamespace, where the error message
appears.
Give that a look and see if any clues arise. You can follow up here
afterwards for more ...
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-02-22 17:15 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-29 15:59 Re: pg_dump error Vasko Miovski <vasko.miovski@cybertechne.com>
2004-01-30 13:40 pg_dump Error yogesh sailukar <sailukar_yogesh@yahoo.com>
2023-02-22 16:17 pg_dump: error Alessandro Papa - Infolab <a.papa@infolabonline.com>
2023-02-22 16:44 ` Re: pg_dump: error David G. Johnston <david.g.johnston@gmail.com>
2023-02-22 17:15 ` Re: pg_dump: error Alvaro Herrera <alvherre@alvh.no-ip.org>
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