[postgis-users] postgis & php

[Paul Scott]

On Tue, 2006-04-04 at 13:22 -0600, Graham Stewart wrote:
> Nelson,
> 
> It looks like pgsql2shp is trying to access the database as the user
> that your webserver runs as. You'll either need to change your postgres
> configuration to create a user called www or perhaps change the code to
> use the -u and -P flags to specify an alternate postgres login.
> 

Absolutely Graham, thanks! Sorry, being on the other side of the pond in
South Africa sometimes makes it difficult to answer questions quickly!

Nelson,

In my first reply, I said that the script will execute the queries
against the db as the web user, so you need to create that user with
relevant permissions on the db you are working with to do the job.

--Paul