"John Lister" 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 that the docs
> say
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
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
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
