Discussion:
Connecting to remote Database
(too old to reply)
Senthil Jegadeesan
2004-08-06 04:25:07 UTC
Permalink
I have to connect to a postgresql postmaster running in a system in the same nerwork.I started the postmaster with -i option and I changed the pg_hba.conf file to allow that system.but when using psql it tell user senthil not found(in server).senthil is my log in name for the client.I can not connect it through pgtcl.Can any body help me out for connecting through pgtcl.Is there any other way to connect without changing pg_hba.conf file?please reply this....Advanced Thanks for the replies :-)
--
India.com free e-mail - www.india.com.
Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes!

Powered by Outblaze

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
mike g
2004-08-06 04:43:00 UTC
Permalink
Hello,

Did you remember to create your account in the database that you are
connecting to. Unless that database is a copy of the one you normally
connect to your user name won't exist in it.

Mike
Post by Senthil Jegadeesan
I have to connect to a postgresql postmaster running in a system in the same nerwork.I started the postmaster with -i option and I changed the pg_hba.conf file to allow that system.but when using psql it tell user senthil not found(in server).senthil is my log in name for the client.I can not connect it through pgtcl.Can any body help me out for connecting through pgtcl.Is there any other way to connect without changing pg_hba.conf file?please reply this....Advanced Thanks for the replies :-)
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Loading...