On Wednesday 04 May 2011 17:32:50 Tom Lane wrote: > Hmm, is this an autogenerated index? I don't think so. And to confirm, that i really deleted the new cluster between the pg_upgrade run and the dump|restore i did it again and was able to revive this index again: foo=# \d+ foo.bar_idx Index "foo.bar_idx" Column | Type | Definition | Storage | Description ----------+-----------------------+------------+----------+------------- ulq_guid | character varying(24) | ulq_guid | extended | btree, for table "foo.foo" But it's again not in the pg_dumpall output, using the same binary like for the dump|restore. Regards, Jens -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general