[postgis-users] PostGIS and Mapserver

[Ezequias Rodrigues da Rocha]

I didn't find the pg_ctl

I am using postgres 8.0

Ezequias

david techer wrote:

> Hi Ezequias
>
> It seems that there is no TCP/IP available..
>
> Who do u launch PostgreSQL?
>
> Two solutions?
>
> solution 1:
>
> With pg_ctl do
>
> pg_ctl -o -i start
>
> to able tcp/ip connexion
>
> solution 2:
>
> or open postgresql.conf from your PostgreSQL data directory
>
> and replace listen_addresses = 'localhost' by
>
> listen_addresses = '*'
>
> then pg_ctl restart
>
>
> Ezequias Rodrigues da Rocha wrote:
>
>> Hi list,
>>
>> I am trying to access postgis via mapserver (a cgi server) but the 
>> resoult is allways a problem. Could anobody take a look on my problem ?
>>
>> the stack trace is shown below:
>>
>> msDrawMap(): Image handling error. Failed to draw layer named 'bairros'.
>> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with 
>> connect string 'user=postgres password=pt dbname=db1 
>> host=myserver.mydomain port=5432'.
>> Error reported was 'could not create socket: Permission denied '.
>> This error occured when trying to make a connection to the specified 
>> postgresql server.
>> Most commonly this is caused by
>> (1) incorrect connection string
>> (2) you didnt specify a 'user=...' in your connection string
>> (3) the postmaster (postgresql server) isnt running
>> (4) you are not allowing TCP/IP connection to the postmaster
>> (5) your postmaster is not running on the correct port - if its not 
>> on 5432 you must specify a 'port=...'
>> (6) the security on your system does not allow the webserver (usually 
>> user 'nobody') to make socket connections to the postmaster
>> (7) you forgot to specify a 'host=...' if the postmaster is on a 
>> different machine
>> (8) you made a typo
>>
>> My best regards
>> Ezequias
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>     
>
>     
>        
> ___________________________________________________________________________ 
> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! 
> Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>