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
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 |