Edit "postgres.conf" and "pg_hba.conf" to access database from a remote machine
Edit "postgres.conf": ------------------------------------------ listen_addresse='*' Edit "pg_hba.conf": ------------------------------------------ host all all 10.1.11.54 255.255.255.0 trust Thanks Dinesh Pandey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Davis Sent: Monday, April 18, 2005 7:13 PM To: Frank Habermann; pgsql-sql@postgresql.org Subject: Re: [SQL] user connection over tcp Did you start the postmaster with -i to allow tcp connections? What is the error that you get when you try to connect? Sean ----- Original Message ----- From: "Frank Habermann" <[EMAIL PROTECTED]> To: <pgsql-sql@postgresql.org> Sent: Monday, April 18, 2005 9:31 AM Subject: [SQL] user connection over tcp > hello! > > i have some problems to understand the manual with pg_hba.conf. > > i use a tcp connection with phppgadmin to connect to the db. in my > pg_hba.conf i say for this connection trust! in phppgadmin i need the for > my user the right password to connect. but the manual says that every > password will accepted. why isnt that work at me? > > i also try password in pg_hba.conf for my tcpconnections. but after this i > cant connect to the db. but the manual says that users with right password > can connect. but this doesnt work here. > > can somebody explain me whats wrong with me or my postgre?! > > thx > > frank habermann > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
