created databases as other users...

From: Jonathan Villa <jvilla(at)innovativesource(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: created databases as other users...
Date: 2004-10-11 20:48:49
Message-ID: 1097527728.2833.94.camel@jonathan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-11 21:01:04 Re: created databases as other users...
Previous Message David Siebert 2004-10-11 16:27:11 Re: Activestate Perl and DBD-Pg?