Re: Error with vacuum - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Error with vacuum
Date
Msg-id 20020507110206.Y3527-100000@zoraida.natserv.net
Whole thread Raw
In response to Error with vacuum  ("Marcos Alonso, Javier" <jmalonso@indra.es>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement
Next
From: Ron Snyder
Date:
Subject: Re: Using views and MS access via odbc