[ADMIN] slony replication

2011-09-18 Thread Karuna Karpe
Hello, I try to replicate two server i.e. 1 master and 1 slave using slony replication. can please explain me that when my master server is fail then how to my slave server is work as master (means it able to perform DML operation)? How to do this please give me solution for that? Regard

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Scott Marlowe
On Sun, Sep 18, 2011 at 8:00 PM, Rural Hunter wrote: > Well, I installed pg by the official one-click graphic > installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh, when > I tried to get an error message if I don't set LD_LIBRARY_PATH, I found it's > now working without this var

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
Well, I installed pg by the official one-click graphic installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh, when I tried to get an error message if I don't set LD_LIBRARY_PATH, I found it's now working without this variable. The variable was added into my env for 9.1rc. If I

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Melaka Gunasekara
Thanks for the information Tom. It solved my confusion. On Sun, Sep 18, 2011 at 10:03 PM, Tom Lane wrote: > Craig Ringer writes: > > On 18/09/2011 5:51 PM, Melaka Gunasekara wrote: > >> Merge Full Join (cost=174.40..193.69 rows=1159 > width=286) > > >> Can you suggest why the me

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Tom Lane
Craig Ringer writes: > On 18/09/2011 5:51 PM, Melaka Gunasekara wrote: >> Merge Full Join (cost=174.40..193.69 rows=1159 width=286) >> Can you suggest why the merge join is being suggested when I have >> turned it off ? > AFAIK SETting a join type to "off" really just increases

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Ray Stell
On Sun, Sep 18, 2011 at 10:47:39AM +0800, Rural Hunter wrote: > Any suggestion? I don't do ubuntu this week, so I may be out to lunch, but why don't you append to the system set value of the var. In RH (this week) we do this in /etc/profile.d/localpath.sh but shirley ubuntu has some means for doin

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Peter Eisentraut
On sön, 2011-09-18 at 22:41 +0800, Rural Hunter wrote: > I didn't install anything else there: (for a very small value of "anything else") It looks like you have some version of libncurses in there, which is prone to interfere with the operating system installation. I suppose you got this instal

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
I didn't install anything else there: postgres@backup:~$ ls -l /opt/PostgreSQL/9.1/lib/ Total 9804 -rwxr-xr-- 1 root daemon 1366272 2011-09-09 13:45 libcrypto.so.6 -rw-r--r-- 1 root daemon 149938 2011-09-09 13:44 libecpg.a -rw-r--r-- 1 root daemon 18852 2011-09-09 13:44 libecpg_compat.a -rwxr-x

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Peter Eisentraut
On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote: > This is my env: > postgres@backup:~$ env > MANPATH=:/opt/PostgreSQL/9.1/share/man > SHELL=/bin/bash > TERM=linux > USER=postgres > LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/ > PGPORT=3500 > LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Craig Ringer
On 18/09/2011 5:51 PM, Melaka Gunasekara wrote: Merge Full Join (cost=174.40..193.69 rows=1159 width=286) Can you suggest why the merge join is being suggested when I have turned it off ? AFAIK SETting a join type to "off" really just increases the cost estimate so high th

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Rural Hunter
yes, tried that too and same thing happened. 于2011年9月18日 17:09:25,Richard Shaw写到: Tried adding the path to ldconfig rather than redefining ld_library_path? On 18 Sep 2011, at 09:03, Scott Marlowe wrote: Wow, you got me. On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter wrote: This is my env:

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Melaka Gunasekara
Hi Raghavendra, Thanks for your quick reply, I did as you suggessted and following is my output. melaka=# set enable_mergejoin to off; SET melaka=# show enable_mergejoin; enable_mergejoin -- off (1 row) Then I executed the following query melaka=# EXPLAIN select * from distribu

Re: [ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Raghavendra
postgres=# set enable_hashjoin to off; SET postgres=# show enable_hashjoin; enable_hashjoin - off (1 row) Above, changes applies for the current session (its Session-Level). If you want to do at Database-level use ALTER DATABASE and for entire Cluster-level edit postgresql.conf a

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Richard Shaw
Tried adding the path to ldconfig rather than redefining ld_library_path? On 18 Sep 2011, at 09:03, Scott Marlowe wrote: > Wow, you got me. > > On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter wrote: >> This is my env: >> postgres@backup:~$ env >> MANPATH=:/opt/PostgreSQL/9.1/share/man >> SHELL=/

[ADMIN] How to change query planner configuration paramerters

2011-09-18 Thread Melaka Gunasekara
Hi all, I came across http://www.postgresql.org/docs/8.4/static/runtime-config-query.html which describes how to change query planner configuration paramerters. I need to know how I can change these parameters. For example if I need to turn off enable_hashjoin, how can I do that? Best Regards, M

Re: [ADMIN] Problem of LD_LIBRARY_PATH

2011-09-18 Thread Scott Marlowe
Wow, you got me. On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter wrote: > This is my env: > postgres@backup:~$ env > MANPATH=:/opt/PostgreSQL/9.1/share/man > SHELL=/bin/bash > TERM=linux > USER=postgres > LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/ > PGPORT=3500 > LS_COLORS=rs=0:di=01;34:ln=01;36:mh=