[postgis-users] PostGIS and Mapserver

Fri Sep 16 12:20:23 PDT 2005

[postgres at mangueira bin]$ psql -d template1 -c "show data_directory"
    data_directory
-----------------------
 /usr/local/pgsql/data
(1 registro) one record


Ezequias

david techer wrote:

> Here is what I did
>
> bourgogne at olivia:/home/david$ psql -d template1 -c "show data_directory"
>      data_directory
> ------------------------
>  /home/bourgogne/pgdata
> (1 ligne)
>
> bourgogne at olivia:/home/david$ pg_ctl -D  /home/bourgogne/pgdata restart
> TRACE:  Réception d'une demande d'arrêt intelligent
> TRACE:  arrêt en cours
> en attente de l'arrêt du postmaster....TRACE:  le système de base de 
> données est d'arrêté
>  fait
> postmaster arrêté
> postmaster en cours de démarrage
> bourgogne at olivia:/home/david$ TRACE:  le système de bases de données a 
> été arrêté à 2005-09-16 23:06:54 CEST
> TRACE:  l'enregistrement du point de vérification est à 0/11446AF0
> TRACE:  ré-exécution de l'enregistrement à 0/11446AF0 ; l'annulation 
> de l'enregistrement est à 0/0 ; arrêt TRUE
> TRACE:  prochain identifiant de transaction : 19947 ; prochain OID : 
> 509750
> TRACE:  le système de bases de données est prêt
>
> bourgogne at olivia:/home/david$
>
>
> Ezequias Rodrigues da Rocha wrote:
>
>> David,
>>
>> I found pg_ctl.
>>
>> I tryed
>> #./pg_ctl restart
>>
>> See the resould and tell me what is wrong.
>>
>> [postgres at mangueira bin]$ ./pg_ctl restart
>> pg_ctl: no database directory specified and environment variable 
>> PGDATA unset
>> Try "pg_ctl --help" for more information.
>> [postgres at mangueira bin]$
>>
>> sincerely
>> Ezequias
>>
>> david techer wrote:
>>
>>> strange?
>>>
>>> if U can connect to postgresql locally by doing (without ssh!)
>>>
>>> psql -d db1 -U postgres -h myserver.mydomain
>>>
>>> and
>>>
>>> by ssh
>>>
>>>
>>> psql db1
>>>
>>> it means that TCP/IP are allowed!
>>>
>>>
>>> did U succeed by ssh connection to find pg_ctl by doing
>>>
>>> which pg_ctl
>>>
>>> then do
>>>
>>> to find where is postgresql.conf doing
>>>
>>> psql -d template1 -c "show data_directory"
>>>
>>> then
>>> replace
>>>
>>> listen_adresses = 'localhost' by listen_adresses = '*'
>>>
>>> then
>>>
>>> `which pg_ctl` restart
>>> let me know
>>>
>>> Ezequias Rodrigues da Rocha wrote:
>>>
>>>> from ssh terminal.
>>>>
>>>> Locally the problem does not occours too.
>>>>
>>>> see my steps
>>>>
>>>> ssh root at server
>>>> password
>>>> psql db1
>>>>
>>>> the psql prompt appears.
>>>>
>>>> Ezequias
>>>>
>>>>
>>>> david techer wrote:
>>>>
>>>>> Hum!
>>>>>
>>>>> do you use and type the command
>>>>>
>>>>> psql -d dbpostgis -U ....
>>>>>
>>>>> to the ssh connection (terminal) or from your local machine?
>>>>>
>>>>> if U want to find pg_ctl path do
>>>>>
>>>>> which pg_ctl
>>>>>
>>>>> or
>>>>>
>>>>> pg_config --bindir
>>>>>
>>>>>
>>>>> Ezequias Rodrigues da Rocha wrote:
>>>>>
>>>>>> but I can enter on the db via ssh connection.
>>>>>>
>>>>>> This have any difference from entering via apache ?
>>>>>>
>>>>>> Ezequias
>>>>>>
>>>>>> Randy James wrote:
>>>>>>
>>>>>>> looks like the error for the fix listed as number 4
>>>>>>>
>>>>>>> --- Ezequias Rodrigues da Rocha <ezequias at recife.pe.gov.br> 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
>>>>>>>>
>>>>>>>>   
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>        __________________________________ Yahoo! Mail - PC 
>>>>>>> Magazine Editors' Choice 2005 http://mail.yahoo.com
>>>>>>> _______________________________________________
>>>>>>> postgis-users mailing list
>>>>>>> postgis-users at postgis.refractions.net
>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>
>>>>>>>  
>>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>>
>>>> _______________________________________________
>>>> 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
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>  
>