[GRASSLIST:8143] Re:postgresql connection failes

orkun temiz at deprem.gov.tr
Wed Aug 31 03:34:00 EDT 2005


orkun wrote:

> 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.
>
>
>
hello

sorry for multiple mails

I found a answer to my last question.
using an soft link,  I can listen postgredb at the same time with grass 
and psql

is there any better way ?

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.




More information about the grass-user mailing list