pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhere is the msi-setup described ?
7+ messages / 4 participants
[nested] [flat]
* Where is the msi-setup described ?
@ 2006-09-19 08:46 Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 7+ messages in thread
From: Josef Springer @ 2006-09-19 08:46 UTC (permalink / raw)
To: pgsql-admin
Hi folks,
where do i get documentation about the msi-setupdialogs for Windows
plaforms ?
mit freundlichen Gru"?en / best regards,
Josef Springer
(Gescha"ftsleitung/Management)
[Postal]
Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]
Office
+49 (0)89 600 6920
[Phone]
Fax
+49 (0)89 600 69220
[Web]
Web
http://www.joops.com
[JOOPS]
-- the software company --
Attachments:
Sent (image/jpeg, 770B) download
view image
Sent (image/jpeg, 802B) download
view image
Sent (image/jpeg, 802B) download
view image
Sent (image/jpeg, 807B) download
view image
Sent (image/jpeg, 7.6K) download
view image
* Re: Where is the msi-setup described ?
@ 2006-09-19 09:12 Magnus Hagander <mha@sollentuna.net>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 7+ messages in thread
From: Magnus Hagander @ 2006-09-19 09:12 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; pgsql-admin
> Hi folks,
>
>
> where do i get documentation about the msi-setup dialogs for
> Windows plaforms ?
http://pginstaller.projects.postgresql.org
//Magnus
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where is the msi-setup described ?
@ 2006-09-19 10:18 Josef Springer <Josef.Springer@joops.com>
parent: Magnus Hagander <mha@sollentuna.net>
0 siblings, 1 reply; 7+ messages in thread
From: Josef Springer @ 2006-09-19 10:18 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; +Cc: pgsql-admin
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://pginstaller.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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where is the msi-setup described ?
@ 2006-09-19 10:28 Magnus Hagander <mha@sollentuna.net>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 7+ messages in thread
From: Magnus Hagander @ 2006-09-19 10:28 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: pgsql-admin
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: pgsql-admin@postgresql.org
> 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://pginstaller.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
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where is the msi-setup described ?
@ 2006-09-19 11:00 Josef Springer <Josef.Springer@joops.com>
parent: Magnus Hagander <mha@sollentuna.net>
0 siblings, 1 reply; 7+ messages in thread
From: Josef Springer @ 2006-09-19 11:00 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; +Cc: pgsql-admin
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: pgsql-admin@postgresql.org
>>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://pginstaller.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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where is the msi-setup described ?
@ 2006-09-19 11:09 Matthias.Pitzl@izb.de
0 siblings, 0 replies; 7+ messages in thread
From: Matthias.Pitzl@izb.de @ 2006-09-19 11:09 UTC (permalink / raw)
To: Josef.Springer@joops.com; +Cc: pgsql-admin
Hi Josef!
You need a line looking like this one:
host all all 0.0.0.0 0.0.0.0 md5
This would enable every client to connect to all databases on the server
with using MD5 hashed passwords.
The two lines posted by you are just rules for localhost. One is for IPv4,
the other for IPv6.
Further explanations can be found at
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
<http://www.postgresql.org/docs/8.1/interactive/client-authentication.html;
Greetings,
Matthias
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Josef Springer
Sent: Tuesday, September 19, 2006 1:00 PM
To: Magnus Hagander
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Where is the msi-setup described ?
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where is the msi-setup described ?
@ 2006-09-19 11:19 Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 0 replies; 7+ messages in thread
From: Andrea Gozzi @ 2006-09-19 11:19 UTC (permalink / raw)
To: Josef.Springer@joops.com; +Cc: pgsql-admin
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>
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2006-09-19 11:19 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-19 08:46 Where is the msi-setup described ? Josef Springer <Josef.Springer@joops.com>
2006-09-19 09:12 ` Magnus Hagander <mha@sollentuna.net>
2006-09-19 10:18 ` Josef Springer <Josef.Springer@joops.com>
2006-09-19 10:28 ` Magnus Hagander <mha@sollentuna.net>
2006-09-19 11:00 ` Josef Springer <Josef.Springer@joops.com>
2006-09-19 11:19 ` Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
2006-09-19 11:09 Re: Where is the msi-setup described ? Matthias.Pitzl@izb.de
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox