Postgres Pro
Downloads
Home   >   mailing lists

Re: When adding millions of rows at once, getting out of disk space errors - Mailing list pgsql-general

From John R Pierce
Subject Re: When adding millions of rows at once, getting out of disk space errors
Date
Msg-id 499C7BBD.6060109@hogranch.com
Whole thread Raw
In response to Re: When adding millions of rows at once, getting out of disk space errors  (Mike Christensen <imaudi@comcast.net>)
Responses Re: When adding millions of rows at once, getting out of disk space errors  (Mike Christensen <imaudi@comcast.net>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Appending \o output instead of overwriting the output file
Next
From: Mike Christensen
Date:
Subject: Re: When adding millions of rows at once, getting out of disk space errors