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

Поиск
Список
Период
Сортировка
От Mike Christensen
Тема Re: When adding millions of rows at once, getting out of disk space errors
Дата
Msg-id 499C7DA2.5070204@comcast.net
обсуждение исходный текст
Ответ на Re: When adding millions of rows at once, getting out of disk space errors  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
I just changed the account manually and did not set a disk quota..

However, now I have bigger problems since the service will not start up
anymore.  I tried re-booting twice.

First I get:

2009-02-18 21:24:25 GMT FATAL:  lock file "postmaster.pid" already exists
2009-02-18 21:24:25 GMT HINT:  Is another postmaster (PID 1888) running
in data directory "C:/Program Files/PostgreSQL/8.3/data"?

After I delete the file, I try to start the service again and get:

2009-02-18 13:27:18 PST FATAL:  could not create any TCP/IP sockets

Any ideas?

John R Pierce wrote:
> 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: When adding millions of rows at once, getting out of disk space errors
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: COPY questions