Re: Transaction Logs Recycling Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Colin Mangiagalli" <colin(at)camara(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Transaction Logs Recycling Problem
Date: 2003-02-18 14:56:52
Message-ID: 23373.1045580212@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Colin Mangiagalli" <colin(at)camara(dot)co(dot)za> writes:
> Could these permission denied errors have been cause by the fact that
> ntsec was off and the permissions weren't set correctly on the
> data folder.

If the folder permissions were wrong, then every single attempt to
create or rename a log file would have failed, I'd think. It sounded to
me more like a few of the individual log files had wrong ownership or
permissions. If you ran initdb as Administrator then the
originally-created log file would have belonged to Administrator, but
the additional ones would have belonged to postgres --- that might
explain the behavior.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-02-18 14:59:24 Re: Seeking advice on database table design for storing images
Previous Message Greg Sabino Mullane 2003-02-18 14:52:34 TIP #5 has a bad URI