<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'llbe able to do <br /><br />pg_ctl -D /path/to/database status<br /><br />Robert Treat <br
/></div><div> </div></div><div>HelloAll,</div><div> Thanks to Robert. I have set the above things but SQL-ledger is
givingdifferent 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
defaultRH Linux Installation. I did not install externally.( so the path will be
/usr/bin./usr/lib)</div><div> </div><div>Ihave set the variables as suggested in the postgressql.conf file. But i am
nowgetting 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>andalso</div><div>bash-2.05a$ initdb<br />The files belonging to this database system
willbe owned by user "postgres".<br />This user must also own the server process.</div><div>initdb: The directory
/usr/lib/pgsqlexists but is not empty.<br />If you want to create a new database system, either remove or empty<br
/>thedirectory /usr/lib/pgsql or run initdb with<br />an argument other than /usr/lib/pgsql. </div><div> </div><div>I
haveset PGDATA =/usr/lib/pgsql and there is no directory by name data. Should i create a new Directory by name data and
initialisethis. Please advice.</div><div> </div><div>Thank and
regards,</div><div>Vivek</div><div> </div><div> </div><div> </div><div> </div></div><brclear="all" /><hr />Help STOP
SPAMwith <a href="http://g.msn.com/8HMEEN/2731">the new MSN 8 </a> and get 2 months FREE*
