custom search_path reverts to default after DB restore

From: "Jonathan Brinkman" <jonathanbrinkman(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: custom search_path reverts to default after DB restore
Date: 2010-10-06 13:39:24
Message-ID: 001201cb655b$e3fe3c30$abfab490$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings
I have a customized search_path for my database. When I backup (pgdump) the
database and restore it to another server, the search_path must be reset,
since it reverts to $User, public upon restore.

Why is the search_path info not being retained in the backup?
Thank you!
Jonathan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-10-06 13:54:22 Re: querying the version of libpq
Previous Message Raymond O'Donnell 2010-10-06 13:33:26 Re: Idle connections