[GRASSLIST:8126] Re:postgresql connection failes

[Markus Neteler]

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