pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem doing pg_dumpall
3+ messages / 2 participants
[nested] [flat]

* Problem doing pg_dumpall
@ 2003-11-21 13:05  alvaro@audifarma.com.co
  0 siblings, 1 reply; 3+ messages in thread

From: alvaro@audifarma.com.co @ 2003-11-21 13:05 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I got this error when I run pg_dump:

# pg_dumpall > data_dump
pg_dump: could not find namespace with OID 102548365
pg_dumpall: pg_dump failed on dbsa, exiting

# pg_dump -d dbsa > data_dump
pg_dump: could not find namespace with OID 102548365

# pg_dumpall -v > data_dump
pg_dumpall: dumping database "dbsa"...
pg_dumpall: running pg_dump  -v -X use-set-session-authorization -Fp 'dbsa'
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user-defined types
pg_dump: could not find namespace with OID 102548365
pg_dump: *** aborted because of error
pg_dumpall: pg_dump failed on dbsa, exiting

How can I solve this problem?

How can I tell what is the OID 102548365? is it related to an index or a
table or what?

I search the web looking for answers to these questions but I cludn't find
them.

Thanks a lot for you help,

Alvaro




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Problem doing pg_dumpall
@ 2003-11-23 18:48  Tom Lane <tgl@sss.pgh.pa.us>
  parent: alvaro@audifarma.com.co
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2003-11-23 18:48 UTC (permalink / raw)
  To: alvaro@audifarma.com.co; +Cc: pgsql-admin

alvaro@audifarma.com.co writes:
> # pg_dumpall > data_dump
> pg_dump: could not find namespace with OID 102548365
> pg_dumpall: pg_dump failed on dbsa, exiting

Hm.  It would seem that you have an invalid namespace link in one of the
other system catalogs.  You could try doing
	select * from pg_class where relnamespace = 102548365;
	select * from pg_type where typnamespace = 102548365;
	select * from pg_proc where pronamespace = 102548365;
etc until you find the problem.  (Your trace suggests that pg_type is
where the problem is, but that's not certain.)

Where we go after that depends on what you find.  I'd be wondering about
whether there is corruption elsewhere in the same catalog ...

Also, what PG version is this exactly?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Problem doing pg_dumpall
@ 2004-04-15 22:06  alvaro@audifarma.com.co
  0 siblings, 0 replies; 3+ messages in thread

From: alvaro@audifarma.com.co @ 2004-04-15 22:06 UTC (permalink / raw)
  To: pgsql-admin

Hi,

As usual I wrote this email because I'm getting problems with posgtresql,
this time is with the pg_dumpall command, here´s the story:

We always make a copy of our database running

root@realserver#/var/lib/pgsql/bin/pg_dumpall > backup

It always worked fine but lately when I run this command It stops in the
middle of the process... because of the size of the backup file 2.5Gb
against 6Gb when doing it normally.

I looked at the tail of the backup file (#tail -100 backup | less)

And all I see is:

###########################################################################

-- TOC entry 442 (OID 18078)
-- Name: TABLE tbl_fact_sucursales; Type: COMMENT; Schema: public; Owner:
postgres
--

COMMENT ON TABLE tbl_fact_sucursales IS 'Archivo Plano de SIIGO, campo
sucursal';


--
-- TOC entry 457 (OID 18111)
-- Name: TABLE tbl_pg_errores_clases; Type: COMMENT; Schema: public;
Owner: postgres
--

COMMENT ON TABLE tbl_pg_errores_clases IS 'Tabla de clasificación de
errores reportados por postgresql, tomado del Apéndice A
.Error Codes de la docuemntación oficial de PostgreSQL ver 7.4.1';


\connect template1

--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

SET search_path = public, pg_catalog;

--
-- TOC entry 7 (OID 31515354)
-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema:
public; Owner: postgres
--

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;


SET SESSION AUTHORIZATION DEFAULT;

--
-- TOC entry 6 (OID 31515355)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
--

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 5 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


SET SESSION AUTHORIZATION DEFAULT;

--
-- TOC entry 3 (OID 1)
-- Name: DATABASE template1; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON DATABASE template1 IS 'Default template database';


SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 4 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';

###########################################################################

 The first two tables are part of our database the rest as I understand
are part of the database template1 which must exist in order to create
other datbases when need it.

I've checked at the running database using pgAdmin III and everything
apperars normal there are three DB mydatabase, template0 and template1,
the user postgres also exists and has proper rights.

Does anyone know what the problem is...? any ideas...?


PLAN B

By now I run /var/lib/pgsql/bin/pg_dump -d mydatabase > backup to make
backup copies, but when I recover that copy in other machine the
constrains and indexes dissaper, I follow this steps:

root@anothermachine#su postgres
$createdb mydatabase
$psql -d dbsa < backup

Do you think that I have to recover the schema and then all the data...?

I know that maybe this not a big deal  because in the worst case I can
create the Indexes and constraints manually, but I really want to know why
is that? Am I donig things wrong..?

I hope you can help me...

Thanks for taking some of your time to look at this message.


Bye

Alvaro Arcila
Pereira, Colombia (S.A.)







^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-04-15 22:06 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-21 13:05 Problem doing pg_dumpall alvaro@audifarma.com.co
2003-11-23 18:48 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-04-15 22:06 Problem doing pg_dumpall alvaro@audifarma.com.co

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