Thread: 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 phppgadmini need the for my user the right password to connect. but the manual says that every password will accepted. whyisnt 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 thatusers with right password can connect. but this doesnt work here. can somebody explain me whats wrong with me or my postgre?! thx frank habermann
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" <postgres@lordlamer.de> 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 >
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: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] 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" <postgres@lordlamer.de> 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 majordomo@postgresql.orgso that your message can get through to the mailing list cleanly
hello again. ok. i can connect over tcp!!! this works! my problem is that i only can connect with trust! if i use password i cant connect.with trustmode i need the right password for the user! frank -- Original-Nachricht -- Von: "Frank Habermann" <postgres@lordlamer.de> An: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org> Datum: Montag 18 April 2005 15:31:10 Betreff: 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 phppgadmini need the for my user the right password to connect. but the manual says that every password will accepted. whyisnt 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 saysthat 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 >