Thread: backup and restore

backup and restore

From
Gabriel Lopez
Date:
    Hi all.

    I have a backup of my database created with pg_dump,

    pg_dump -o mydb > mydb.pg_dump

    Use -o option so there are many objetcs.

    I have restore dabase with

    cat mydb |  psql mydb

    When enter in mydb all appear correct, but when I try to get a
object the following error apper:

 ErrorFastPath call returned ERROR:  Relation 66016 does not exist

    where 66016 is the oid of my object.

    How can I restory my database?

    Thanks in advance

    Gabi


--
Gabriel López Millán
Facultad de Informática -Universidad de Murcia
30001 Murcia - España (Spain)
Telf: +34-968-364644 E-mail: gabilm@dif.um.es