Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Philippe Amelant
Le 13/11/2012 14:57, Albe Laurenz a écrit : Philippe Amelant wrote: So i was thinking it was just a reconnect to the sender (and I can see the standby trying to reconnect in the log) Hmmm. I think I was too quick when I said no. If you ship the WAL archives including the "history&quo

Re: [GENERAL] Understanding streaming replication

2012-11-13 Thread Philippe Amelant
Hello, Thank for all this informations Le 13/11/2012 09:31, Albe Laurenz a écrit : Philippe Amelant wrote: I'm setting up a 3 nodes cluster and after some tests I just discover that the cascading slave does not recover. Right, switching timeline over streaming replication is not supporte

Re: [GENERAL] Understanding streaming replication

2012-11-12 Thread Philippe Amelant
Hello all, I read this thread with interest but I still have some questions about cascading replication as you describe it. Le 12/11/2012 10:36, Albe Laurenz a écrit : I'll try to answer the questions I can. 3. Recovery. That part is a bit confusing. The majority of the documentation says th

Re: [GENERAL] possible bug on age() function (8.2.4 , 8.3.6)

2009-06-24 Thread Philippe Amelant
Le mercredi 24 juin 2009 à 12:45 +, Jasen Betts a écrit : > On 2009-06-24, Philippe Amelant wrote: > > Ok but if I work with hours or whatever the problem is still there > > > > SELECT (EXTRACT(EPOCH FROM TIMESTAMP '2009-06-23 18:36:05.064066+02') - > > E

Re: [GENERAL] possible bug on age() function (8.2.4 , 8.3.6)

2009-06-24 Thread Philippe Amelant
3600, age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066+02"') > interval '1007 hours'; The third test should be true and not false Le mardi 23 juin 2009 à 13:43 -0400, Tom Lane a écrit : > "Philippe Amelant" writes:

[GENERAL] possible bug on age() function (8.2.4 , 8.3.6)

2009-06-23 Thread Philippe Amelant
Hi all, here is a little test case for a problem we run into in our developpement Is it a bug or a setting problem ? try select (current_timestamp),(current_timestamp - interval '1008 hours'); report this value in age() select age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066 +

Re: [GENERAL] Tsearch2: upgrading from postgres 8.1.x to 8.2.x

2007-05-24 Thread Philippe Amelant
Le mercredi 23 mai 2007 à 11:08 -0400, Rick Schumeyer a écrit : > I have a database running under pg 8.1.4 that uses tsearch2. I am > upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to > install it in pg 8.2.4. This does not seem to work. > Are you using snowball stemmer ? >

Re: [GENERAL] Postgresql 8.2.4 crash with tsearch2

2007-05-22 Thread Philippe Amelant
hum not enough tests before sending this mail, the fisrt request select lexize('fr','chose'); work but the server crash on the second resquest (the same one) Le mardi 22 mai 2007 à 12:16 +0200, Philippe Amelant a écrit : > hi, > Ok it's my mistake, I forgot to ad

Re: [GENERAL] Postgresql 8.2.4 crash with tsearch2

2007-05-22 Thread Philippe Amelant
hi, Ok it's my mistake, I forgot to add "-i" at for gendict config.sh regards Le lundi 21 mai 2007 à 19:32 +0200, Philippe Amelant a écrit : > hi, > I have compiled postgresql 8.2.4 on a debian etch witch french snowball > stemmer . > I applied the lastest patch se

[GENERAL] Postgresql 8.2.4 crash with tsearch2

2007-05-21 Thread Philippe Amelant
hi, I have compiled postgresql 8.2.4 on a debian etch witch french snowball stemmer . I applied the lastest patch send by Teodor Sigaev (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82-20070504.gz) and my backend still crash. I tested on 2 differents server both with etc

[GENERAL] RE : [GENERAL] Server crash on postgresql 8.2.4 with tsearch2

2007-05-14 Thread Philippe Amelant
you help De: Teodor Sigaev [mailto:[EMAIL PROTECTED] Date: ven. 04/05/2007 12:25 À: Philippe Amelant Cc: pgsql-general@postgresql.org Objet : Re: [GENERAL] Server crash on postgresql 8.2.4 with tsearch2 > Are tsearch2 from postgresql 8.2.4 compatible with l

Re: [GENERAL] Server crash on postgresql 8.2.4 with tsearch2

2007-05-02 Thread Philippe Amelant
s.org ?? else what can I use ? Thanks Le lundi 30 avril 2007 à 18:06 +0200, Philippe Amelant a écrit : > Le lundi 30 avril 2007 à 11:51 -0400, Tom Lane a écrit : > > Philippe Amelant <[EMAIL PROTECTED]> writes: > > > I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I

Re: [GENERAL] Server crash on postgresql 8.2.4 with tsearch2

2007-04-30 Thread Philippe Amelant
Le lundi 30 avril 2007 à 11:51 -0400, Tom Lane a écrit : > Philippe Amelant <[EMAIL PROTECTED]> writes: > > I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with > > tsearch. > > > I use french snowball package to compile a stemming lib ->

[GENERAL] Server crash on postgresql 8.2.4 with tsearch2

2007-04-30 Thread Philippe Amelant
Hi, I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with tsearch. I use french snowball package to compile a stemming lib -> dict_fr.so Now if I do a query like this select to_tsvector('default', '... something with more than 200 chars'); -> result ok but select to_tsvector(