Re: Error with vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marcos Alonso, Javier" <jmalonso(at)indra(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error with vacuum
Date: 2002-05-07 14:42:40
Message-ID: 23487.1020782560@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Marcos Alonso, Javier" <jmalonso(at)indra(dot)es> writes:
> java.sql.SQLException: NOTICE: Cannot rename init file /usr/local/pgsql/da=
> ta/base/1166555/pg_internal.init.1380 to /usr/local/pgsql/data/base/1166555=
> /pg_internal.init: Permission denied
> Continuing anyway, but there's something wrong.

Something wrong with the permissions on the directory
/usr/local/pgsql/data/base/1166555/, perhaps? That directory,
along with everything else under /usr/local/pgsql/data, *must* be
owned and writable by the user that the postgres server is running as.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2002-05-07 15:01:47 Re: Subject: bool / vacuum full bug followup part 2
Previous Message Oliver Elphick 2002-05-07 14:42:39 How can I speed up this search?