Re: Postgres issues "Not enough storage is available to complete this operation" exception - Mailing list pgsql-general

From Thom Brown
Subject Re: Postgres issues "Not enough storage is available to complete this operation" exception
Date
Msg-id bddc86150911160904o7b8a8d9bge0611495f22dffb6@mail.gmail.com
Whole thread Raw
In response to Postgres issues "Not enough storage is available to complete this operation" exception  ("Maria Cianci" <Maria.Cianci@cae.com>)
List pgsql-general
2009/11/16 Maria Cianci <Maria.Cianci@cae.com>:
> All,
>
>
>
>    I am running on a Windows XP machine, 4GB of RAM and over 26GB of free
> hard-disk an application that all it does is insert records into the
> Postgres 8.3 database.  When the database is approx 17GB Postgres issues the
> “Not enough storage is available to complete this operation” and refuses to
> insert records.  I normally shut down and restart the application and data
> collection continues normally until it reaches the 26GB and issues the same
> error: “Not enough storage is available to complete this operation.”  I’m
> very puzzled to say the least.  The Postgres configuration is attached.  For
> some reason Postgres would no load if shared_buffers > 900MB.
>
>
>
> I should say that my Windows is running with the /3GB flag.
>
>
>
> Thanks in advance for any help you can offer.
>

From looking at a previous post, you'd need to install/reinstall MDAC
2.6: http://archives.postgresql.org/pgadmin-support/2002-05/msg00063.php

Regards

Thom

pgsql-general by date:

Previous
From: "Maria Cianci"
Date:
Subject: Postgres issues "Not enough storage is available to complete this operation" exception
Next
From: Reno Bladergroen
Date:
Subject: createdb errors and more