Thread: created databases as other users...

created databases as other users...

From
Jonathan Villa
Date:
Is it possible to create a database to be owned by a user that only
exists to postgresql or do they have to be shell accounts as well.

$ createdb --owner=testcon testdb

but the owner ends up being postgres

I'm planning to create a different database for each different project I
have.  I want these users to be only used to connect to the db, not have
a shell account.  So far, my only experience has been on a closed
network where all users already have shell access.




Re: created databases as other users...

From
Tom Lane
Date:
Jonathan Villa <jvilla@innovativesource.net> writes:
> $ createdb --owner=testcon testdb
> but the owner ends up being postgres

I don't think so.

$ createuser testcon
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
$ createdb --owner=testcon testdb
CREATE DATABASE
$ psql -l
        List of databases
    Name    |  Owner  | Encoding
------------+---------+-----------
 pltest     | tgl     | SQL_ASCII
 regression | tgl     | SQL_ASCII
 template0  | tgl     | SQL_ASCII
 template1  | tgl     | SQL_ASCII
 testdb     | testcon | SQL_ASCII
(5 rows)

$

            regards, tom lane

Re: created databases as other users...

From
Jonathan Villa
Date:
For some reason, I never tried

$psql --username=testcon testdb

I'm trying to use phpPGAdmin at the same time...I guess I was having a
tough time using both...

thanks Tom for the reply.


On Mon, 2004-10-11 at 16:01, Tom Lane wrote:
> Jonathan Villa <jvilla@innovativesource.net> writes:
> > $ createdb --owner=testcon testdb
> > but the owner ends up being postgres
>
> I don't think so.
>
> $ createuser testcon
> Shall the new user be allowed to create databases? (y/n) n
> Shall the new user be allowed to create more new users? (y/n) n
> CREATE USER
> $ createdb --owner=testcon testdb
> CREATE DATABASE
> $ psql -l
>         List of databases
>     Name    |  Owner  | Encoding
> ------------+---------+-----------
>  pltest     | tgl     | SQL_ASCII
>  regression | tgl     | SQL_ASCII
>  template0  | tgl     | SQL_ASCII
>  template1  | tgl     | SQL_ASCII
>  testdb     | testcon | SQL_ASCII
> (5 rows)
>
> $
>
>             regards, tom lane