
dominic=# \l
    List of databases
   Database    |  Owner   
---------------+----------
 aleal         | aleal
 arivera       | arivera
 bbeyer        | bbeyer
 brandon       | brandon
 brandon       | postgres
 dominic       | dominic
 ds3           | agould
 keystone      | dominic
 kperoni       | kperoni
 mgrooms       | mgrooms
 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 J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/


Fri, 6 Apr 2001 13:47:06 -0500 (CDT)
"Dominic J. Eidson" <sauron@the-infinite.org>
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/


Fri, 6 Apr 2001 13:51:28 -0500 (CDT)
"Dominic J. Eidson" <sauron@the-infinite.org>
Re: Duplicate databases...
Vacuuming pg_database should make the bogus entries go away ...

			regards, tom lane

Fri, 06 Apr 2001 16:55:08 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Duplicate databases... 
"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

Fri, 06 Apr 2001 16:56:32 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Duplicate databases... 
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/


Fri, 6 Apr 2001 16:30:45 -0500 (CDT)
"Dominic J. Eidson" <sauron@the-infinite.org>
Re: Duplicate databases... 