searchpath reverts to default after each server restart

From: "Jonathan Brinkman" <jonathanbrinkman(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: searchpath reverts to default after each server restart
Date: 2010-09-15 20:12:08
Message-ID: 01fc01cb5512$46ede840$d4c9b8c0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When i run the command
SET search_path TO custom,idsystems, clientdata, configs, replication,
structure, archive;
then when I run
SHOW search_path;
it does show those schemas as the search_path. however when i restart the
postgresql service, the search_path has reverted to $User, public.
when i put the SET search_path function in the postgresql.conf file (as
below) the service wouldn't restart. i think because it doesn't like the
"public" schema (which i don't use).

#[postgresql.conf file:]
# the postgresql service wouldn't start with this setting.


# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------
---

# - Statement Behavior -

search_path =
custom,idsystems,clientdata,configs,replication,structure,archive,public;
#schema names
#default_tablespace = '' # a tablespace name, '' uses the default
#temp_tablespaces = '' # a list of tablespace names, '' uses
# only

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-09-15 20:40:22 Re: searchpath reverts to default after each server restart
Previous Message Peter Hopfgartner 2010-09-15 20:11:26 Re: Getting FATAL: terminating connection due to administrator command