Postgres Pro
Downloads
Home   >   mailing lists

Thread: Duplicate databases...

Duplicate databases...

From
"Dominic J. Eidson"
Date:
dominic=# \l   List of databases  Database    |  Owner   
---------------+----------aleal         | alealarivera       | ariverabbeyer        | bbeyerbrandon       |
brandonbrandon      | postgresdominic       | dominicds3           | agouldkeystone      | dominickperoni       |
kperonimgrooms      | mgroomspostgres      | brandon    <-- Incorrectpostgres      | postgressmc_is_neteng |
dominictemplate1    | brandon    <-- Incorrecttemplate1     | postgreswwwrun        | brandon    <-- Incorrectwwwrun
   | 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/

Re: Duplicate databases...

From
"Dominic J. Eidson"
Date:
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
gccegcs-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/

Re: Duplicate databases...

From
Tom Lane
Date:
Vacuuming pg_database should make the bogus entries go away ...
        regards, tom lane

Re: Duplicate databases...

From
Tom Lane
Date:
"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

Re: Duplicate databases...

From
"Dominic J. Eidson"
Date:
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/