How to open more than 300 connections to postgres database.

Hello,
=20
I set max_connecion =3D300, but it only allows upto 130 connections.
=20
I tried to change some para in postgresql.conf file (shared_buffer...), but=
it was not efficient.
=20
I read some document in postgres site said that i should change some para o=
f System V IPC, but how do i change them ?
=20
I am using WinXP, SP2, 4GB of GAM
=20
=20
Thanks for your help.
Lam
=20

This email may contain material that is confidential, privileged, and/or at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: How to open more than 300 connections to postgres database.

Hello Lam,

Tuesday, February 5, 2008, 10:49:46 PM, you wrote:

NLT> RB> These changes require a reboot of windows to become effective. Did you
NLT> RB> do that?

NLT> yes, of course.

NLT> I tried many times, could you please help me.

What we have to find out is whether it's the desktop heap's fault or a
bug in the driver.

There are two things you can do:

1) Download and install the "Desktop Heap Monitor" and watch the
desktop heap usage when your 128th connection has been established:

2) Enable debugging output in the ODBC driver and post the mylog
output here.

Rainer

NLT> ________________________________

NLT> From: Rainer Bauer [mailto:usenet@munnin.com]
NLT> Sent: Tue 2/5/2008 4:49 PM
NLT> To: Nguyen, Lam Thuy
NLT> Subject: Re[2]: [ODBC] How to open more than 300 connections to postgres database.



NLT> Hello Lam,

NLT>> I did but it i is still not efficient.
NLT>> I try to increate or decrease the third SharedSection value, the second ShareSection value ,

NLT> You only have to increase the third value.

NLT>> but the size of each connection is still no change with 6200kb.

NLT> These changes require a reboot of windows to become effective. Did you
NLT> do that?

NLT> Rainer




NLT> This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient. Any review, reliance, or distribution by others or
NLT> forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.



--
Best regards,
Rainer mailto:usenet@munnin.com


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: How to open more than 300 connections to postgres database.

Hi Rainer,

There are 3 folders when extracting the download file : ia64,x64,x68.

then i run dheapinst.exe file in x68, i got error : Win32k .sys symbol load=
eror, correct symbol required.

How i correct it ?

=20

Thanks

=20



________________________________

From: Rainer Bauer [mailto:usenet@munnin.com]
Sent: Tue 2/5/2008 5:05 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc@postgresql.org
Subject: Re[4]: [ODBC] How to open more than 300 connections to postgres da=
tabase.



Hello Lam,

Tuesday, February 5, 2008, 10:49:46 PM, you wrote:

NLT> RB> These changes require a reboot of windows to become effective. Did=
you
NLT> RB> do that?

NLT> yes, of course.

NLT> I tried many times, could you please help me.

What we have to find out is whether it's the desktop heap's fault or a
bug in the driver.

There are two things you can do:

1) Download and install the "Desktop Heap Monitor" and watch the
desktop heap usage when your 128th connection has been established:
a-4510-b4b9-b2dc98c8ed8b&displaylang=3Den>
2) Enable debugging output in the ODBC driver and post the mylog
output here.

Rainer

NLT> ________________________________

NLT> From: Rainer Bauer [mailto:usenet@munnin.com]
NLT> Sent: Tue 2/5/2008 4:49 PM
NLT> To: Nguyen, Lam Thuy
NLT> Subject: Re[2]: [ODBC] How to open more than 300 connections to postgr=
es database.



NLT> Hello Lam,

NLT>> I did but it i is still not efficient.
NLT>> I try to increate or decrease the third SharedSection value, the seco=
nd ShareSection value ,

NLT> You only have to increase the third value.

NLT>> but the size of each connection is still no change with 6200kb.

NLT> These changes require a reboot of windows to become effective. Did you
NLT> do that?

NLT> Rainer




NLT> This email may contain material that is confidential, privileged, and/=
or attorney work product for the sole use of the intended recipient. Any r=
eview, reliance, or distribution by others or
NLT> forwarding without express permission is strictly prohibited. If you =
are not the intended recipient, please contact the sender and delete all co=
pies.



--
Best regards,
Rainer mailto:usenet@munnin.com




This email may contain material that is confidential, privileged, and/or at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: How to open more than 300 connections to postgres database.

Hello Lam,

Tuesday, February 5, 2008, 11:54:36 PM, you wrote:

NLT> There are 3 folders when extracting the download file : ia64,x64,x68.
NLT> then i run dheapinst.exe file in x68, i got error : Win32k .sys symbol load eror, correct symbol required.
NLT> How i correct it ?

You need the correct version of the Win32k.sys symbol file.
See section "Additional Information"


Rainer


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: How to open more than 300 connections to postgres database.

Hi Rainer,

I installed postgres 8.3.0, it allows over 300 connections.

Does postgres 8.2.not support more than 128 connections ?

Could you please confirm me ?

Tha nks

Lam

=20

=20


=20
=20

________________________________

From: Rainer Bauer [mailto:usenet@munnin.com]
Sent: Tue 2/5/2008 6:30 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc@postgresql.org
Subject: Re[6]: [ODBC] How to open more than 300 connections to postgres da=
tabase.



Hello Lam,

Tuesday, February 5, 2008, 11:54:36 PM, you wrote:

NLT> There are 3 folders when extracting the download file : ia64,x64,x68.
NLT> then i run dheapinst.exe file in x68, i got error : Win32k .sys symbol=
load eror, correct symbol required.
NLT> How i correct it ?

You need the correct version of the Win32k.sys symbol file.
See section "Additional Information"
510-b4b9-b2dc98c8ed8b&displaylang=3Den#AdditionalInfo>

Rainer




This email may contain material that is confidential, privileged, and/or at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(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: How to open more than 300 connections to postgres database.

Hello Lam,

Wednesday, February 6, 2008, 5:29:55 AM, you wrote:

NLT> The attachment includes :
NLT> - psqlodbc log
NLT> - Desktop heap info when i got error.
NLT> - postgressql.conf

Could you attach the files directly. I only see one file called
Winmail.dat [20kb] and cannot open it.

NLT> I installed postgres 8.3.0, it allows over 300 connections.
NLT> Does postgres 8.2.not support more than 128 connections ?
NLT> Could you please confirm me ?

Yes, the "Desktop Heap Problem" was solved in Postgres 8.3.

Rainer


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

http://archives.postgresql.org

Re: How to open more than 300 connections to postgres database.

Hi Rainer

But Postgres 8.3 has just been release few days, is it stable for using ?
=20
Do you have any solutions for 8.2 ? because i am using 8.2, it will be hard=
for me if i change to 8.3.
=20
Could you review these files i sent to you in the previous mail, and give m=
e some adives.
=20
=20
Thanks
Lamsta

________________________________

From: Rainer Bauer [mailto:usenet@munnin.com]
Sent: Wed 2/6/2008 5:03 AM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc@postgresql.org
Subject: Re[6]: [ODBC] How to open more than 300 connections to postgres da=
tabase.



Hello Lam,

Wednesday, February 6, 2008, 5:29:55 AM, you wrote:

NLT> The attachment includes :
NLT> - psqlodbc log
NLT> - Desktop heap info when i got error.
NLT> - postgressql.conf

Could you attach the files directly. I only see one file called
Winmail.dat [20kb] and cannot open it.

NLT> I installed postgres 8.3.0, it allows over 300 connections.
NLT> Does postgres 8.2.not support more than 128 connections ?
NLT> Could you please confirm me ?

Yes, the "Desktop Heap Problem" was solved in Postgres 8.3.

Rainer




This email may contain material that is confidential, privileged, and/or at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: How to open more than 300 connections to postgres database.

Hello Lam,

Wednesday, February 6, 2008, 3:07:04 PM, you wrote:

NLT> Here is the attatchment

Sorry, same as last time: only a winmail.dat file.
Maybe you could upload the files to a public server?

Rainer


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

Re: How to open more than 300 connections to postgres database.

Nguyen, Lam Thuy wrote:
> Hi Rainer
>
> But Postgres 8.3 has just been release few days, is it stable for using ?
>
> Do you have any solutions for 8.2 ? because i am using 8.2, it will be hard for me if i change to 8.3.

The driver's version isn't so tightly related to the server's version
and you can live with the 8.3.xxxx driver and the 8.2 server without
any problem. The driver's own limitation about max connections (128)
was removed at 8.2.0402 version though I'm not sure if the change
guarantees >= 300 connections.

You can download various version of psqlODBC drivers from
http://www.postgresql.org/ftp/odbc/versions/ in Windows
Installer, merge module, source and basic zip file formats.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: How to open more than 300 connections to postgres database.

Hello Hiroshi,

Wednesday, February 6, 2008, 6:46:39 PM, you wrote:

HI> The driver's own limitation about max connections (128)
HI> was removed at 8.2.0402 version though I'm not sure if the change
guarantees >>= 300 connections.

Ah, that explains why I couldn't see any error here. I was looking at
the source code of 8.2.0402.

Rainer


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: How to open more than 300 connections to postgres database.

You mean postgres 8.2.0402 does not support more than 128 connection ?
=20
Could you please confirm me clearly so that i can find the best solution i =
should change or not.
=20
Thanks
=20

________________________________

From: pgsql-odbc-owner@postgresql.org on behalf of Rainer Bauer
Sent: Wed 2/6/2008 2:10 PM
To: Hiroshi Inoue
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] How to open more than 300 connections to postgres datab=
ase.



Hello Hiroshi,

Wednesday, February 6, 2008, 6:46:39 PM, you wrote:

HI> The driver's own limitation about max connections (128)
HI> was removed at 8.2.0402 version though I'm not sure if the change
guarantees >>=3D 300 connections.

Ah, that explains why I couldn't see any error here. I was looking at
the source code of 8.2.0402.

Rainer


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



This email may contain material that is confidential, privileged, and/or at=
torney work product for the sole use of the intended recipient. Any review=
, reliance, or distribution by others or forwarding without express permiss=
ion is strictly prohibited. If you are not the intended recipient, please =
contact the sender and delete all copies.

---------------------------(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: How to open more than 300 connections to postgres database.

Hello Lam,

Wednesday, February 6, 2008, 8:14:01 PM, you wrote:

NLT> You mean postgres 8.2.0402 does not support more than 128 connection ?
NLT> Could you please confirm me clearly so that i can find the best solution i should change or not.

No, Postgres 8.2 does support more than 128 connections (provided that
you have increased the desktop heap accordingly).

However, you will need at least psqlODBC 8.2.0402. Since the driver is
backward compatible, you should use the latest driver available (i.e.
psqlODBC 8.3.0100). You can find all driver versions here:


Rainer


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

http://archives.postgresql.org

Re: How to open more than 300 connections to postgres database.

Nguyen, Lam Thuy wrote:
> You mean postgres 8.2.0402 does not support more than 128 connection ?

8.2.0402 is OK though 8.2.0401 isn't good.
Please note the version is the driver's one and isn't related to the
server's version. Most client packages have their own development cycle
and you can install the packages (psqlodbc driver of course) separately.
Probably you can find neither 8.2.0402 nor 8.2.0401 version of the
psqlodbc driver and so plaese use the 8.3.0100 or 8.2.0500 version.

regards,
Hiroshi Inoue


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

http://archives.postgresql.org