Re: Postgres issues "Not enough storage is available to complete this operation" exception

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Maria Cianci <Maria(dot)Cianci(at)cae(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres issues "Not enough storage is available to complete this operation" exception
Date: 2009-11-16 17:04:50
Message-ID: bddc86150911160904o7b8a8d9bge0611495f22dffb6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/11/16 Maria Cianci <Maria(dot)Cianci(at)cae(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-11-16 17:10:11 Re: Postgres issues "Not enough storage is available to complete this operation" exception
Previous Message Jonathan 2009-11-16 16:59:37 Re: Full Text Search 101?