Re: [GENERAL] Enable user access from remote host

2009-03-11 Thread Adrian Klaver
On Wednesday 11 March 2009 1:29:18 pm Piotre Ugrumov wrote: > On 11 Mar, 01:41, akla...@comcast.net (Adrian Klaver) wrote: > > On Tuesday 10 March 2009 4:36:36 pm Piotre Ugrumov wrote: > > > On 9 Mar, 02:22, t...@sss.pgh.pa.us (Tom Lane) wrote: > > > > John R Pierce writes: > > > > > Tom Lane wrot

Re: [GENERAL] Enable user access from remote host

2009-03-11 Thread Piotre Ugrumov
On 11 Mar, 01:41, akla...@comcast.net (Adrian Klaver) wrote: > On Tuesday 10 March 2009 4:36:36 pm Piotre Ugrumov wrote: > > > > > On 9 Mar, 02:22, t...@sss.pgh.pa.us (Tom Lane) wrote: > > > John R Pierce writes: > > > > Tom Lane wrote: > > > >> A more accurate statement is that it's trustworthy t

Re: [GENERAL] Enable user access from remote host

2009-03-10 Thread Adrian Klaver
On Tuesday 10 March 2009 4:36:36 pm Piotre Ugrumov wrote: > On 9 Mar, 02:22, t...@sss.pgh.pa.us (Tom Lane) wrote: > > John R Pierce writes: > > > Tom Lane wrote: > > >> A more accurate statement is that it's trustworthy to the extent that > > >> you trust the owner of the other machine to be runni

Re: [GENERAL] Enable user access from remote host

2009-03-10 Thread Piotre Ugrumov
On 9 Mar, 02:22, t...@sss.pgh.pa.us (Tom Lane) wrote: > John R Pierce writes: > > > Tom Lane wrote: > >> A more accurate statement is that it's trustworthy to the extent that > >> you trust the owner of the other machine to be running a non-broken > >> identd daemon.  Within a LAN it might be perf

Re: [GENERAL] Enable user access from remote host

2009-03-08 Thread Tom Lane
John R Pierce writes: > Tom Lane wrote: >> A more accurate statement is that it's trustworthy to the extent that >> you trust the owner of the other machine to be running a non-broken >> identd daemon. Within a LAN it might be perfectly reasonable to use. > you would have to extend that trust to

Re: [GENERAL] Enable user access from remote host

2009-03-08 Thread John R Pierce
Tom Lane wrote: John R Pierce writes: *HOWEVER* "ident sameuser" should *not* be used for HOST connections, its only reliable for LOCAL connections. A more accurate statement is that it's trustworthy to the extent that you trust the owner of the other machine to be running a non-bro

Re: [GENERAL] Enable user access from remote host

2009-03-08 Thread Tom Lane
John R Pierce writes: > *HOWEVER* "ident sameuser" should *not* be used for HOST connections, > its only reliable for LOCAL connections. A more accurate statement is that it's trustworthy to the extent that you trust the owner of the other machine to be running a non-broken identd daemon. Wit

Re: [GENERAL] Enable user access from remote host

2009-03-08 Thread John R Pierce
Piotre Ugrumov wrote: Hi, I inserted this line at the end of the pg_hba.conf hosttestangelo "" ident sameuser I inserted the "" to allow to everyone to access to the db. But if I try to access, from another host, I receive an error. What is the error in that line?

Re: [GENERAL] Enable user access from remote host

2009-03-08 Thread Andreas Wenk
Piotre Ugrumov schrieb: On 8 Mar, 02:08, pie...@hogranch.com (John R Pierce) wrote: Martin Gainty wrote: postgresql.conf : change listen_address to a real ip change it to '*' or you won't be able to use localhost... alternately, youc could specify ip.of.net.iface,localhost if you wanted t

Re: [GENERAL] Enable user access from remote host

2009-03-08 Thread Piotre Ugrumov
On 8 Mar, 02:08, pie...@hogranch.com (John R Pierce) wrote: > Martin Gainty wrote: > > postgresql.conf : > > change listen_address to a real ip > > change it to '*' or you won't be able to use localhost...  alternately, > youc could specify ip.of.net.iface,localhost   if you wanted to be specific.

Re: [GENERAL] Enable user access from remote host

2009-03-07 Thread John R Pierce
Martin Gainty wrote: postgresql.conf : change listen_address to a real ip change it to '*' or you won't be able to use localhost... alternately, youc could specify ip.of.net.iface,localhost if you wanted to be specific. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] Enable user access from remote host

2009-03-07 Thread Martin Gainty
ates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: afmul...@gmail.com > Subject: [

[GENERAL] Enable user access from remote host

2009-03-07 Thread Piotre Ugrumov
Hi, I installed postgresql (for the first time) in my xubuntu. I created an user and now I would connect, from remote host, to the db with that user. How can I enable the remote access for the user created? Thanks, bye bye. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To