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
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
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:
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:
>
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
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
> > --
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
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 | *
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
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 '
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
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
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
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||')';
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
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
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
17 matches
Mail list logo