Hi, If a database with the bloom extension installed is dumped and restored, there's an error with the access method creation:
createdb bloomtest psql -c 'CREATE EXTENSION bloom;' bloomtest pg_dump -d bloomtest > ~/tmp/bloom.sql createdb bloomtest2 psql -d bloomtest2 -f ~/tmp/bloom.sql The output of the last command produces: "psql:/home/thom/tmp/bloom.sql:48: ERROR: access method "bloom" already exists" So pg_dump shouldn't be dumping this access method as it's part of the extension. Regards Thom