Duplicate databases...

I just love to reply to myself..

On Fri, 6 Apr 2001, Dominic J. Eidson wrote:

[Snip]

postgres | brandon <-- Incorrect
postgres | postgres
smc_is_neteng | dominic
template1 | brandon <-- Incorrect
template1 | postgres
wwwrun | brandon <-- Incorrect
wwwrun | postgres
(17 rows)

Any idea what would cause this"

(The "<-- Incorrect" was added by me.. )

dominic=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)

--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/

Vacuuming pg_database should make the bogus entries go away ...

regards, tom lane

"Dominic J. Eidson" <sauron@the-infinite.org> writes:

postgres | brandon <-- Incorrect
postgres | postgres
smc_is_neteng | dominic
template1 | brandon <-- Incorrect
template1 | postgres
wwwrun | brandon <-- Incorrect
wwwrun | postgres
(17 rows)

Actually, I take that back, this isn't a connection-time issue...

On closer look, I'll bet that "brandon" and "postgres" have the
same usesysid assigned in pg_shadow. Need to change one of them.

regards, tom lane

On Fri, 6 Apr 2001, Tom Lane wrote:

On closer look, I'll bet that "brandon" and "postgres" have the
same usesysid assigned in pg_shadow. Need to change one of them.

That was it - both were 501.

Thanks.

--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/