backup and store oids

From: Gabriel Lopez <gabilm(at)dif(dot)um(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: backup and store oids
Date: 2000-11-30 09:47:34
Message-ID: 3A262235.9D2A55AF@dif.um.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all, I'm using postgresql-7.0.2 on Linux RedHat 6.2 system.

I need help to some question:

1. I have problem insert oid object in a table, not always,
sometimes. I have the exception

FastPath call returned FATAL 1: my bits moved right off
Recreate index pg_attribute_relid_attnum_index.

I also have this problem on Solaris 7. It appear with a simple
table as a:
create table ttest (pkey int8, test oid);

2. When backup my database use:
pg_dump dbname > dbname.pgdump

but when restore it:
cat dbname.pgdump | psql dbname

oid objets are not restore correctly
There's any other way to backup oid objects?

Thanks, 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Poul L. Christiansen 2000-11-30 09:56:15 Re: backup and store oids
Previous Message Alistair Hopkins 2000-11-30 09:45:09 RE: Database cluster?