Venkat_B
Member
Joined: 16 Jun 2008 08:39:02
Messages: 45
Offline
|
Hi,
I'm having problem with using pgfsck.Any suggestions for this problem......
[postgres@rt disk2]$ ./pgfsck -d /opt/PostgresPlus/8.3/data/ test
-- Detected database format 8.3
-- Loading pg_class structure
-- Scanning table pg_class (1259)
Couldn't find class 'pg_attribute'
[postgres@rt disk2]$ psql -d test -U pgdba
Welcome to psql 8.1.10 (server 8.3.3), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
WARNING: You are connected to a server with major version 8.3,
but your psql client is major version 8.1. Some backslash commands,
such as \d, might not work properly.
test=# \d pg_attribute
Table "pg_catalog.pg_attribute"
Column | Type | Modifiers
---------------+----------+-----------
attrelid | oid | not null
attname | name | not null
atttypid | oid | not null
attstattarget | integer | not null
attlen | smallint | not null
attnum | smallint | not null
attndims | integer | not null
attcacheoff | integer | not null
atttypmod | integer | not null
attbyval | boolean | not null
attstorage | "char" | not null
attalign | "char" | not null
attnotnull | boolean | not null
atthasdef | boolean | not null
attisdropped | boolean | not null
attislocal | boolean | not null
attinhcount | integer | not null
Indexes:
"pg_attribute_relid_attnam_index" UNIQUE, btree (attrelid, attname)
"pg_attribute_relid_attnum_index" UNIQUE, btree (attrelid, attnum)
test=# \q
|