On Wed, 5 Dec 2001, Yanek Korff wrote:
> here's pg_user:
> usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
> passwd | valuntil
> ------------+----------+-------------+----------+----------+-----------+----
> ------+----------
> pgsql | 72 | t | t | t | t |
> ******** |
> os_user | 71 | t | f | t | t |
> ******** |
> user3 | 75 | f | f | f | f |
> ******** |
> user1 | 72 | f | f | f | f |
> ******** |
> user2 | 73 | f | f | f | f |
> ******** |
>
> where user1 should correspond to db1 etc.
>
> When I list my databases, it looks like this:
> List of databases
> Database | Owner
> ------------------+------------
> db2 | user2
> db1 | user1
> db1 | pgsql
> template0 | pgsql
> template0 | user1
> template1 | user1
> template1 | pgsql
> db3 | user3
>
>
> What's with the duplicate databases? Why does user1 own TEMPLATES? Clearly
> I have screwed something up. What's the proper way to fix it? As I see it,
> I should be able to create a user, create a database with that user...
> change that user to not be able to create databases, and then lock down the
> databases so other users cannot get in. This is possible, yes? I cannot
> find good documentation on this anywhere. Any help would be GREATLY
> appreciated.
You have two users with the same usesysid and it happens to be pgsql and
user1 that conflict.