Hi.
To access postgres set pg_hba.conf like this:
host all all 0.0.0.0 0.0.0.0 md5
This will allow any user from any IP to connect.
nd: «md5» sets the authentication mode, check the PG documentation for
alternative methods (if you need them).
Cheers,
Andrea
On Tue, 2006-09-19 at 13:00 +0200, Josef Springer wrote:
> Hi Magnus,
>
> i must explain my users how to maintain.
> The menu opens the dialog pgAdminIII - Backend Access Configuration
> Editor with 6 colomns:
> Type
>
> Database
>
> User
>
> IP-Address
>
> Method
>
> Option
>
> host
>
> all
>
> all
>
> 127.0.0.1/32
>
> md5
>
>
>
> host
>
> all
>
> all
>
> ::1/128
>
> md5
>
>
>
>
> Is all required option set ? If no, what is required to access from
> any client ?
>
> Josef
>
> Magnus Hagander wrote:
> > Edit postgresql.conf and set a listen_addresses that's not just
> > localhost. Then edit pg_hba.conf and add permissions based on the soruce
> > address of the connection. There are sections in the manual that will
> > explain the details of what you have to put there.
> >
> > //Magnus
> >
> > > -----Original Message-----
> > > From: Josef Springer [mailto:Josef.Springer@joops.com]
> > > Sent: Tuesday, September 19, 2006 12:18 PM
> > > To: Magnus Hagander
> > > Cc:
> > > Subject: Re: [ADMIN] Where is the msi-setup described ?
> > >
> > > Hi Magnus,
> > >
> > > thanks for quick answer. I have installed PostgreSQL 8.1 on the
> > > server without the option Accept connections on all addreses, not
> > > just localhost . I want to connect from a client. How can this
> > > option be switched on without a new installation of the server ?
> > >
> > > Josef
> > >
> > > Magnus Hagander wrote:
> > >
> > >
> > > Hi folks,
> > >
> > >
> > > where do i get documentation about the msi-setup
> > > dialogs for
> > > Windows plaforms ?
> > >
> > >
> > > http://pginst
> > > aller.projects.postgresql.org
> > >
> > > //Magnus
> > >
> > >
> > > ---------------------------(end of broadcast)----------------
> > > -----------
> > > TIP 9: In versions below 8.0, the planner will ignore your
> > > desire to
> > > choose an index scan if your joining column's
> > > datatypes do not
> > > match
> > >
> > >
> > >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >
--
Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>