Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux