Обсуждение: Error with vacuum
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 ????.
"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.