pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan'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>
2004-07-25 22:44 ` Re: Can't increase max connections Peter Eisentraut <peter_e@gmx.net>
2004-07-25 23:03 ` Re: Can't increase max connections Gaetano Mendola <mendola@bigfoot.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-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>
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-19 16:38 Can't increase max connections Roberto De Shong <shong_1@yahoo.com>
@ 2004-07-25 23:03 ` Gaetano Mendola <mendola@bigfoot.com>
2004-07-25 23:15 ` Re: Can't increase max connections 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-19 16:38 Can't increase max connections Roberto De Shong <shong_1@yahoo.com>
2004-07-25 23:03 ` Re: Can't increase max connections Gaetano Mendola <mendola@bigfoot.com>
@ 2004-07-25 23:15 ` Roberto De Shong <shong_1@yahoo.com>
2004-07-25 23:47 ` Re: Can't increase max connections 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-19 16:38 Can't increase max connections Roberto De Shong <shong_1@yahoo.com>
2004-07-25 23:03 ` Re: Can't increase max connections Gaetano Mendola <mendola@bigfoot.com>
2004-07-25 23:15 ` Re: Can't increase max connections Roberto De Shong <shong_1@yahoo.com>
@ 2004-07-25 23:47 ` Gaetano Mendola <mendola@bigfoot.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