Remote Postgres access??

Linas Vepstas linas@linas.org
Tue, 26 Jun 2001 11:40:19 -0500


On Mon, Jun 25, 2001 at 09:40:07PM -0400, Mattias Hembruch was heard to rem=
ark:
> Linas Vepstas wrote:
> >=20
> > On Mon, Jun 25, 2001 at 08:53:57PM -0400, Mattias Hembruch was heard to=
 remark:
> > >
> > > Thanks. I was going to try that anyway as soon as I get another machi=
ne up
> > > and running..
> >=20
> > for testing, you can 'fake it' with one machine:  using
> > the hostname or the numeric ip address causes tcpip instead of
> > unix domain to be used.
>=20
> I just wasn't sure if that would reveal all user/password problems. Thanks
> for the tip.

It should ... but that depends very much how you set up hba.conf
If you marke a certain host (such as yourself) trusted, then clearly
it won't behave the same way as other untrusted hosts.

I find the problem of managing user permissions for gnucash users
when they are accessing a remote sql database somewhat scary.
To make this work right will require sql db admins who are knowledgable ...

--linas