pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can't increase max connections
5+ messages / 3 participants
[nested] [flat]

* Can't increase max connections
@ 2004-07-19 16:38  Roberto De Shong <shong_1@yahoo.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Roberto De Shong @ 2004-07-19 16:38 UTC (permalink / raw)
  To: pgsql-admin

I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been trying to increase the max connections. the most I'm able to is 40, if I increase it any higher I'm unable to start the database. Is there any tip, s hte any guide where I can get an idea of the other values to set in postgresql.conf for increasing max connections? I had also recompile the kernel and changed maxusers from 0 to 64. I'm not sure if increasing it even more would allow me increase connections. Would appreciate some help, thanks.



---------------------------------
Post your free ad now! Yahoo! Canada Personals

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Can't increase max connections
@ 2004-07-25 22:44  Peter Eisentraut <peter_e@gmx.net>
  parent: Roberto De Shong <shong_1@yahoo.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Peter Eisentraut @ 2004-07-25 22:44 UTC (permalink / raw)
  To: Roberto De Shong <shong_1@yahoo.com>; pgsql-admin

Roberto De Shong wrote:
> I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been
> trying to increase the max connections. the most I'm able to is 40,
> if I increase it any higher I'm unable to start the database.

You need to show the error message if you want relevant help.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Can't increase max connections
@ 2004-07-25 23:03  Gaetano Mendola <mendola@bigfoot.com>
  parent: Roberto De Shong <shong_1@yahoo.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Gaetano Mendola @ 2004-07-25 23:03 UTC (permalink / raw)
  To: Roberto De Shong <shong_1@yahoo.com>; pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Roberto De Shong wrote:

| I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been
| trying to increase the max connections. the most I'm able to is 40, if I
| increase it any higher I'm unable to start the database. Is there any
| tip, s hte any guide where I can get an idea of the other values to set
| in postgresql.conf for increasing max connections? I had also recompile
| the kernel and changed maxusers from 0 to 64. I'm not sure if increasing
| it even more would allow me increase connections. Would appreciate some
| help, thanks.

Most likely you are out of shared memory segments that you OS allow.
If you are on Linux try to pump-up  shmmax and shmall

Regards
Gaetano Mendola



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBBDwz7UpzwH2SGd4RAmO7AJ4jqXpBjglSZuwn7e92wRS23sJR+QCgkpLE
vK2twgkJ8Wi80vM+5KzWymg=
=C9sb
-----END PGP SIGNATURE-----




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Can't increase max connections
@ 2004-07-25 23:15  Roberto De Shong <shong_1@yahoo.com>
  parent: Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Roberto De Shong @ 2004-07-25 23:15 UTC (permalink / raw)
  To: Gaetano Mendola <mendola@bigfoot.com>; pgsql-admin

Actually I got it solved, I recompiled the kernel adding the options below:
options        SYSVSHM
options        SYSVSEM
options        SYSVMSG
options        SHMMAXPGS=65536
options        SEMMNI=40
options        SEMMNS=240
options        SEMUME=40
options        SEMMNU=120
 
And I made the following modifications to postgresql.conf:
 
shared_buffers = 4096  
max_fsm_relations = 1024         
max_fsm_pages = 16384 
sort_mem = 4096
 
I was tthen able to increase it, I only set maxconnections to 200, because I'm using database pooling to manage connections which I'm only using 80 connections max.
 
Thanks.



Gaetano Mendola <mendola@bigfoot.com> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Roberto De Shong wrote:

| I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been
| trying to increase the max connections. the most I'm able to is 40, if I
| increase it any higher I'm unable to start the database. Is there any
| tip, s hte any guide where I can get an idea of the other values to set
| in postgresql.conf for increasing max connections? I had also recompile
| the kernel and changed maxusers from 0 to 64. I'm not sure if increasing
| it even more would allow me increase connections. Would appreciate some
| help, thanks.

Most likely you are out of shared memory segments that you OS allow.
If you are on Linux try to pump-up shmmax and shmall

Regards
Gaetano Mendola



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBBDwz7UpzwH2SGd4RAmO7AJ4jqXpBjglSZuwn7e92wRS23sJR+QCgkpLE
vK2twgkJ8Wi80vM+5KzWymg=
=C9sb
-----END PGP SIGNATURE-----




Roberto De Shong


---------------------------------
Post your free ad now! Yahoo! Canada Personals

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Can't increase max connections
@ 2004-07-25 23:47  Gaetano Mendola <mendola@bigfoot.com>
  parent: Roberto De Shong <shong_1@yahoo.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Gaetano Mendola @ 2004-07-25 23:47 UTC (permalink / raw)
  To: Roberto De Shong <shong_1@yahoo.com>

Roberto De Shong wrote:

 > Actually I got it solved, I recompiled the kernel adding the options below:
 > options        SYSVSHM
 > options        SYSVSEM
 > options        SYSVMSG
 > options        SHMMAXPGS=65536
 > options        SEMMNI=40
 > options        SEMMNS=240
 > options        SEMUME=40
 > options        SEMMNU=120
 >
 > And I made the following modifications to postgresql.conf:
 >
 > shared_buffers = 4096
 > max_fsm_relations = 1024
 > max_fsm_pages = 16384
 > sort_mem = 4096
 >
 > I was tthen able to increase it, I only set maxconnections to 200,
 > because I'm using database pooling to manage connections which I'm only
 > using 80 connections max.
 >
 > Thanks.

So if you need 80 connections why did you use 200 on the postgres side ?
You waste shared memory if you have 120 connections more then necessary.

Are you using pgpoll ?


Regards
Gaetano Mendola






^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-07-25 23:47 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-19 16:38 Can't increase max connections Roberto De Shong <shong_1@yahoo.com>
2004-07-25 22:44 ` Peter Eisentraut <peter_e@gmx.net>
2004-07-25 23:03 ` Gaetano Mendola <mendola@bigfoot.com>
2004-07-25 23:15   ` Roberto De Shong <shong_1@yahoo.com>
2004-07-25 23:47     ` Gaetano Mendola <mendola@bigfoot.com>

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