backup and restore

Started by Gabriel Lopezabout 25 years ago1 messagesgeneral
Jump to latest
#1Gabriel Lopez
gabilm@dif.um.es

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