Search Postgresql Archives

Re: searchpath reverts to default after each server restart

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



alter database "MYDATABASE" SET search_path TO custom,  clientdata, configs,
replication, structure, archive;
that seems to fix it.
Thank you!

-----Original Message-----
From: Merlin Moncure [mailto:mmoncure@xxxxxxxxx] 
Sent: Wednesday, September 15, 2010 4:40 PM
To: Jonathan Brinkman
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  searchpath reverts to default after each server
restart

On Wed, Sep 15, 2010 at 4:12 PM, Jonathan Brinkman
<jonathanbrinkman@xxxxxxxxx> wrote:
> 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;

the path needs to be single quoted.

merlin


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux