backup and restore

From: Gabriel Lopez <gabilm(at)dif(dot)um(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: backup and restore
Date: 2001-01-10 09:53:09
Message-ID: 3A5C3105.AA659C81@dif.um.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)dif(dot)um(dot)es

Browse pgsql-general by date

  From Date Subject
Next Message jeremy ergisi 2001-01-10 10:09:01 The type conversion CAST does not work ??
Previous Message Vitaliy V. Romanets 2001-01-10 09:49:28 It's a test