Re: pg_dumpall storing multiple copies of DB's? - Mailing list pgsql-general

From Bill McGonigle
Subject Re: pg_dumpall storing multiple copies of DB's?
Date
Msg-id CD4BBCF0-3044-11D6-9492-003065EAE3C0@medicalmedia.com
Whole thread Raw
In response to Re: pg_dumpall storing multiple copies of DB's?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses database problem..
Re: pg_dumpall storing multiple copies of DB's?
List pgsql-general
OK, I wrote a script to split the database backup where on '-- Selected
TOC Entries:' lines - from the head of each of those, this is
interesting.  If I'm reading this correctly, there are 3 copies of this
database 'studies' each with their own OID.

That feels not quite right.

-Bill


==> dboutput.1 <==
-- Selected TOC Entries:
--
\connect - postgres
--
-- TOC Entry ID 2 (OID 5187716)
--
-- Name: studies Type: TABLE Owner: postgres
--

CREATE TABLE "studies" (

==> dboutput.3 <==
-- Selected TOC Entries:
--
\connect - postgres
--
-- TOC Entry ID 2 (OID 7772205)
--
-- Name: studies Type: TABLE Owner: postgres
--

CREATE TABLE "studies" (

==> dboutput.4 <==
-- Selected TOC Entries:
--
\connect - postgres
--
-- TOC Entry ID 2 (OID 12941200)
--
-- Name: studies Type: TABLE Owner: postgres
--

CREATE TABLE "studies" (


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Newbie question re SQL
Next
From: Petre Daniel
Date:
Subject: database problem..