Re: postgresql configuration and set-up

2004-03-21 Thread Oliver Elphick
On Wed, 2004-03-17 at 13:43, Tom Allison wrote: > [EMAIL PROTECTED] wrote: > > > As glenn posted, it seems like you need to setup the > > /etc/postresql/pg_hba.conf file. > > > > Oliver, I CC'ed you on this because I don't have a formal bugreport > utility working yet and thought it would helpf

Re: postgresql configuration and set-up

2004-03-21 Thread Oliver Elphick
On Wed, 2004-03-17 at 13:43, Tom Allison wrote: > [EMAIL PROTECTED] wrote: > > > As glenn posted, it seems like you need to setup the > > /etc/postresql/pg_hba.conf file. > > > > Oliver, I CC'ed you on this because I don't have a formal bugreport > utility working yet and thought it would helpf

Re: postgresql configuration and set-up

2004-03-17 Thread Tom Allison
I create tables as one user then I want another user to use those tables (like the web server). Then I need to GRANT access to every object in the database to that other user. http://www.postgresql.org/docs/7.4/static/groups.html This allows you to establish groups so that you can have Big_user

Re: postgresql configuration and set-up

2004-03-17 Thread Bill Moseley
On Wed, Mar 17, 2004 at 08:43:16AM -0500, Tom Allison wrote: Tom, I'm new to this so can I ask for some clarification? > login_usernames are associated with database usernames. Means access to > one means greater access to do damage. Security issue. You mean if user A creates a database then

Re: postgresql configuration and set-up

2004-03-17 Thread Tom Allison
[EMAIL PROTECTED] wrote: As glenn posted, it seems like you need to setup the /etc/postresql/pg_hba.conf file. Oliver, I CC'ed you on this because I don't have a formal bugreport utility working yet and thought it would helpful if you read this. What I ended up doing was throwing out the pg_hba.

Re: postgresql configuration and set-up

2004-03-16 Thread BillMoseley
On Tue, Mar 16, 2004 at 09:30:27PM -0500, Tom Allison wrote: > I'm trying to get debian's postgresql server running on a machine. > But I'm stuck on what the passwords are for the users I create. > createdb foo > createuser foouser > works just fine. > But how do I log in to the database foo as

Re: postgresql configuration and set-up

2004-03-16 Thread glenn
I think the secrets in the /etc/postgresql/pg_hba.conf file. If your coming from a mysql background, this will seem quite different. So using your example... [EMAIL PROTECTED]:su - postgres [EMAIL PROTECTED]:~$ createdb foo CREATE DATABASE [EMAIL PROTECTED]:~$ createuser foouser Shall the new user

postgresql configuration and set-up

2004-03-16 Thread Tom Allison
I'm trying to get debian's postgresql server running on a machine. But I'm stuck on what the passwords are for the users I create. createdb foo createuser foouser works just fine. But how do I log in to the database foo as user foouser? It says I need a password in the docs, But I have no clue w