Le mercredi 2 décembre 2009 à 07:34:09, Brian Myers a écrit :
Hi all,
I'm trying to restore an old backup (7.1.4) into a new PG database (8.4).
There are errors with some of the RI and sequences, but those are easy to
fix.
The problem is that one table in the DB has TEXT fields in it
Hi, excuse my ignorance, but I have a couple of quick questions regarding
vacuuming and indexes.
When you do a vacuum it marks the deleted rows as being usable again and I
can see that it reports that xxx index row versions were removed, however
are these rows marked for reuse in an index in
Hi
The logs that you attach do show an error:
pg_restore: [programme d'archivage (db)] could not execute query: ERROR: schema
bga_3122 already exists
Command was:
CREATE SCHEMA bga_3122;
so maybe you need to run the restore with --clean which will drop
database objects before recreating
John Lister john.lister...@kickstone.com wrote:
When you do a vacuum it marks the deleted rows as being usable
again and I can see that it reports that xxx index row versions
were removed, however are these rows marked for reuse in an index
in the same manner as they are in the table? I note