[GENERAL] pg recovery

Hi, I have postgresql streaming replication set up. I forgot to add an entry for trigger_file in recovery.conf. So I added that entry and did a pg_ctl reload. Is there a way to confirm that the entry has been read by the server? Any view/function? Regards, Jayadevan DISCLAIMER: "The informa

Re: [GENERAL] pg recovery

On Thu, Jul 11, 2013 at 4:39 PM, Jayadevan M wrote: > I have postgresql streaming replication set up. I forgot to add an entry for > trigger_file in recovery.conf. So I added that entry and did a pg_ctl > reload. Recovery parameters are not GUC parameters, so doing a parameter reload has no effect

Re: [GENERAL] pg recovery

Hi Jayadevan, Il 11/07/2013 09:39, Jayadevan M ha scritto: Hi, I have postgresql streaming replication set up. I forgot to add an entry for trigger_file in recovery.conf. So I added that entry and did a pg_ctl reload. Is there a way to confirm that the entry has been read by the server? Any

[GENERAL] function query error: column does not exist

i've a function takes as argument some values of few types, and make some INSERT operation using that values. I've occour an error while calling that function, the error is on a varchar variable. this is the insert code: >EXECUTE 'INSERT INTO table VALUES('||value1||','[...]','||value_char||')';

Re: [GENERAL] pg recovery

Hi, > wrote: >> I have postgresql streaming replication set up. I forgot to add an >> entry for trigger_file in recovery.conf. So I added that entry and did >> a pg_ctl reload. >Recovery parameters are not GUC parameters, so doing a parameter reload >has no effect. Also, such parameters cannot be c

Re: [GENERAL] function query error: column does not exist

On 11 July 2013 11:01, giozh wrote: > this is the insert code: > > >EXECUTE 'INSERT INTO table VALUES('||value1||','[...]','||value_char||')'; > > and the error is on value_char. pg told me that "column does not exist". > A few suggestions: 1. Post a statement that actually matches your problem

Re: [GENERAL] pg recovery

On Thu, Jul 11, 2013 at 6:19 PM, Jayadevan M wrote: > Hi, >> wrote: >>> I have postgresql streaming replication set up. I forgot to add an >>> entry for trigger_file in recovery.conf. So I added that entry and did >>> a pg_ctl reload. >>Recovery parameters are not GUC parameters, so doing a parame

Re: [GENERAL] pg recovery

overy has begun. >> Recovery has not begun. Without the change, the recovery will not start. So, >do I have to do a reload, or restart, for the parameter to take effect? The >situation is - master is up and running, slave is up and running. I made a >change to recovery.conf. How can I make slave '

[GENERAL] Re: Reply: [GENERAL] 回复： [GENERAL] Can't create plpython language

On Wed, Jul 10, 2013 at 7:36 AM, guxiaobo1982 wrote: > I am using PostgreSQL 9.3 beta 2 > > [postgres@lix Multicorn-master]$ psql > psql (9.3beta2) > Type "help" for help. > > postgres=# > > > It does not work with > ActivePython3.2(ActivePython-3.2.2.3-linux-x86_64.tar.gz), Which version of > Po

[GENERAL] How can you get "WAL segment has already been removed" when doing synchronous replication ?!

We are seeing situation like this: 1. 9.2.4 database 2. Master settings: name|setting ---+--- fsync | on synchronize_seqscans | on synchronous_commit| remote_write synchronous_standby_names | *

Re: [GENERAL] How can you get "WAL segment has already been removed" when doing synchronous replication ?!

On Thu, Jul 11, 2013 at 11:18 PM, hubert depesz lubaczewski < dep...@depesz.com> wrote: > We are seeing situation like this: > 1. 9.2.4 database > 2. Master settings: >name|setting > ---+--- > fsync | on > synchr

Re: [GENERAL] How can you get "WAL segment has already been removed" when doing synchronous replication ?!

On Thu, Jul 11, 2013 at 11:29:24PM +0530, Raghavendra wrote: > On Thu, Jul 11, 2013 at 11:18 PM, hubert depesz lubaczewski < > dep...@depesz.com> wrote: > > > We are seeing situation like this: > > 1. 9.2.4 database > > 2. Master settings: > >name|setting > > --

[GENERAL] Transaction control in shards through PLPROXY

Hi, Even though this mailing list is for postgresql users only, I am sending this query related to postgresql sharding in case anyone has already faced this problem while sharding their database. Inspite of being aware that PLPROXY does autocommit for DML functions called on shards, I was wond

Re: [GENERAL] backend hangs at sendto() and can't be terminated

On Jul 8, 2013, at 6:48 AM, Jov wrote: > netstat show nothing about the socket of the process,so I think the TCP > timeout took effect.so it is really wired. > > Jov > blog: http:amutu.com/blog > > > 2013/7/8 Tom Lane > Merlin Moncure writes: >> On Mon, Jul 8, 2013 at 4:56 AM, Jov wrote: >

Re: [GENERAL] backend hangs at sendto() and can't be terminated

On Jul 8, 2013, at 6:48 AM, Jov wrote: > netstat show nothing about the socket of the process,so I think the TCP > timeout took effect.so it is really wired. > > Jov > blog: http:amutu.com/blog > > > 2013/7/8 Tom Lane > Merlin Moncure writes: > > On Mon, Jul 8, 2013 at 4:56 AM, Jov wrote:

[GENERAL] Full text search

Hello everyone, I am using full text search, however it is not helping me to get the partial value. For example in my document let Pizza Hut is there, if i am searching for Pizza Hut is it giving me the values for only Pizza or a spell mistake like pizz is not returning any thing. any work arou

Re: [GENERAL] Full text search

On Fri, Jul 12, 2013 at 11:48 AM, itishree sukla wrote: > Hello everyone, > > I am using full text search, however it is not helping me to get the > partial value. > > For example in my document let Pizza Hut is there, if i am searching for > Pizza Hut is it giving me the values for only Pizza o