ERROR: nodeRead: did not find '}'

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Andrei Ivanov

    ERROR: nodeRead: did not find '}'


    Hello,
    it seems my postgresql data has somehow become corrupted (by a forced
    shutdown I think):

    psql template1 -U shadow
    Password:
    ERROR: nodeRead: did not find '}' at end of plan node
    Welcome to psql 7.3.4, 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

    template1=> \d
    ERROR: current transaction is aborted, queries ignored until end of
    transaction block
    template1=> abort;
    ROLLBACK
    template1=> \d
    ERROR: nodeRead: did not find '}' at end of plan node

    Every command that tries to access a table gives this error...


    pg_dumpall says:

    pg_dump: SQL command failed
    pg_dump: Error message from server: ERROR: nodeRead: did not find '}' at
    end of plan node
    pg_dump: The command was: select (select usename from pg_user where
    usesysid = datdba) as dba, encoding, datpath from pg_database where
    datname = 'cinema'
    pg_dumpall: pg_dump failed on cinema, exiting


    What can I do ?

    (postgresql 7.3.4 on a gentoo linux box, with psql from the same package)

    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to majordomo@postg resql.org so that your
    message can get through to the mailing list cleanly

Working...