[GRASSLIST:8114] Re:postgresql connection failes

[orkun]

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
LOG:  database system was shut down at 2005-08-29 14:23:59 EEST
LOG:  checkpoint record is at 0/12C5AC04
LOG:  redo record is at 0/12C5AC04; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 5175; next OID: 3851158
LOG:  database system is ready

I can enter the database with :
psql sil

~~~~~~~~

But:
connection from grass to postgresql fails:

db.tables driver=pg database=sil
DBMI-Postgres driver error:
Cannot connect to Postgres: could not connect to server: No such file or 
directory
   Is the server running locally and accepting
   connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?


how can I solve the problem ?

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.