[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