Re: META vacuum - FAIL: ERROR

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Albert Csaba' <maka_cs(at)yahoo(dot)com>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: META vacuum - FAIL: ERROR
Date: 2002-06-06 13:05:42
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F748D7@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs(at)yahoo(dot)com]
> Sent: 06 June 2002 11:55
> To: Henshall, Stuart - WCP
> Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> Thank you, it helped me to start. It's my first time
> using PostgreSQL, I've used till now only MySQL, but
> it seems that I am forced a little bit now to use it.
> I have on the Cobalt server PostgreSQL 6.5, and trying
> to do what says there, I'm getting the following:
>
> postgres -D /home/pgsql/ -O
> pg_attribute_attrelid_index
> FATAL 1: Database pg_attribute_attrelid_index does
> not exist in pg_database
> FATAL 1: Database pg_attribute_attrelid_index does
> not exist in pg_database
>
> postgres -D /home/pgsql/base/cobalt -O
> pg_attribute_attrelid_index
> FATAL 1: Cannot open
> /home/pgsql/base/cobalt/pg_database
> FATAL 1: Cannot open
> /home/pgsql/base/cobalt/pg_database
>
> The option -P is not supported. The structure is:
>
> /home/pgsql--base--cobalt--pg_attribute_attrelid_index
>
> Am I doing something wrong? What next?
>
> Thank you,
> Csaba Albert
>

Hi,
What database version are you using? 7.2.1 is the latest.
Is your data directory really /home/pgsql?
This should be the same path you used initdb on.
If you have PG_DATA set then you don't need the -D option.
I just used (for instance):
postgres -O -P template1
you can give your database name instead of template1
hth,
- Stuart

Browse pgsql-novice by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2002-06-06 14:31:17 Re: META vacuum - FAIL: ERROR
Previous Message Henshall, Stuart - WCP 2002-06-06 09:49:24 Re: META vacuum - FAIL: ERROR