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) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
