In response to Ivan Voras <ivo...@freebsd.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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
