Re: [ADMIN] could not fork new process for connection: Cannot allocate memory

2004-07-25 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > Pavel Veretennikov wrote: > | What could be a problem? About 3G of shared memory is allocated to PG, > | 85 shared_buffers. > I don't know what you problem can be but are you sure you need that > *very huge* ammount of shared memory ? Conventional

Re: [ADMIN] Can't increase max connections

2004-07-25 Thread Gaetano Mendola
Roberto De Shong wrote: > Actually I got it solved, I recompiled the kernel adding the options below: > optionsSYSVSHM > optionsSYSVSEM > optionsSYSVMSG > optionsSHMMAXPGS=65536 > optionsSEMMNI=40 > optionsSEMMNS=240 > optionsSEMUME=40 > optio

Re: [ADMIN] Can't increase max connections

2004-07-25 Thread Roberto De Shong
Actually I got it solved, I recompiled the kernel adding the options below: options    SYSVSHM options    SYSVSEM options    SYSVMSG options    SHMMAXPGS=65536 optionsSEMMNI=40 options    SEMMNS=240 options    SEMUME=40 options    SEMMNU=120   And I made the fol

Re: [ADMIN] could not fork new process for connection: Cannot allocate memory

2004-07-25 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pavel Veretennikov wrote: | What could be a problem? About 3G of shared memory is allocated to PG, | 85 shared_buffers. I don't know what you problem can be but are you sure you need that *very huge* ammount of shared memory ? Let us know your tipic

Re: [ADMIN] Can't increase max connections

2004-07-25 Thread Gaetano Mendola
-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 h

Re: [ADMIN] Can't increase max connections

2004-07-25 Thread Peter Eisentraut
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. -- P

[ADMIN] Help!

2004-07-25 Thread Radha Krishnan
Hi How import an oracle (Win) table data to postgres (linux)   Radhakrishnan     Reply to [EMAIL PROTECTED]

[ADMIN] Can't increase max connections

2004-07-25 Thread Roberto De Shong
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.

[ADMIN] could not fork new process for connection: Cannot allocate memory

2004-07-25 Thread Pavel Veretennikov
I ran into this error running 2 user connection executing consecutive selects in a loop. What could be a problem? About 3G of shared memory is allocated to PG, 85 shared_buffers. TopMemoryContext: 32768 total in 3 blocks; 20024 free (22 chunks); 12744 used TopTransactionContext: 8192 tot

Re: [ADMIN] Profiling

2004-07-25 Thread Simon Riggs
On Fri, 2004-07-23 at 12:23, Werner vd Merwe wrote: > We are running a PG7.4 database, being accessed through jspâs called > through Tomcat. The problem is, that sometimes the database comes to a > complete standstill, sometimes because of deadlocks, but I would > venture to say that most times it