[GRASSLIST:8142] Re:postgresql connection failes

[orkun]

Markus Neteler wrote:

>On Mon, Aug 29, 2005 at 02:51:37PM +0300, orkun wrote:
>  
>
>>Michele wrote:
>>
>>    
>>
>>>>>> Is the server running locally and accepting
>>>>>> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>>>>>>
>>>>>>What should be done else ?
>>>>>>
>>>>>> 
>>>>>>
>>>>>>      
>>>>>>
>>>>>>            
>>>>>>
>>>>>If you reinstall postgres from source you have to manually rebuild the 
>>>>>database directory, user, etc..
>>>>>
>>>>>
>>>>>You have to follow carefully this instructions:
>>>>>
>>>>>http://www.postgresql.org/docs/7.4/static/creating-cluster.html
>>>>>http://www.postgresql.org/docs/7.4/static/postmaster-start.html
>>>>>
>>>>>
>>>>>you will also have to create a new database user and remember to use the 
>>>>>database administrator user (eg postgres)
>>>>>
>>>>>postgres$ initdb -D /usr/local/pgsql/data
>>>>>^^^^^^^^
>>>>>
>>>>>to do administration task like starting and stopping the postmaster.
>>>>>
>>>>>Michele.
>>>>>
>>>>>
>>>>>
>>>>>    
>>>>>
>>>>>          
>>>>>
>>>>thank you
>>>>
>>>>I can run new postgresql  alone using postmaster and psql.
>>>>But grass cannot connect to new postgre, although I have
>>>>recompiled grass with new path of postgresql.
>>>>
>>>>
>>>>Ahmet
>>>>  
>>>>
>>>>        
>>>>
>>>Ahmet,
>>>
>>>If you followed the manpages above and you still have problems, please be 
>>>more specific about the steps you followed and error messages...
>>>
>>>Michele.
>>>
>>>
>>>
>>>
>>>____________________________________________________________
>>>Libero Flat, sempre a 4 Mega a 19,95 euro al mese! 
>>>Abbonati subito su http://www.libero.it
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>      
>>>
>>thank you again
>>
>>I reviewed the man pages.
>>But the problem goes on:
>>
>>(before I  realized your mail, I had sent  a new mail)
>>
>>I have no problem connecting to the database without grass:
>>postmaster and psql works seems to work properly.
>>
>>$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -p 5432
>>    
>>
>
>There is no -i flag which means that Postgresql doesn't work in
>TCP/IP mode. This can be enabled in postgresql.conf
>
>Markus
>
>
>
>  
>
thank you markus,

when I start postmaster with the port which grass is listening postgre 
db from
grass works on postgredb.

postgres at landslide:/home/orkun$ /usr/local/pgsql/bin/postmaster -i -D 
/usr/local/pgsql/data/   -k /var/ run/postgresql/

grass uses this port (/var/ run/postgresql/)
** how can I make grass listen postgresql from /tmp/.s.PGSQL.5432 ?

because at the same time I want to work on same db out of grass
with psql, but it gives:

postgres at landslide:/home/orkun$ /usr/local/pgsql/bin/psql  bzk
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


kind regards

Ahmet


______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster at deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.

Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.