Re: pg_dumpall storing multiple copies of DB's?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill McGonigle <mcgonigle(at)medicalmedia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dumpall storing multiple copies of DB's?
Date: 2002-02-27 05:52:15
Message-ID: 20116.1014789135@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill McGonigle <mcgonigle(at)medicalmedia(dot)com> writes:
> Just checked pg_shadow, and each usesysid is unique.

Drat, another perfectly good theory down the drain.

Please look in the pg_dumpall script to see the query it uses to get the
list of database names, and run that query by hand to see if you get
duplicates. If so, can you figure out why?

> In pg_database, every datlastsysoid is the same, 18539 - is that OK?

Yes, that's expected.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2002-02-27 06:19:06 Re: configure --with-pam
Previous Message Bill McGonigle 2002-02-27 05:49:03 Re: pg_dumpall storing multiple copies of DB's?