| From: | Chris <dmagick(at)gmail(dot)com> |
|---|---|
| To: | Trans Porter <iddd2(at)adsf(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgsql on win xp user permissions |
| Date: | 2006-02-03 02:52:07 |
| Message-ID: | 43E2C557.2000306@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-02-03 03:01:28 | Re: specifying unix domain socket name |
| Previous Message | Andrew - Supernews | 2006-02-03 02:25:03 | Re: 8.0.3 regexp_replace()... |