From: | "Dinesh Pandey" <dpandey(at)secf(dot)com> |
---|---|
To: | "'Sean Davis'" <sdavis2(at)mail(dot)nih(dot)gov>, "'Frank Habermann'" <postgres(at)lordlamer(dot)de>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: user connection over tcp |
Date: | 2005-04-18 13:47:36 |
Message-ID: | 20050418135117.7E5E653818@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
On Behalf Of Sean Davis
Sent: Monday, April 18, 2005 7:13 PM
To: Frank Habermann; pgsql-sql(at)postgresql(dot)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(at)lordlamer(dot)de>
To: <pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-04-18 13:50:54 | Re: [SQL] How to add 1 hour in a date or time stamp? |
Previous Message | Sean Davis | 2005-04-18 13:42:59 | Re: user connection over tcp |