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
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? |