Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_dumpall storing multiple copies of DB's?
Date
Msg-id 15677.1015343292@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dumpall storing multiple copies of DB's?  (Bill McGonigle <mcgonigle@medicalmedia.com>)
Responses Re: pg_dumpall storing multiple copies of DB's?  (Bill McGonigle <mcgonigle@medicalmedia.com>)
List pgsql-general
Tree view 
Bill McGonigle <mcgonigle@medicalmedia.com> writes:
> 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.

Indeed.  Did you perhaps have multiple pg_shadow entries matching the
database's datdba in the old installation?

            regards, tom lane

pgsql-general by date:

Previous
From: Fran Fabrizio
Date:
Subject: Re: storing intermediate results in recursive plpgsql functions
Next
From: Tom Lane
Date:
Subject: Re: storing intermediate results in recursive plpgsql functions