473,378 Members | 1,175 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

searchpath reverts to default after each server restart

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


Expand|Select|Wrap|Line Numbers
  1. #[postgresql.conf file:]
  2. # the postgresql service wouldn't start with this setting. 
  3.  
  4.  
  5. # CLIENT CONNECTION DEFAULTS
  6. #------------------------------------------------------------------------------
  7.  
  8. # - Statement Behavior -
  9.  
  10. search_path = custom,idsystems,clientdata,configs,replication,structure,archive,public;
  11. #schema names
  12. #default_tablespace = ''        # a tablespace name, '' uses the default
  13. #temp_tablespaces = ''            # a list of tablespace names, '' uses
  14.                     # only 
  15.  
  16.  
  17.  
Sep 15 '10 #1
2 1990
i think i fixed it by using the ALTER DATABASE command with it.
alter database "MYDATABASE" SET search_path TO custom, clientdata, configs, replication, structure, archive;
Sep 15 '10 #2
rski
700 Expert 512MB
Do not remove apos, should be
Expand|Select|Wrap|Line Numbers
  1. search_path = 'custom,idsystems,clientdata,configs,replication,structure,archive,public'
  2.  
Sep 15 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Mike | last post by:
Hi, I have an architectural type question that centers around php. We have a website that people hit that uses php to dynamically generate web pages. We use Apache and php (although we don't have...
9
by: ruud | last post by:
I just installed MySQL server 3.23.58-1. Now I can't find the password en can's change the settings. Who knows this password?
3
by: Nagy Karoly | last post by:
Is there any way to close the connections of other users in PostgreSQL. I wish to run an automatic pg_dump and pg_restore and I guess users must bedisconnected first. Is that right?...
0
by: Robert Fitzpatrick | last post by:
I guess this is not possible? The installer cannot find the postgres user, which is in the Active Directory. It is a Win 2003 Ent server used here for testing things. Can someone point me to the...
2
by: topgene | last post by:
question describe: i used C# write the follow method: -------------------------------------------------------------------------------- public static void GetMp3FileFromAudio(string...
0
by: Joe | last post by:
Hi All: I am trying to create a website, where the default.aspx page is inside a directory and I would like to be able to run the site in such a way that the URL does not show the directory...
0
by: koolestj | last post by:
I am trying to understand why a server restart would cause mod_jk to not find a worker. I checked all tomcat workers were running and I was able to telnet to the ajp port on each app server. Just...
0
by: raghutumma | last post by:
Hi, I need help from you... I want to find SQL Servers which are available in Network and Databases in Each Server Using Batch file. If i run this Batch file it should find SQL Servers &...
13
by: btreddy | last post by:
Hii all, I've been searching in the internet just to know abt SMTP server. Can anybody tell me how to configure the SMTP server and how can i send the mails and how could i check whether...
0
by: ctatvasoft | last post by:
in our application that need to create some tables in tempdb. The user (call it APP) is not sa. Everytime that the server need to be rebooted, the db_owner role on tempdb for user APP disappear....
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.