Re: Transaction Logs Recycling Problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Transaction Logs Recycling Problem
Date
Msg-id 23373.1045580212@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transaction Logs Recycling Problem  ("Colin Mangiagalli" <colin@camara.co.za>)
List pgsql-general
"Colin Mangiagalli" <colin@camara.co.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

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: TIP #5 has a bad URI
Next
From: Jan Wieck
Date:
Subject: Re: Seeking advice on database table design for storing images