Postgres Pro
Downloads
Home   >   mailing lists

custom search_path reverts to default after DB restore - Mailing list pgsql-general

From Jonathan Brinkman
Subject custom search_path reverts to default after DB restore
Date
Msg-id 001201cb655b$e3fe3c30$abfab490$@com
Whole thread Raw
In response to Re: searchpath reverts to default after each server restart  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Min Yin
Date:
Subject: Re: How do I write this query? Distinct, Group By, Order By?
Next
From: "Little, Douglas"
Date:
Subject: psql dynamic comments