Subject: Re: Where is the msi-setup described ?
From: Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
Reply-To: andrea.gozzi@linuxrevolution.eu
To: Josef.Springer@joops.com
Cc: pgsql-admin@postgresql.org
In-Reply-To: <450FCDBF.3070100@joops.com>
References: <450FAE7A.9070408@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C6@algol.sollentuna.se>
	<450FC3E0.2030001@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se>
	<450FCDBF.3070100@joops.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-GOzmSWvIyz63LJOMrHkx"
Date: Tue, 19 Sep 2006 13:19:21 +0200
Message-Id: <1158664761.4930.8.camel@osmosis.gnet.eu>
Mime-Version: 1.0


--=-GOzmSWvIyz63LJOMrHkx
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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: =ABmd5=BB 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,
>=20
> i must explain my users how to maintain.
> The menu opens the dialog pgAdminIII - Backend Access Configuration
> Editor with 6 colomns:
> Type=20
>=20
> Database=20
>=20
> User
>=20
> IP-Address
>=20
> Method
>=20
> Option
>=20
> host
>=20
> all
>=20
> all
>=20
> 127.0.0.1/32
>=20
> md5
>=20
>=20
>=20
> host
>=20
> all
>=20
> all
>=20
> ::1/128
>=20
> md5
>=20
>=20
>=20
>=20
> Is all required option set ? If no, what is required to access from
> any client ?
>              =20
> Josef      =20
>=20
> 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 soruc=
e
> > address of the connection. There are sections in the manual that will
> > explain the details of what you have to put there.
> >=20
> > //Magnus
> >=20
> > > -----Original Message-----
> > > From: Josef Springer [mailto:Josef.Springer@joops.com]
> > > Sent: Tuesday, September 19, 2006 12:18 PM
> > > To: Magnus Hagander
> > > Cc:=20
> > > Subject: Re: [ADMIN] Where is the msi-setup described ?
> > >=20
> > > Hi Magnus,
> > >=20
> > > 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 ?
> > >=20
> > > Josef
> > >=20
> > > Magnus Hagander wrote:
> > >=20
> > >=20
> > > 		Hi folks,
> > >=20
> > >=20
> > > 		where do i get documentation about the msi-setup
> > > dialogs for
> > > 		Windows plaforms  ?
> > >=20
> > >=20
> > > 	http://pginst
> > > aller.projects.postgresql.org
> > >=20
> > > 	//Magnus
> > >=20
> > >=20
> > > 	---------------------------(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
> > >=20
> > >=20
> > >=20
> >=20
> >=20
> > ---------------------------(end of broadcast)--------------------------=
-
> > TIP 4: Have you searched our list archives?
> >=20
> >                http://archives.postgresql.org
> >=20
> >=20

--=20
Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>

--=-GOzmSWvIyz63LJOMrHkx
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBFD9I4oIXRn+fZcV0RArZbAKCFtiFW1TNSj/m5eRs8Ov6GcsxWGwCff7II
FDsL5eE2QAl1CAdI3gzO0bI=
=3wSu
-----END PGP SIGNATURE-----

--=-GOzmSWvIyz63LJOMrHkx--