Debian and Postgres 9.0

[Alexandre Cavalcante Alencar]

Greatings,

There is no much difference from Debian to another distro... by default, all
connections from localhost is allowed using ident or md5 authentication.

If you want to allow access from another host, you must edit
/etc/postgresql/9.0/main/pg_hba.conf to add new access rules, for example,
if you want to allow access to john for sports from 172.16.1.15, you need to
add a new line and reload master (pg_ctl reload)...

host sports john 172.16.1.15/32 md5

Sds

Alexandre Alencar
http://blog.alexandrealencar.net/
http://www.alexandrealencar.net/
COBIT, ITIL, CSM, LPI, MCP-I



On Tue, Apr 19, 2011 at 9:38 AM, William O'Higgins Witteman <
william.ohiggins-H217xnMUJC0sA/PxXw9srA at public.gmane.org> wrote:

> Has anyone got experience with Debian and Postgres 9.0?  I have never
> used Postgres before, but I foolishly thought it would be simple.  I'm
> just trying to get started - database server available on localhost and
> the ability to create databases and run SQL.
>
> All of the tutorials seem to be subtly different, and Debian is
> different still, and the whole process has been quite frustrating.
> Anyone have some pointers?  Thanks.
> --
>
> yours,
>
> William
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/legacy/attachments/20110419/0b07f8dd/attachment.html>