Error with vacuum

"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

On Mon, 6 May 2002, Marcos Alonso, Javier wrote:

Hello i am Javier I have problems with the vacuum statement . The problem is :
java.sql.SQLException: NOTICE: Cannot rename init file /usr/local/pgsql/data/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.
Can you help me ????.

I am no expert, but have you checked the rights of that file?
How about checking who is the owner of that file.
Also check that there isn't already a pg_internal.init file.

You may also want to try bringing down the database, pg_ctl stop and then
see if both of those files exist and what are their/it's rights.