pg_statistic cannot open pg_statistic: No such file or directory

From: fpussault(at)caramail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_statistic cannot open pg_statistic: No such file or directory
Date: 2002-09-02 12:03:46
Message-ID: 1030957426016597@caramail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pg_statistic cannot open pg_statistic: No such file or
directory

Condition founding this error :
working well on psql console mode, done a \q to quit
the database, & tryied to open another one :

@linux:~> psql medias
NOTICE: RelationBuildDesc: can't open pg_statistic: No
such file or directory
ERROR: cannot open pg_statistic: No such file or
directory
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

medias=>

So i tought i could restore my databases with backup
but my pg_restore reported this error :
kneko(at)linux:/media/cdrecorder/dbkp> pg_restore -F t -R
-v medias /media/cdrecorder/media.sql.tar
pg_restore: [tar archiver] could not open TOC file for
input: No such file or directory

I cannot understand what append...& i cannot either
create any new database or work at all.

createdb works but then :
kneko(at)linux:~> createdb for_test
CREATE DATABASE
kneko(at)linux:~> psql for_test
NOTICE: RelationBuildDesc: can't open pg_statistic: No
such file or directory
ERROR: cannot open pg_statistic: No such file or
directory
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

for_test=>

as you see it is the same kind of error.

I don't undesrtand how it can append, i was working &
then sudenly this error occured.
Now i cannot do anything...more

Please help, i don't find any useful information in
documentation.
______________________________________________________
Boîte aux lettres - Caramail - http://www.caramail.com

Browse pgsql-bugs by date

  From Date Subject
Next Message * * 2002-09-03 14:56:04 ERROR: parser: parse error at or near "'"
Previous Message Amit Gupta 2002-09-02 11:52:37 Fw: recreate_mmaps_after_fork_failed