[GRASSLIST:8145] Re:Re:postgresql connection failes

Michele michele.rocc at libero.it
Wed Aug 31 04:13:33 EDT 2005


> >>> Michele wrote:
> >>>>>> 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
> >> 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.
> >
> 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

This looks to me strange, indeed I can use both psql and Grass to connect to postgres without doing your trik, maybe reinstalling postgres and grass you unintetionally changed some config or variable related to the port postgres/grass/your_system uses.
Again informations you send are too weak to understand where the problem came from...anyway now it works :-) and I thinks it'll work in another machine with a fresh intall, BTW where did you compile? Linux (distribution?) cywin?

Michele.





____________________________________________________________
Libero Flat, sempre a 4 Mega a 19,95 euro al mese! 
Abbonati subito su http://www.libero.it





More information about the grass-user mailing list