Re: Copying databases with extensions - pg_dump question

In response to Ivan Voras <ivoras(at)freebsd(dot)org>:

> A fairly frequent operation I do is copying a database between servers,
> for which I use pg_dump. Since the database contains some extensions -
> most notably hstore and tsearch2, which need superuser privileges to
> install, I have a sort of a chicken-and-egg problem: the owner of the
> database (and all its objects) should be a non-superuser account so I
> can't simply use the output from pg_dump and expect everything to be
> correct after restoring it.

Why not? If the ownership on the original database is non-superuser, then
that will be faithfully preserved when the database is restored. What
are you doing to cause it to behave differently?

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/