On Thu, Jul 16, 2009 at 4:41 PM, Juan C. Aragon<juan@keisercomputers.com> w=
rote:
> 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 =E2=80=
=9CWARNING:
> out of shared memory=E2=80=9D
>
> 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=C2=A0=C2=A0=C2=A0 WARNING:=C2=A0 worker took too =
long to start;
> cancelled
>
> 2009-07-16 16:54:05 EDT=C2=A0=C2=A0=C2=A0 WARNING:=C2=A0 out of shared me=
mory
>
> 2009-07-16 16:54:05 EDT=C2=A0=C2=A0=C2=A0 FATAL:=C2=A0 out of shared memo=
ry
>
>
but this, is a different thing...
how much memory you have in your machine? and how much has been
assigned to postgres via shared_buffers?
can you show a self contained example of this (eg: the minimun
structure of the table and the inserts you need to make the bug
happen)?
>
> Also, we are not able to login to the database with PgAdmin, getting same
> error =E2=80=9Cout of shared memory=E2=80=9D
>
what's the value in max_connections?
--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157