[postgis-users] PostGIS and Mapserver

david techer davidtecher at yahoo.fr
Fri Sep 16 14:24:38 PDT 2005 

then do

pg_ctl -D /usr/local/pgsql/data restart


Ezequias Rodrigues da Rocha wrote:

> [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
>>  
>>
> _______________________________________________
> 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

More information about the postgis-users mailing list