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 supported yet

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 file

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

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

2009-06-24 Thread Philippe Amelant
' ,'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 pamel...@companeo.com writes: Can I workaround this ? Don't assume that 1 month means a constant number of seconds

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 pamel...@companeo.com 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') - EXTRACT(EPOCH FROM

[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 ? Is

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 send by Teodor Sigaev (http

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 add -i at for gendict config.sh

[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

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

2007-05-14 Thread Philippe Amelant
for 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 last

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

2007-05-02 Thread Philippe Amelant
?? 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 have a problem with tsearch. I use

[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

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 - dict_fr.so Are you sure you used the same