On 20 December 2011 15:35, Adrian Klaver <adrian.klaver@gmail.com> 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.