Re: Error with vacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Error with vacuum
Date
Msg-id 23487.1020782560@sss.pgh.pa.us
Whole thread Raw
In response to Error with vacuum  ("Marcos Alonso, Javier" <jmalonso@indra.es>)
List pgsql-general
"Marcos Alonso, Javier" <jmalonso@indra.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

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: How can I speed up this search?
Next
From: Bruno Wolff III
Date:
Subject: Re: Allow user to create tables