Re: Permission denied errors

On Tue, Aug 23, 2005 at 11:06:44AM -0400, Zeki Mokhtarzada wrote:
> Very interesting...  We recently changed the location of the data files
> using a symbolic link.  Although all of the files had the correct ownership,
> the new parent directory was not owned by postgres.  The strange thing
> is that we have been running like this for over a week, and even now,
> only the log table was effected  (the log table is the only table that
> has a large number of data changing, most of the other tables are
> relatively static).  Changing the owner of the parent directory to
> postgres fixed the problem.

Probably, this is because on other tables you do not need to create new
segments, while the ev_log table is big enough to need some.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"People get annoyed when you try to debug them."  (Larry Wall)