Thread: pgsql on win xp user permissions

I want to setup a database that will be used by my php application.  Right
now I installed postgresql, I used an admin account to install it on a user
account.  So I can only access the database (like psql dbname) when i'm
logged in as the user, if i try psql from admin it says fatal role "admin
name" does not exist.  Is this how its supposed to be?  I am creating a php
application that is powered by apache.  I can work from admin account
because in php scripts I connect to database using a different user name and
so pgsql should not wine about admin accessing it eh?

You'll need to create a separate psql user.

See http://www.postgresql.org/docs/8.1/static/sql-createrole.html

Then get your php script to connect with that username/password.

Trans Porter wrote:
> I want to setup a database that will be used by my php application.  Right
> now I installed postgresql, I used an admin account to install it on a user
> account.  So I can only access the database (like psql dbname) when i'm
> logged in as the user, if i try psql from admin it says fatal role "admin
> name" does not exist.  Is this how its supposed to be?  I am creating a php
> application that is powered by apache.  I can work from admin account
> because in php scripts I connect to database using a different user name and
> so pgsql should not wine about admin accessing it eh?