<span id="result_box" class="" lang="en"><span class="hps">thanks for replying,</span><br> <span class="hps"></span><br> <span class="hps">I have my</span> <span class="hps">development</span> <span class="hps">database</span> <span class="hps">that</span> <span class="hps">contains the table</span> <span class="hps">test.</span> <span class="hps">well</span><span>,</span> <span class="hps">to</span> <span class="hps">insert records</span><span>,</span> <span class="hps">comparing</span> <span class="hps">both tables</span> <span class="hps">and</span> <span class="hps">I</span> <span class="hps">see</span> <span class="hps">the</span> <span class="hps">difference in</span> <span class="hps">milliseconds</span> <span class="hps">that were generated</span> <span class="hps">in each</span> <span class="hps">server</span><span>.</span> <span class="hps">I need</span> <span class="hps">that times</span> <span class="hps">are exact</span><span>,</span> <span class="hps">since we have a</span> <span class="hps">procurement system</span> <span class="hps">for</span> <span class="hps">auction, which</span> <span class="hps">requires</span> <span class="hps">the milliseconds</span><span>,</span> <span class="hps">and</span> <span class="hps">that can</span> <span class="hps">make a difference</span> <span class="hps">to</span> <span class="hps">any bidder</span> <span class="hps">wins the bid</span><span class="">.</span></span><br>
<span id="result_box" class="" lang="en"><span class="hps">the truth</span> <span class="hps">is that it's</span> <span class="hps">random</span><span class="">, I went back</span> <span class="hps">to try</span> <span class="hps">and</span> <span class="hps">generate</span> <span class="hps">some logs</span> <span class="hps">me</span> <span class="hps">equal,</span> <span class="hps">and</span> <span class="hps">others have</span> <span class="hps">differences</span> <span class="hps">in milliseconds</span></span><br>
<br>CREATE TABLE test<br>(<br> id bigserial NOT NULL,<br> namecharacter varying(200),<br> alta timestamp without time zone DEFAULT now(),<br> mod timestamp with time zone DEFAULT now()<br>)<br>WITH (<br> OIDS=FALSE<br>
);<br><br> insert into test(name) values('first test');<br><br><br>server 1 : select * from prueba;<br> id | nombre | tiempo | alta | mod<br>----+------------------------------+---------------------+----------------------------+-------------------------------<br>
1 | diego | 2012-09-04 14:23:45 | 2012-09-04 14:25:33<span style="color:rgb(255,0,0)">.040833</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.631909-04</span><br> 2 | ayala | 2012-09-04 14:24:22 | 2012-09-04 14:25:33.<span style="color:rgb(255,0,0)">040833</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.631909-04</span><br>
3 | pepe | 2012-09-04 14:24:28 | 2012-09-04 14:25:33.<span style="color:rgb(255,0,0)">040833</span> | 2012-09-04 14:56<span style="color:rgb(255,0,0)">:57.631909-04</span><br> 4 | mujica | 2012-09-04 14:24:35 | 2012-09-04 14:25:33.<span style="color:rgb(255,0,0)">040833</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.631909-04</span><br>
5 | rolo | 2012-09-04 14:25:45 | 2012-09-04 14:25:45<span style="color:rgb(255,0,0)">.143966</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.631909-04</span><br> 6 | chespi | 2012-09-04 14:26:00 | 2012-09-04 14:25:59.735838 | 2012-09-04 14:56:57.631909-04<br>
7 | trifulcio rapado | 2012-09-04 14:26:26 | 2012-09-04 14:26:26.056678 | 2012-09-04 14:56:57.631909-04<br> 8 | eraldo | 2012-09-04 14:27:45 | 2012-09-04 14:27:45.082837 | 2012-09-04 14:56:57.631909-04<br>
9 | CORTINAS | 2012-09-04 14:53:07 | 2012-09-04 14:53:07.086145 | 2012-09-04 14:56:57.631909-04<br> 10 | PUERTAS | 2012-09-04 14:57:30 | 2012-09-04 14:57:30.109121 | 2012-09-04 14:57:30.109121-04<br>
<br> 11 | prueba de desarrollo | 2012-09-13 09:05:25 | 2012-09-13 09:05:<span style="color:rgb(0,204,204)">25.393988</span> | 2012-09-13 09:05:<span style="color:rgb(51,255,255)">25.393988-04</span><br> 12 | segunda prueba de desarrollo | 2012-09-13 09:06:24 | 2012-09-13 09:06:<span style="color:rgb(51,255,255)">24.083936</span> | 2012-09-13 09:06:<span style="color:rgb(51,255,255)">24.083936-04</span><br>
(12 rows)<br><br><br><br>server 2: select * from prueba;<br> id | nombre | tiempo | alta | mod<br>----+------------------------------+---------------------+----------------------------+-------------------------------<br>
1 | diego | 2012-09-04 14:23:45 | 2012-09-04 14:25:33.<span style="color:rgb(255,0,0)">042316</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.633128-04</span><br> 2 | ayala | 2012-09-04 14:24:22 | 2012-09-04 14:25:33.<span style="color:rgb(255,0,0)">042316</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.633128-04</span><br>
3 | pepe | 2012-09-04 14:24:28 | 2012-09-04 14:25:33<span style="color:rgb(255,0,0)">.042316</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.633128-04</span><br> 4 | mujica | 2012-09-04 14:24:35 | 2012-09-04 14:25:33.<span style="color:rgb(255,0,0)">042316</span> | 2012-09-04 14:56:<span style="color:rgb(255,0,0)">57.633128-04</span><br>
5 | rolo | 2012-09-04 14:25:45 | 2012-09-04 14:25:45.144954 | 2012-09-04 14:56:57.633128-04<br> 6 | chespi | 2012-09-04 14:26:00 | 2012-09-04 14:25:59.736717 | 2012-09-04 14:56:57.633128-04<br>
7 | trifulcio rapado | 2012-09-04 14:26:26 | 2012-09-04 14:26:26.057284 | 2012-09-04 14:56:57.633128-04<br> 8 | eraldo | 2012-09-04 14:27:45 | 2012-09-04 14:27:45.083635 | 2012-09-04 14:56:57.633128-04<br>
9 | CORTINAS | 2012-09-04 14:53:07 | 2012-09-04 14:53:07.087332 | 2012-09-04 14:56:57.633128-04<br> 10 | PUERTAS | 2012-09-04 14:57:30 | 2012-09-04 14:57:30.110247 | 2012-09-04 14:57:30.110247-04<br>
<br> 11 | prueba de desarrollo | 2012-09-13 09:05:25 | 2012-09-13 09:05:<span style="color:rgb(51,255,255)">25.393988</span> | 2012-09-13 09:05:<span style="color:rgb(51,255,255)">25.393988-04</span><br> 12 | segunda prueba de desarrollo | 2012-09-13 09:06:24 | 2012-09-13 09:06:<span style="color:rgb(51,255,255)">24.083936</span> | 2012-09-13 09:06:<span style="color:rgb(51,255,255)">24.083936-04</span><br>
(12 rows)<br><br><br><br><br><span id="result_box" class="" lang="en"> <span class="hps">lazaro</span> <span class="hps">therefore</span> <span class="hps">seen,</span> <span class="hps">the</span> <span class="hps">watchdog</span> <span class="hps">does</span> <span class="hps">almost the same as</span> <span class="hps">the</span> <span class="hps">hearbeat</span><span>, just</span> <span class="hps">as</span> <span class="hps">enbebido</span> <span class="hps">say</span> <span class="hps">already</span> <span class="hps">in the nucleus</span> <span class="hps">of</span> <span class="hps">pgPool</span><span>-II</span><span>, also,</span> <span class="hps">it</span> <span class="hps">proves</span><br>
<br> <span class="hps">thanks for the help</span></span><br><br><br><br><br><br><br><br><br><br><br><br><div class="gmail_quote">2012/9/12 Lazáro Rubén García Martínez <span dir="ltr"><<a href="mailto:lgarciam@vnz.uci.cu" target="_blank">lgarciam@vnz.uci.cu</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The core of pgpool-II 3.2 has a new functionality developed for the high availability of pgpool, it is called watchdog. Maybe you could use it instead of heartbeat. This is not the case of the problem, this is only one recomendation.<br>
<br>
Regards.<br>
________________________________________<br>
From: <a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a> [<a href="mailto:pgpool-general-bounces@pgpool.net">pgpool-general-bounces@pgpool.net</a>] On Behalf Of Diego Ayala [<a href="mailto:netdiego81@gmail.com">netdiego81@gmail.com</a>]<br>
Sent: Wednesday, September 12, 2012 5:18 PM<br>
To: Tatsuo Ishii<br>
Cc: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 989] Re: Fwd: Timestamp and pgpool-II 3.2<br>
<div class="im"><br>
this is my config file. forget to mention, I'm also using heartbeat, high availability for pgPool-II<br>
<br>
</div>2012/9/12 Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a><mailto:<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>>><br>
<div class="im">> good afternoon, I have a question, if you could get me out of doubt, to have<br>
> a timestamp() without time zone NOT NULL DEFAULT now (), to replicate,<br>
> there differences<br>
> in thousandths between each server. That is a problem or pgPool-II, there<br>
> is a solution to not happen? I'm using version 3.2 on pgPool REL6-II and<br>
> PostgreSQL 9.1<br>
><br>
> thanks for the help<br>
><br>
> eg<br>
> Server 1 = 2012-09-04 14:57:30.109121-04<br>
> Server 2 = 2012-09-04 14:57:30.110247-04<br>
<br>
Please show us pgpool.conf.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
<br>
</div>________________________________<br>
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!<br>
<a href="http://www.antiterroristas.cu" target="_blank">http://www.antiterroristas.cu</a><br>
<a href="http://justiciaparaloscinco.wordpress.com" target="_blank">http://justiciaparaloscinco.wordpress.com</a><br>
<br>
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!<br>
<a href="http://www.antiterroristas.cu" target="_blank">http://www.antiterroristas.cu</a><br>
<a href="http://justiciaparaloscinco.wordpress.com" target="_blank">http://justiciaparaloscinco.wordpress.com</a><br>
</blockquote></div><br>