<html><div style='background-color:'><DIV>
<DIV>find your postgresql.conf file, look in there to make sure tcpip_socket<BR>= true.<BR><BR>the directory that file is in should be the same as the $PGDATA that<BR>your getting asked for, so you'll be able to do <BR><BR>pg_ctl -D /path/to/database status<BR><BR>Robert Treat <BR></DIV>
<DIV> </DIV></DIV>
<DIV>Hello All,</DIV>
<DIV> Thanks to Robert. I have set the above things but SQL-ledger is giving different error this time like :</DIV>
<DIV>FATAL 1: No pg_hba.conf entry for host 192.168.168.56, user sql-ledger, database template1</DIV>
<DIV> </DIV>
<DIV> I am using the preinstalled Postgres DB that came along with the default RH Linux Installation. I did not install externally.( so the path will be /usr/bin./usr/lib)</DIV>
<DIV> </DIV>
<DIV>I have set the variables as suggested in the postgressql.conf file. But i am now getting this error.</DIV>
<DIV>$ pg_ctl -D /usr/lib/pgsql start<BR>postmaster successfully started<BR>bash-2.05a$ FATAL 1: data directory /usr/lib/pgsql has group or world access; p<BR>ermissions should be u=rwx (0700) </DIV>
<DIV> </DIV>
<DIV>and also</DIV>
<DIV>bash-2.05a$ initdb<BR>The files belonging to this database system will be owned by user "postgres".<BR>This user must also own the server process.</DIV>
<DIV>initdb: The directory /usr/lib/pgsql exists but is not empty.<BR>If you want to create a new database system, either remove or empty<BR>the directory /usr/lib/pgsql or run initdb with<BR>an argument other than /usr/lib/pgsql. </DIV>
<DIV> </DIV>
<DIV>I have set PGDATA =/usr/lib/pgsql and there is no directory by name data. Should i create a new Directory by name data and initialise this. Please advice.</DIV>
<DIV> </DIV>
<DIV>Thank and regards,</DIV>
<DIV>Vivek</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></div><br clear=all><hr>Help STOP SPAM with <a href="http://g.msn.com/8HMEEN/2731">the new MSN 8 </a> and get 2 months FREE*</html>