From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Yanek Korff <yanek(at)cigital(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: duplicate templates, wrong users |
Date: | 2001-12-06 16:08:02 |
Message-ID: | 20011206080640.I25449-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Yanek Korff | 2001-12-06 18:32:56 | Re: duplicate templates, wrong users |
Previous Message | Stephan Szabo | 2001-12-06 16:06:14 | Re: adding primary keys |
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2001-12-06 16:23:11 | Re: Installing DBD::Pg module without Pg Database server |
Previous Message | Tim Barnard | 2001-12-06 15:51:42 | Re: C interface libpq.so.2 problem |