Where is the msi-setup described ?

--------------070201010703030601060909
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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



--------------070201010703030601060909
Content-Type: multipart/related;
boundary="------------020303020101080102070902"


--------------020303020101080102070902
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





Hi folks,

where do i get documentation about the msi-setup dialogs
for Windows plaforms  ?






mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

	Address	Josef.Springer@joops.com	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web	http://www.joops.com

-- the software company --

 

Re: Where is the msi-setup described ?

> Hi folks,
>=20
>=20
> 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

Re: Where is the msi-setup described ?

--------------060706020209070703070403
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------060706020209070703070403
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





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  ?

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

Re: Where is the msi-setup described ?

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 ?
>=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://pginstaller.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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Where is the msi-setup described ?

--------------060900020108020105050405
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------060900020108020105050405
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





Hi Magnus,



i must explain my users how to maintain.

The menu opens the dialog pgAdminIII - Backend Access Configuration Editor
with 6 colomns:

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


	
 s="moz-txt-link-freetext"  href="http://pginstaller.projects.postgresql.org">http://pgi nst

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?

               

Re: Where is the msi-setup described ?

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C6DBDC.1A99696C
Content-Type: text/plain

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-authen tication.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




------_=_NextPart_001_01C6DBDC.1A99696C
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">

style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">

align=3Dleft> size=3D2>-----Original Message-----
From:=20
pgsql-admin-owner@postgresql.org =
[mailto:pgsql-admin-owner@postgresql.org]=20
On Behalf Of Josef Springer
Sent: Tuesday, September =
19, 2006=20
1:00 PM
To: Magnus Hagander
Cc:=20
pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Where is =
the=20
msi-setup described ?

Hi Magnus,

i must =
explain my=20
users how to maintain.
The menu opens the dialog pgAdminIII - =
Backend=20
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 ?=20
If no, what is required to access from any client ?
  =20
          =20

Josef      =20

Re: Where is the msi-setup described ?

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

--=-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/m5eRs8Ov6GcsxWGwCf f7II
FDsL5eE2QAl1CAdI3gzO0bI=
=3wSu
-----END PGP SIGNATURE-----

--=-GOzmSWvIyz63LJOMrHkx--

I want to import a database from a customer

Hi folks,

i must analyze a customer's database offline. Can i import the databse
of the customer into our PostgreSQL environment ?
What must the customer send us ?
Whats the doings for us to open it in our envioronment ?

Josef




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: I want to import a database from a customer

------=_Part_4555_8744477.1167915169402
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Use pg_dump/pg_dump utility to take the db dump and then you can restore it
using psql or pg_restore at your end.

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

On 1/4/07, Josef Springer wrote:
>
> Hi folks,
>
> i must analyze a customer's database offline. Can i import the databse
> of the customer into our PostgreSQL environment ?
> What must the customer send us ?
> Whats the doings for us to open it in our envioronment ?
>
> Josef
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

------=_Part_4555_8744477.1167915169402
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Use pg_dump/pg_dump utility to take the db dump and then you can restore it using psql or pg_restore at your end.

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

Re: I want to import a database from a customer

Hi Josef,


> i must analyze a customer's database offline. Can i import the databse
> of the customer into our PostgreSQL environment ?
> What must the customer send us ?
> Whats the doings for us to open it in our envioronment ?

use pg_dump -o -b -Fc [database to export] > [backup file] in your
customer's side (man pg_dump for details)

create the database where you'll import the backup and use pg_restore
-v -O -d [database] [backup file] (man pg_restore for details)


--
Arnau

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

Can not connect to database in Workgroup-Net on Windows-XP

--------------070305060804020906010407
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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





--------------070305060804020906010407
Content-Type: multipart/related;
boundary="------------020507080206010803080408"


--------------020507080206010803080408
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





Hi folks,



i have a workgroup (not a classic server)  with Windows-XP-machines:



the database server machine contains the line

mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

	Address	Josef.Springer@joops.com	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web	http://www.joops.com

-- the software company --

 

Re: Can not connect to database in Workgroup-Net on Windows-XP

Firstly it would be helpful to say what error you're getting on the=20
client side.
At a quick guess, I would say it's because you've got 2 "0.0.0.0"=20
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 =20
> 0.0.0.0 md5
> in the file pg_hba.conf
> and
> listen_addresses =3D '*'=20
> 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=20
> 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=20
> the database on the /Labor/ no matter wether i use the machine's name=20
> 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
> =09
> =09
> Phone
> Fax
> +49 (0)89 600 69220
> =09
> =09
> Web
> Web
> http://www.joops.com
> =09
> =09
>
>
> JOOPS
> *-- the software company --*
>
>
> =20
>
>
> !DSPAM:37,45a60e36137102078430163!=20


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

Re: Can not connect to database in Workgroup-Net on Windows-XP

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

Hi Andi,

i get an error message "Can not connect to database..." or similar. I=20
will ask the customer.
The system at another customer runs with host all all =20
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=20
> client side.
> At a quick guess, I would say it's because you've got 2 "0.0.0.0"=20
> 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 =20
>> 0.0.0.0 md5
>> in the file pg_hba.conf
>> and
>> listen_addresses =3D '*' 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=20
>> 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=20
>> 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
>> =20
>> =20
>> Phone
>> Fax
>> +49 (0)89 600 69220
>> =20
>> =20
>> Web
>> Web
>> http://www.joops.com
>> =20
>> =20
>>
>>
>> JOOPS
>> *-- the software company --*
>>
>>
>> =20
>>
>>
>> !DSPAM:37,45a60e36137102078430163!=20
>
>
>

--------------040208030202030905070709
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





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

    

    

    





JOOPS

    *-- the software company --*





 





!DSPAM:37,45a60e36137102078430163!

Re: Can not connect to database in Workgroup-Net on Windows-XP

--------------040306000703040202030805
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: quoted-printable

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=20
> client side.
> At a quick guess, I would say it's because you've got 2 "0.0.0.0"=20
> 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 =20
>> 0.0.0.0 md5
>> in the file pg_hba.conf
>> and
>> listen_addresses =3D '*' 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=20
>> 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=20
>> 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
>> =20
>> =20
>> Phone
>> Fax
>> +49 (0)89 600 69220
>> =20
>> =20
>> Web
>> Web
>> http://www.joops.com
>> =20
>> =20
>>
>>
>> JOOPS
>> *-- the software company --*
>>
>>
>> =20
>>
>>
>> !DSPAM:37,45a60e36137102078430163!=20
>
>
>


--------------040306000703040202030805
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable





Hi Andy,



here ist the error mesage trying to connect:

n-left: 0px; ">
"Zum Server ist keine Verbindung möglich,

n-left: 0px; ">
oder Login/Passwort sind falsch.

n-left: 0px; ">
Die Anmeldung wurde abgelehnt."

>Firstly
it would be helpful to say what error you're getting on the client side.=
=20


At a quick guess, I would say it's because you've got 2 "0.0.0.0" declar=
ations
in your pg_hba.conf - you only need the one - like this:



host  =A0 all     all     0.0.0.0/0      =
md5



Regards,



Andy.



Josef Springer wrote:

Hi folks,



i have a workgroup (not a classic server)=A0 with Windows-XP-machines: r>


the database server machine contains the line

host          =A0 all          =A0=
all          =A0 0.0.0.0      =A0 0.0.0=
0  =A0
md5

in the file pg_hba.conf

and

listen_addresses =3D '*' 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 t=
he
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

     om">http://www.joops.com

    

    





JOOPS

    *-- the software company --*





=A0





!DSPAM:37,45a60e36137102078430163!

Can not connect to database in Workgroup-Net on Windows-XP

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

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 =3D '*'
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 na=
me
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
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 --


=20



--------------090104010305070407060907
Content-Type: multipart/related;
boundary="------------090901080908020609030608"


--------------090901080908020609030608
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





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,

mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

	Address		Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web

-- the software company --

 

Re: Can not connect to database in Workgroup-Net on Windows-XP

------=_Part_41319_25230803.1168854403372
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 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 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 =3D '*' *
> 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 --*
>
>
>
>
>

------=_Part_41319_25230803.1168854403372
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 t=
he settings are reloaded try reconnecting to the database and it should go =
fine this time....

----------------
Shoaib Mir
EnterpriseDB (
)

iv>On 1/15/07, Jo=
sef Springer <Josef.Spri=
nger@joops.com
> wrote:

t: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1=
ex;">

Hi folks,



i have a workgroup (not a classic server)  with Windows-XP-machines: r>


the database server machine contains the line

host   all    all   /0.0.0.0" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,eve=
nt,this)">0.0.0.0  click=3D"return top.js.OpenExtLink(window,event,this)">
0.0.0.0    md5

in the file pg_hba.conf

and

listen_addresses =3D '*'

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 al,helvetica,sans-serif;" size=3D"2">

ca,sans-serif" size=3D"3">
"Zum Server ist keine Verbindung möglich,

ca,sans-serif" size=3D"3">
oder Login/Passwort sind falsch.

ca,sans-serif" size=3D"3">
Die Anmeldung wurde abgelehnt."

Please help me. What to do ?

mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

width=3D"17">	Address	..Springer@joops.com" target=3D"_blank" onclick=3D"return top.js.OpenExtLink= (window,event,this)">Josef.Springer@joops.com #cc0000">	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
idth=3D"13">	Office ont>	+49 (0)= 89=20 600 6920
idth=3D"13">	Fax 000099">	+49 (0)89 600 69220=
th=3D"15">	= Web	s.com" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,= this)">http://www.joops.com

dth=3D"220">

-- the software company -- b>

 

Re: Can not connect to database in Workgroup-Net on Windows-XP

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

Hi Mir,

thanks for your quick answer. We will try this.
For my unterstanding: Why should i use trust instead of md5 ? A=20
configuration at another customer (with a domain setting) using md5=20
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 --


=20



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=20
> pg_hba.conf file and then use:
>
> pg_ctl -D reload
>
> That will reload the settings for authentication.
>
> Now once the settings are reloaded try reconnecting to the database=20
> and it should go fine this time....
>
> ----------------
> Shoaib Mir
> EnterpriseDB ( www.enterprisedb.com )
>
> On 1/15/07, 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 =3D '*'
> 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
> 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 --
>
>
> =20
>
>
>
>


--------------090900060200050109030902
Content-Type: multipart/related;
boundary="------------040507040302050207070501"


--------------040507040302050207070501
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





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)

	Address		Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web

-- the software company --

 

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

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)

	Address	Josef.Springer@joops.com	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web	http://www.joops.com

-- the software company --

 

Re: Can not connect to database in Workgroup-Net on Windows-XP

------=_Part_41399_33496163.1168856135646
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

The error you are getting is because of the password not been passed
correctly so 'trust' will let you get in the server without specifying the
correct password, once you are in now you can change the password as you
like using ALTER USER command. Once its done change it back to md5 as it wa=
s
before.

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

On 1/15/07, Josef Springer wrote:
>
> 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 *w=
orks
> fine ?
>
> 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 --*
>
>
>
>
> 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 reload
>
> That will reload the settings for authentication.
>
> Now once the settings are reloaded try reconnecting to the database and i=
t
> should go fine this time....
>
> ----------------
> Shoaib Mir
> EnterpriseDB ( www.enterprisedb.com )
>
> On 1/15/07, 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 =3D '*' *
> > 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 --*
> >
> >
> >
> >
> >
>
>
>

------=_Part_41399_33496163.1168856135646
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

The error you are getting is because of the password not been passed correc=
tly so 'trust' will let you get in the server without specifying th=
e correct password, once you are in now you can change the password as you =
like using ALTER USER command. Once its done change it back to md5 as it wa=
s before.


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

Can not restore a dumped database

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

iI habe dumped a database with
pg_dump --file=3D"" -a --schema=3D"OfficeTalk" -h localhost -U =

OfficeTalk "OfficeTalk"

Restoring it with
pg_restore -d "OfficeTalk" -a -h localhost -U "OfficeTalk" ""

i get the error
pg_restore: [archiver] input file does not appear to be a valid archive

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


=20

--------------030607040200050109050903
Content-Type: multipart/related;
boundary="------------040304040900020704000407"


--------------040304040900020704000407
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





iI habe dumped a database with


pg_dump --file="<filename>" -a --schema="OfficeTalk" -h localhost
-U OfficeTalk "OfficeTalk"



Restoring it with

pg_restore -d "OfficeTalk" -a -h localhost -U "OfficeTalk" "<filename>"



i get the error

pg_restore: [archiver] input file does not appear to be a valid archive



What to do ?



mit freundlichen Grüßen / best regards,

Josef Springer

(Geschäftsleitung/Management)

	Address		Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web

-- the software company --

Re: Can not restore a dumped database

You only need to use pg_restore with archives that are not in the=20
plain-text sql format. You can just do this:

psql -f -U OfficeTalk OfficeTalk

to restore.

On Mon, 5 Mar 2007, Josef Springer wrote:

> iI habe dumped a database with
> pg_dump --file=3D"" -a --schema=3D"OfficeTalk" -h localhost -U=
=20
> OfficeTalk "OfficeTalk"
>
> Restoring it with
> pg_restore -d "OfficeTalk" -a -h localhost -U "OfficeTalk" ""
>
> i get the error
> pg_restore: [archiver] input file does not appear to be a valid archive
>
> 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 --
>
>
>
>

--=20
Jeff Frost, Owner
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Can not access PostgreSQL 8.8 via ADO

This is a multi-part message in MIME format.
--------------000704050100000001080902
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

hello,

we had installed 8.2 and used a database via ADO with the connectstring
*Driver={PostgreSQL
Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Data base=OfficeTalk"
*
Now we have installed 8.8 and try to use the database with the same
connectstring but get the ADO error *80004005.*

We tried different variants but nothing works.

Can anybody help us ?

Thanks for response,
Josef Springer

--------------000704050100000001080902
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







hello,



we had installed 8.2 and used a database via ADO with the connectstring

Driver={PostgreSQL
Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Data base=OfficeTalk"



Now we have installed 8.8 and try to use the database with the same
connectstring but get the ADO error 80004005.



We tried different variants but nothing works.



Can anybody help us ?



Thanks for response,

Josef Springer




--------------000704050100000001080902--

Re: Can not access PostgreSQL 8.8 via ADO

Josef Springer wrote:
> hello,
>
> we had installed 8.2 and used a database via ADO with the connectstring
> *Driver={PostgreSQL
> Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Data base=OfficeTalk"
> *
> Now we have installed 8.8 and try to use the database with the same
> connectstring but get the ADO error *80004005.*
There is no PostgreSQL 8.8 - can you tell us what version you are really
using (or, if you think it is 8.8, where you got it from?)

Can you connect to the database with the regular command line tools over
the network (or a GUI tool such as PgAdmin III), or do you get an error
there as well?

The problem may be that it's unable to connect due to a database
configuration issue, not an ADO issue. If you had a DSN that was
working before, I wouldn't change it until you've verified that you're
actually able to connect to the database properly.

Did you make sure that you made the appropriate changes to
postgresql.conf and pg_hba.conf on the new system to ensure that users
will be able to connect over the network?

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Ask me about out VIRTUAL LIVE training options for PostgreSQL - available globally!


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Can not access PostgreSQL 8.8 via ADO

This is a multi-part message in MIME format.
--------------080009020702040504090109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thanks for quick answer. Sorry, this was a misstype. We are using 8.4
not 8.8.

* We are using the OLEDB-Provider for ADO.
* On 8.2 the connectionstring works, on 8,4 it does not work.
* The database is local and accessed with localhost.
* An application, whitch acceses the database via an ODBC-driver
works. Only ADO does not work. (ADO error *80004005.* )

Joserf Springer


Chander Ganesan wrote:
> Josef Springer wrote:
>> hello,
>>
>> we had installed 8.2 and used a database via ADO with the connectstring
>> *Driver={PostgreSQL
>> Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Data base=OfficeTalk"
>>
>> *
>> Now we have installed 8.8 and try to use the database with the same
>> connectstring but get the ADO error *80004005.*
> There is no PostgreSQL 8.8 - can you tell us what version you are
> really using (or, if you think it is 8.8, where you got it from?)
>
> Can you connect to the database with the regular command line tools
> over the network (or a GUI tool such as PgAdmin III), or do you get an
> error there as well?
>
> The problem may be that it's unable to connect due to a database
> configuration issue, not an ADO issue. If you had a DSN that was
> working before, I wouldn't change it until you've verified that you're
> actually able to connect to the database properly.
>
> Did you make sure that you made the appropriate changes to
> postgresql.conf and pg_hba.conf on the new system to ensure that users
> will be able to connect over the network?
>



--------------080009020702040504090109
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







Thanks for quick answer. Sorry, this was a misstype. We are using 8.4
not 8.8.

• We are using the OLEDB-Provider for ADO.


• On 8.2 the connectionstring works, on 8,4 it does not work.


• The database is local and accessed with localhost.


• An application, whitch acceses the database via an ODBC-driver
  works. Only ADO does not work. (ADO error *80004005.*
  )
  
  

Josef
Springer wrote:

hello,




we had installed 8.2 and used a database via ADO with the connectstring


*Driver={PostgreSQL
Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Data base=OfficeTalk"


*


Now we have installed 8.8 and try to use the database with the same
connectstring but get the ADO error *80004005.*

There is no PostgreSQL 8.8 - can you tell us what version you are
really using (or, if you think it is 8.8, where you got it from?)




Can you connect to the database with the regular command line tools
over the network (or a GUI tool such as PgAdmin III), or do you get an
error there as well?




The problem may be that it's unable to connect due to a database
configuration issue, not an ADO issue.  If you had a DSN that was
working before, I wouldn't change it until you've verified that you're
actually able to connect to the database properly.




Did you make sure that you made the appropriate changes to
postgresql.conf and pg_hba.conf on the new system to ensure that users
will be able to connect over the network?

Re: Can not access PostgreSQL 8.8 via ADO

Hi Joserf,

Does your ADO accept a version 8.4 reply from the database. It
may not be supported. In that case, you will need to update your
ADO software.

Cheers,
Ken

On Thu, Mar 25, 2010 at 03:35:10PM +0100, Josef Springer wrote:
> Thanks for quick answer. Sorry, this was a misstype. We are using 8.4 not
> 8.8.
>
> * We are using the OLEDB-Provider for ADO.
> * On 8.2 the connectionstring works, on 8,4 it does not work.
> * The database is local and accessed with localhost.
> * An application, whitch acceses the database via an ODBC-driver
> works. Only ADO does not work. (ADO error *80004005.* )
>
> Joserf Springer
>
>
> Chander Ganesan wrote:
>> Josef Springer wrote:
>>> hello,
>>>
>>> we had installed 8.2 and used a database via ADO with the connectstring
>>> *Driver={PostgreSQL
>>> Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Data base=OfficeTalk"
>>> *
>>> Now we have installed 8.8 and try to use the database with the same
>>> connectstring but get the ADO error *80004005.*
>> There is no PostgreSQL 8.8 - can you tell us what version you are really
>> using (or, if you think it is 8.8, where you got it from?)
>>
>> Can you connect to the database with the regular command line tools over
>> the network (or a GUI tool such as PgAdmin III), or do you get an error
>> there as well?
>>
>> The problem may be that it's unable to connect due to a database
>> configuration issue, not an ADO issue. If you had a DSN that was working
>> before, I wouldn't change it until you've verified that you're actually
>> able to connect to the database properly.
>>
>> Did you make sure that you made the appropriate changes to postgresql.conf
>> and pg_hba.conf on the new system to ensure that users will be able to
>> connect over the network?
>>
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Can not access PostgreSQL 8.8 via ADO

On Thu, Mar 25, 2010 at 7:35 AM, Josef Springer
wrote:
> Thanks for quick answer. Sorry, this was a misstype. We are using 8.4 not
> 8.8.
>
> We are using the OLEDB-Provider for ADO.
> On 8.2 the connectionstring works, on 8,4 it does not work.
> The database is local and accessed with localhost.
> An application, whitch acceses the database via an ODBC-driver works. Only
> ADO does not work. (ADO error *80004005.* )


If you notice the oledb driver is still marked beta and is not
production ready. It also looks like it was last updated 4 years ago.

http://pgfoundry.org/projects/oledb/

You should probably use the odbc driver since it is production ready
and actively supported.

http://www.postgresql.org/ftp/odbc/versions/msi/

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Can not access PostgreSQL 8.8 via ADO

--- On Thu, 25/3/10, Richard Broersma wrote:
> wrote:
> > Thanks for quick answer. Sorry, this was a misstype.
> We are using 8.4 not
> > 8.8.
> >
> > We are using the OLEDB-Provider for ADO.
> > On 8.2 the connectionstring works, on 8,4 it does not
> work.
> > The database is local and accessed with localhost.
> > An application, whitch acceses the database via an
> ODBC-driver works. Only
> > ADO does not work. (ADO error *80004005.* )
>=20
>=20
> If you notice the oledb driver is still marked beta and is
> not
> production ready.=A0 It also looks like it was last
> updated 4 years ago.
>=20
> http://pgfoundry.org/projects/oledb/
>=20
> You should probably use the odbc driver since it is
> production ready
> and actively supported.
>=20
> http://www.postgresql.org/ftp/odbc/versions/msi/
>=20


Or try PGNP http://www.pgoledb.com/





--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin