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
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 |