Re: Error with vacuum

From: Francisco Reyes <lists(at)natserv(dot)com>
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 15:04:28
Message-ID: 20020507110206.Y3527-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-05-07 15:43:24 Re: Allow user to create tables
Previous Message Alvaro Herrera 2002-05-07 15:03:20 Re: IF- statements in a rule's 'DO INSTEAD SELECT ...'- statement