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