We are working on Windows Server 2003 Enterprise with PostgreSQL 8.4, when
we start populating a table with 130,000 records it start giving "WARNING:
out of shared memory"
on every record that was inserted. At the end it did not finish, it only
inserted 4,000 records and got the following message:
2009-07-16 16:54:05 EDT WARNING: worker took too long to start;
2009-07-16 16:54:05 EDT WARNING: out of shared memory
2009-07-16 16:54:05 EDT FATAL: out of shared memory
Also, we are not able to login to the database with PgAdmin, getting same
error "out of shared memory"
Once we stop and start the service, we were able to access the database
Any ideas what is going wrong?
pgsql-bugs by date
|Next:||From: Jaime Casanova||Date: 2009-07-16 21:44:56|
|Subject: Re: FATAL: could not reattach to shared memory (key=268, addr=01E30000): 487|
|Previous:||From: Greg Stark||Date: 2009-07-16 20:27:47|
|Subject: Re: BUG #4926: too few pathkeys for mergeclauses|