Re: META vacuum - FAIL: ERROR - Mailing list pgsql-novice

From Henshall, Stuart - WCP
Subject Re: META vacuum - FAIL: ERROR
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F748D7@MAIL_EXCHANGE
Whole thread Raw
In response to META vacuum - FAIL: ERROR  (Albert Csaba <maka_cs@yahoo.com>)
List pgsql-novice


> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.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

pgsql-novice by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: META vacuum - FAIL: ERROR
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: META vacuum - FAIL: ERROR