Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-18 Thread Tom Lane
Alexandre Barros <[EMAIL PROTECTED]> writes: > [ can't get more than 64 connections ] Have you looked into the postmaster log (stderr or syslog output) to see if any error conditions are being reported? It occurs to me that the postmaster might be running in an account that has a max-number-of-us

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-18 Thread Martijn van Oosterhout
Can't help you with the rest of your problem, but you need to up this by a factor of 10 at least. This is 8MB of shared buffers for 500 connections... On Thu, Aug 18, 2005 at 12:43:49PM -0300, Alexandre Barros wrote: > shared_buffers = 1004 # min 16, at least max_connections*2, 8KB each Hope th

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-18 Thread Alexandre Barros
First of all, thanks in advance for all the replies. Joshua D. Drake wrote: max_connections, shared_buffers, shmmax were tweaked, but the server does not seems to respect the 500 max_connections... i *know* i'm missing something obvious, but, what could be wrong ?... i'm lost..

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-17 Thread Tom Lane
eu <[EMAIL PROTECTED]> writes: > max_connections, shared_buffers, shmmax were tweaked, but the server > does not seems to respect the 500 max_connections... Er ... did you restart the postmaster after increasing those parameters? regards, tom lane ---

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-17 Thread Joshua D. Drake
max_connections, shared_buffers, shmmax were tweaked, but the server does not seems to respect the 500 max_connections... i *know* i'm missing something obvious, but, what could be wrong ?... i'm lost... any help would be most appreciated... please. A completely stupid response but don't take

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-17 Thread Sven Willenberger
On Wed, 2005-08-17 at 13:05 -0300, eu wrote: > Hello, i need help... > > i have a postgresql 8.0.3 database running on the backend of a postfix > setup ( i didn't trust Mysql for the job ) on Linux kernel 2.6.8.1, > serving email to a dozen different virtual domains ( including this one > i'm u

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-17 Thread Sebastian Hennebrueder
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 eu schrieb: > Hello, i need help... > > i have a postgresql 8.0.3 database running on the backend of a postfix > setup ( i didn't trust Mysql for the job ) on Linux kernel 2.6.8.1, > serving email to a dozen different virtual domains ( including this

[GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-17 Thread eu
Hello, i need help... i have a postgresql 8.0.3 database running on the backend of a postfix setup ( i didn't trust Mysql for the job ) on Linux kernel 2.6.8.1, serving email to a dozen different virtual domains ( including this one i'm using right now )... however, this setup takes a whole

Re: [GENERAL] PostgreSQL 8.0.3

2005-07-15 Thread Solange
am able to connect because localhost is mapped by the SO to a IPV4 address - Original Message - From: "Richard Huxton" To: "Solange" <[EMAIL PROTECTED]> Cc: Sent: Thursday, July 14, 2005 11:10 AM Subject: Re: [GENERAL] PostgreSQL 8.0.3 Solange wrote:

Re: [GENERAL] PostgreSQL 8.0.3

2005-07-14 Thread Richard Huxton
Solange wrote: As to make the connection with the data base PostgreSQL 8.0.3 being used the address localhost in Ipv6([::1 ]) ? It is possible? I think it should be possible to connect via IPv6, so long as your operating-system supports it properly. Have you found problems? PS - did you kno

[GENERAL] PostgreSQL 8.0.3

2005-07-14 Thread Solange
    As to make the connection with the data base PostgreSQL 8.0.3 being used the address localhost in Ipv6([::1 ]) ? It is possible?

[GENERAL] PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms

2005-06-17 Thread Kathir Velu
Hello All,       PostgreSQL-8.0.3 doesnot work with time zone value WAT0 ( for West Africa Time ).  HP Unix 11.23 PA and IPF servers set the time zone value for West Africa Time as "WAT0" in it's "/etc/TIMEZONE" file.    When we try to initialize the database directories using initdb comman

[GENERAL] Postgresql 8.0.3 Zip Files corrupt...

2005-05-13 Thread Mario Guenterberg
Hi I've downloaded the zip binaries of postgresql 8.0.3 from some of the mirrors. All of the dowmloaded files are corrupt. With best regards. -- Mario Günterberg mattheis. werbeagentur IT Engineer / Projektleiter Zillestrasse 105a. D - 10585 Berlin Tel#49-(0)30 . 34 80 633 - 0 Fax#49-(0)30 .