Re: pg_dumpall storing multiple copies of DB's?

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-02-27 05:49:03
Message-ID: B497E910-2B45-11D6-A7FD-003065C4643E@medicalmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Wednesday, February 27, 2002, at 12:08 , Tom Lane wrote:

> If you happen to have multiple entries in pg_shadow with the same
> usesysid, then the SELECT will generate multiple rows for the matching
> databases.
>
> 7.2 has a unique index on pg_shadow.usesysid, so hopefully this failure
> mode is a thing of the past now. In the meantime, get rid of the extra
> pg_shadow entries and dump again.

Just checked pg_shadow, and each usesysid is unique. In pg_database,
every datlastsysoid is the same, 18539 - is that OK?

-Bill

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-27 05:52:15 Re: pg_dumpall storing multiple copies of DB's?
Previous Message Bill McGonigle 2002-02-27 05:46:08 Re: pg_dumpall storing multiple copies of DB's?