<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Here is what I did<br>
<br>
bourgogne@olivia:/home/david$ <font color="#ff0000">psql -d template1
-c "show data_directory"</font><br>
data_directory<br>
------------------------<br>
<font color="#3366ff"> /home/bourgogne/pgdata</font><br>
(1 ligne)<br>
<br>
bourgogne@olivia:/home/david$<font color="#009900"> pg_ctl</font> <font
color="#3333ff">-D /home/bourgogne/pgdata</font> <font
color="#009900">restart</font><br>
TRACE: Réception d'une demande d'arrêt intelligent<br>
TRACE: arrêt en cours<br>
en attente de l'arrêt du postmaster....TRACE: le système de base de
données est d'arrêté<br>
fait<br>
postmaster arrêté<br>
postmaster en cours de démarrage<br>
bourgogne@olivia:/home/david$ TRACE: le système de bases de données a
été arrêté à 2005-09-16 23:06:54 CEST<br>
TRACE: l'enregistrement du point de vérification est à 0/11446AF0<br>
TRACE: ré-exécution de l'enregistrement à 0/11446AF0 ; l'annulation de
l'enregistrement est à 0/0 ; arrêt TRUE<br>
TRACE: prochain identifiant de transaction : 19947 ; prochain OID :
509750<br>
TRACE: le système de bases de données est prêt<br>
<br>
bourgogne@olivia:/home/david$<br>
<br>
<br>
Ezequias Rodrigues da Rocha wrote:
<blockquote cite="mid432B1823.2040307@recife.pe.gov.br" type="cite">David,
<br>
<br>
I found pg_ctl.
<br>
<br>
I tryed
<br>
#./pg_ctl restart
<br>
<br>
See the resould and tell me what is wrong.
<br>
<br>
[postgres@mangueira bin]$ ./pg_ctl restart
<br>
pg_ctl: no database directory specified and environment variable PGDATA
unset
<br>
Try "pg_ctl --help" for more information.
<br>
[postgres@mangueira bin]$
<br>
<br>
sincerely
<br>
Ezequias
<br>
<br>
david techer wrote:
<br>
<br>
<blockquote type="cite">strange?
<br>
<br>
if U can connect to postgresql locally by doing (without ssh!)
<br>
<br>
psql -d db1 -U postgres -h myserver.mydomain
<br>
<br>
and
<br>
<br>
by ssh
<br>
<br>
<br>
psql db1
<br>
<br>
it means that TCP/IP are allowed!
<br>
<br>
<br>
did U succeed by ssh connection to find pg_ctl by doing
<br>
<br>
which pg_ctl
<br>
<br>
then do
<br>
<br>
to find where is postgresql.conf doing
<br>
<br>
psql -d template1 -c "show data_directory"
<br>
<br>
then
<br>
replace
<br>
<br>
listen_adresses = 'localhost' by listen_adresses = '*'
<br>
<br>
then
<br>
<br>
`which pg_ctl` restart
<br>
let me know
<br>
<br>
Ezequias Rodrigues da Rocha wrote:
<br>
<br>
<blockquote type="cite">from ssh terminal.
<br>
<br>
Locally the problem does not occours too.
<br>
<br>
see my steps
<br>
<br>
ssh root@server
<br>
password
<br>
psql db1
<br>
<br>
the psql prompt appears.
<br>
<br>
Ezequias
<br>
<br>
<br>
david techer wrote:
<br>
<br>
<blockquote type="cite">Hum!
<br>
<br>
do you use and type the command
<br>
<br>
psql -d dbpostgis -U ....
<br>
<br>
to the ssh connection (terminal) or from your local machine?
<br>
<br>
if U want to find pg_ctl path do
<br>
<br>
which pg_ctl
<br>
<br>
or
<br>
<br>
pg_config --bindir
<br>
<br>
<br>
Ezequias Rodrigues da Rocha wrote:
<br>
<br>
<blockquote type="cite">but I can enter on the db via ssh
connection.
<br>
<br>
This have any difference from entering via apache ?
<br>
<br>
Ezequias
<br>
<br>
Randy James wrote:
<br>
<br>
<blockquote type="cite">looks like the error for the fix
listed as number 4
<br>
<br>
--- Ezequias Rodrigues da Rocha <a class="moz-txt-link-rfc2396E" href="mailto:ezequias@recife.pe.gov.br"><ezequias@recife.pe.gov.br></a>
wrote:
<br>
<br>
<br>
<br>
<blockquote type="cite">Hi list,
<br>
<br>
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 ?
<br>
<br>
the stack trace is shown below:
<br>
<br>
msDrawMap(): Image handling error. Failed to draw layer named
'bairros'.
<br>
msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
connect string 'user=postgres password=pt dbname=db1
host=myserver.mydomain port=5432'.
<br>
Error reported was 'could not create socket: Permission denied '.
<br>
This error occured when trying to make a connection to the specified
postgresql server.
<br>
Most commonly this is caused by
<br>
(1) incorrect connection string
<br>
(2) you didnt specify a 'user=...' in your connection string
<br>
(3) the postmaster (postgresql server) isnt running
<br>
(4) you are not allowing TCP/IP connection to the postmaster
<br>
(5) your postmaster is not running on the correct port - if its not on
5432 you must specify a 'port=...'
<br>
(6) the security on your system does not allow the webserver (usually
user 'nobody') to make socket connections to the postmaster
<br>
(7) you forgot to specify a 'host=...' if the postmaster is on a
different machine
<br>
(8) you made a typo
<br>
<br>
My best regards
<br>
Ezequias
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
__________________________________ Yahoo! Mail - PC Magazine
Editors' Choice 2005 <a class="moz-txt-link-freetext" href="http://mail.yahoo.com">http://mail.yahoo.com</a>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
<br>
<br>
</blockquote>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
<br>
<br>
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo!
Messenger Téléchargez cette version sur <a class="moz-txt-link-freetext" href="http://fr.messenger.yahoo.com">http://fr.messenger.yahoo.com</a>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
<br>
<br>
<br>
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo!
Messenger Téléchargez cette version sur <a class="moz-txt-link-freetext" href="http://fr.messenger.yahoo.com">http://fr.messenger.yahoo.com</a>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
<br>
</body>
</html>