Re: When adding millions of rows at once, getting out of disk space errors

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Mike Christensen <imaudi(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: When adding millions of rows at once, getting out of disk space errors
Date: 2009-02-18 21:21:01
Message-ID: 499C7BBD.6060109@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Christensen wrote:
> Ooo good call, the account is part of the "Users" group which has a quota:
>
> The users will have the following disk quota:
> Disk space limited to 1024 MB
> Warning sent at 900 MB
>
> Which is the exact size of the database..
>
> However, anyone have a clue on how to change this? This is Windows
> Server 2003 SBS, I'm not an expert <g>

I'm not particularly familiar with SBS, but in general, the postgres
service account is not normally a part of -any- group on Windows.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2009-02-18 21:29:06 Re: When adding millions of rows at once, getting out of disk space errors
Previous Message Tom Lane 2009-02-18 21:16:06 Re: Appending \o output instead of overwriting the output file