| From: | Bill McGonigle <mcgonigle(at)medicalmedia(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dumpall storing multiple copies of DB's? |
| Date: | 2002-03-05 14:25:11 |
| Message-ID: | CD4BBCF0-3044-11D6-9492-003065EAE3C0@medicalmedia.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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" (
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnson, Shaunn | 2002-03-05 14:57:35 | SQL and parse errors |
| Previous Message | Bruno Wolff III | 2002-03-05 13:45:59 | Re: Newbie question re SQL |