[GRASSLIST:1396] postgreSQL problem

Uttam Kumar uttamkumar123 at hotmail.com
Thu Oct 2 09:36:20 EDT 2003


Hi GRASS users,
               I have downloaded the postgreSQL-7.3.4. I unzipped it and 
then went to the same dir of the postgresql and then installed it as 
follows:
1.)  ./configure  --prefix=/home/grass0pre3/psql 
--bindir=/home/grass0pre3/bin --without-readline
2.)  gmake
3.)  gmake check
4.)  gmake install-all-headers
5.)  gmake distclean

Then I wrote the following line in /etc/ldconfig "/home/grass0pre3/psql/lib" 
for the shared libraries.
Then I created a database and initialized it

root# mkdir /home/grass0pre3/psqldata
root# chown grass0pre3 /home/grass0pre3/psqldata
root# su grass0pre3
grass0pre3$ initdb -D /home/grass0pre3/psqldata

Lastly I started the server with

/home/grass0pre3/bin/postmaster -i -p 5432 -D /home/grass0pre3/psqldata 
 >logfile 2>&1 &

Now when I run

createdb abc
and then
g.select.pg database=abc

I get the following error...

Error: select Postgres:could not connect to server: Connection refused
        Is the server running on host localhost and accepting
        TCP/IP connections on port 5432?

an any body tell me the problem and its related solution or have I missed 
anything during installation.

Thanks,

uttam.

_________________________________________________________________
Three simple steps. They guarantee your safety. 
http://server1.msn.co.in/features/general/SMBvirus/index.asp Protect 
yourself against the SMB.EXE virus.




More information about the grass-user mailing list