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?
