Re: Enable user access from remote host

On Wednesday 11 March 2009 1:29:18 pm Piotre Ugrumov wrote:
> On 11 Mar, 01:41, akla(dot)(dot)(dot)(at)comcast(dot)net (Adrian Klaver) wrote:
> > On Tuesday 10 March 2009 4:36:36 pm Piotre Ugrumov wrote:
> > > On 9 Mar, 02:22, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> > > > John R Pierce <pie(dot)(dot)(dot)(at)hogranch(dot)com> 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 any machine connected to any
> > > > > network which can be routed to the server in question as he was
> > > > > specifying a wildcard IP, and that includes anything that anyone
> > > > > could plug into any network port.
> > > >
> > > > Agreed, it's pretty stupid to use IDENT with a wildcard IP that
> > > > allows connections from untrusted networks.  I was just objecting to
> > > > the statement that it's unsafe in all cases.
> > > >
> > > >                         regards, tom lane
> > > >
> > > > --
> > > > Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> > > > To make changes to your
> > > > subscription:http://www.postgresql.org/mailpref/pgsql-general
> > >
> > > Hi,
> > > I inserted the following line:
> > >
> > > host    test           angelo      0.0.0.0/0          md5
> >
> > Did you pg_ctl reload to get the change noticed?
> >
> > > and in pgAdmin I insert
> > >
> > > angelo as user
> > > mypassword as password
> > > test as service
> > >
> > > and I left blank the SSL field.
> > >
> > > Moreover I have executed the following commands (before try to
> > > connect):
> > > sudo -u angelo psql template1
> > > then
> > > alter user angelo with encrypted password 'mypassword';
> > >
> > > But I have the same problems.
> > > Why?
> > > What do I wrong?
> > > Thanks, bye bye.
> >
> > --
> > Adrian Klaver
> > akla(dot)(dot)(dot)(at)comcast(dot)net
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> > To make changes to your
> > subscription:http://www.postgresql.org/mailpref/pgsql-general
>
> I restarted my xubuntu (where I installed postgresql) but I have the
> problem.
> Thanks, bye bye.

It is not necessary to restart the computer. As the Postgres superuser(usually
postgres) run the command pg_ctl with the appropriate parameter. In the case of
changes to pg_hba.conf it would be pg_ctl reload. This tells the Postgres
server to reload its conf files so it can take advantage of the changes. Some
conf parameters need a pg_ctl restart as they are only read at start up of the
server. The comments in the *.conf files help you with this (especially in
newer versions pf Postgres). Also look at for more information:
http://www.postgresql.org/docs/8.3/interactive/runtime-config.html
http://www.postgresql.org/docs/8.3/interactive/client-authentication.html
As to your particular problem I am going to need some more information. I went
back through the thread and cannot see any specific error messages. What
exactly is "the same problems"? Other question, can you connect locally?

--
Adrian Klaver
aklaver(at)comcast(dot)net