> 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

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
>
>

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

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
>
>

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>

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

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

Firstly it would be helpful to say what error you're getting on the
client side.
At a quick guess, I would say it's because you've got 2 "0.0.0.0"
declarations in your pg_hba.conf - you only need the one - like this:

host all all 0.0.0.0/0 md5

Regards,

Andy.

Josef Springer wrote:
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> host all all 0.0.0.0
> 0.0.0.0 md5
> in the file pg_hba.conf
> and
> listen_addresses = '*'
> in the file postgresql.conf.
>
> the 'client's host file contain the line
> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the /Labor/ no matter wether i use the machine's name
> or the IP-adress.
>
> What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschä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 --*
>
>
>
>
>
> !DSPAM:37,45a60e36137102078430163!


--
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834


---------------------------(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

Hi Andi,

i get an error message "Can not connect to database..." or similar. I
will ask the customer.
The system at another customer runs with host all all
0.0.0.0/0 md5

Josef

Andy Shellam (Mailing Lists) wrote:

> Firstly it would be helpful to say what error you're getting on the
> client side.
> At a quick guess, I would say it's because you've got 2 "0.0.0.0"
> declarations in your pg_hba.conf - you only need the one - like this:
>
> host all all 0.0.0.0/0 md5
>
> Regards,
>
> Andy.
>
> Josef Springer wrote:
>
>> Hi folks,
>>
>> i have a workgroup (not a classic server) with Windows-XP-machines:
>>
>> the database server machine contains the line
>> host all all 0.0.0.0
>> 0.0.0.0 md5
>> in the file pg_hba.conf
>> and
>> listen_addresses = '*' in the file postgresql.conf.
>>
>> the 'client's host file contain the line
>> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress
>> of the database server machine and /Labor /is the machine's name.
>>
>> If i start PGAdmin III on the 'client' machine i can not connect to
>> the database on the /Labor/ no matter wether i use the machine's name
>> or the IP-adress.
>>
>> What to do ?
>>
>> mit freundlichen Grüßen / best regards,
>> Josef Springer
>> (Geschä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 --*
>>
>>
>>
>>
>>
>> !DSPAM:37,45a60e36137102078430163!
>
>
>

Hi Andy,

here ist the error mesage trying to connect:

"Zum Server ist keine Verbindung möglich,

oder Login/Passwort sind falsch.

Die Anmeldung wurde abgelehnt."


Josef

Andy Shellam (Mailing Lists) wrote:

> Firstly it would be helpful to say what error you're getting on the
> client side.
> At a quick guess, I would say it's because you've got 2 "0.0.0.0"
> declarations in your pg_hba.conf - you only need the one - like this:
>
> host all all 0.0.0.0/0 md5
>
> Regards,
>
> Andy.
>
> Josef Springer wrote:
>
>> Hi folks,
>>
>> i have a workgroup (not a classic server) with Windows-XP-machines:
>>
>> the database server machine contains the line
>> host all all 0.0.0.0
>> 0.0.0.0 md5
>> in the file pg_hba.conf
>> and
>> listen_addresses = '*' in the file postgresql.conf.
>>
>> the 'client's host file contain the line
>> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress
>> of the database server machine and /Labor /is the machine's name.
>>
>> If i start PGAdmin III on the 'client' machine i can not connect to
>> the database on the /Labor/ no matter wether i use the machine's name
>> or the IP-adress.
>>
>> What to do ?
>>
>> mit freundlichen Grüßen / best regards,
>> Josef Springer
>> (Geschä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 --*
>>
>>
>>
>>
>>
>> !DSPAM:37,45a60e36137102078430163!
>
>
>

I can understand the exact error as its not in english but it seems like
an authentication problem. Please change 'md5' to 'trust' in pg_hba.conf
file and then use:

pg_ctl -D <path to data folder> reload

That will reload the settings for authentication.

Now once the settings are reloaded try reconnecting to the database and it
should go fine this time....

----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/15/07, Josef Springer <Josef.Springer@joops.com> wrote:
>
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> *host all all 0.0.0.0 0.0.0.0 md5*
> in the file pg_hba.conf
> and
> *listen_addresses = '*' *
> in the file postgresql.conf.
>
> The clients' host file contain the line
> *nnn.nnn.nnn.nnn Labor* where nnn.nnn.nnn.nnnn is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the machine Labor no matter wether i use the machine's
> name
> or the IP-adress. Instead i get the message
>
> * "Zum Server ist keine Verbindung möglich, *
>
> * oder Login/Passwort sind falsch.*
>
> * Die Anmeldung wurde abgelehnt."*
>
>
> Please help me. What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [image: Postal]
> Address
> *Josef.Springer@joops.com*
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> [image: Phone]
> Office
> +49 (0)89 600 6920
>
>
> [image: Phone]
> Fax
> +49 (0)89 600 69220
>
>
> [image: Web]
> Web
> http://www.joops.com
>
>
>
> [image: JOOPS]
> *-- the software company --*
>
>
>
>
>

Hi Mir,

thanks for your quick answer. We will try this.
For my unterstanding: Why should i use trust instead of md5 ? A
configuration at another customer (with a domain setting) using md5
works fine ?

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschä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 --






Shoaib Mir wrote:

> I can understand the exact error as its not in english but it seems
> like an authentication problem. Please change 'md5' to 'trust' in
> pg_hba.conf file and then use:
>
> pg_ctl -D <path to data folder> reload
>
> That will reload the settings for authentication.
>
> Now once the settings are reloaded try reconnecting to the database
> and it should go fine this time....
>
> ----------------
> Shoaib Mir
> EnterpriseDB ( www.enterprisedb.com <http://www.enterprisedb.com> )
>
> On 1/15/07, Josef Springer <Josef.Springer@joops.com
> <mailto:Josef.Springer@joops.com> > wrote:
>
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> host all all 0.0.0.0 <http://0.0.0.0> 0.0.0.0
> <http://0.0.0.0> md5
> in the file pg_hba.conf
> and
> listen_addresses = '*'
> in the file postgresql.conf.
>
> The clients' host file contain the line
> nnn.nnn.nnn.nnn Labor where nnn.nnn.nnn.nnnn is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the machine Labor no matter wether i use the
> machine's name
> or the IP-adress. Instead i get the message
>
> "Zum Server ist keine Verbindung möglich,
>
> oder Login/Passwort sind falsch.
>
> Die Anmeldung wurde abgelehnt."
>
>
>
> Please help me. What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [Postal]
> Address
> Josef.Springer@joops.com <mailto: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 --
>
>
>
>
>
>
>