EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Error using pgfsck  XML

Forum Index » Standard Server
Author Message
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
ashaar

Member
[Avatar]

Joined: 28 Mar 2008 08:00:06
Messages: 88
Location: East Brunswick, NJ
Offline

Hi

Which version of pgfsck are you using? IIRC, pg 8.3 isn't yet supported by it.

Thanks
[WWW]
 
Forum Index » Standard Server
Go to:   
Powered by JForum 2.1.8 © JForum Team