On 20 December 2011 15:35, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > To elaborate on my previous answer, search_path is in postgresql.conf because it > is tied to the database cluster not a particular database. Not necessarily, it can also be tied to a schema or a role or (I assume) a specific database in the cluster. ALTER ROLE x SET search_path TO ... ALTER SCHEMA x SET search_path TO ... I don't have a PG instance available here, so I can't verify whether those get dumped/restored. I assume they do though. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
