On Fri, Aug 9, 2013 at 2:17 PM, ascot.m...@gmail.com
wrote:
> Is there a way to query the master (it is up and running) about the actual
> commit sequence by transaction IDs?
The information is within the clogs, but nothing comes into my mind as
to inspect from an admin point of view the clog
hi
>> 16:47:12
SELECT pg_start_backup('hot_backup');
"tar cfP" the PG "data" folder
SELECT pg_stop_backup();
regards
On 9 Aug 2013, at 9:55 PM, Albe Laurenz wrote:
> ascot.m...@gmail.com wrote:
>> I am trying another way to test PITR: by recovery_target_time.
>>
>> The test machine has the sa
ascot.m...@gmail.com wrote:
> I am trying another way to test PITR: by recovery_target_time.
>
> The test machine has the same PG version 9.2.4 and same O/S Ubuntu 12.04 64
> bit.All archived WAL
> files are shipped and saved in /var/pgsql/data/archive, the latest time stamp
> of them is "20
On 9 Aug 2013, at 7:09 PM, Luca Ferrari wrote:
> Uhm...I guess the problem is not about the txid being included or not:
> the recovery target was 75634 and the transaction 75666 appeared, so
> the problem seems to be an out-of-order commit of the transactions. In
> such case making the inclusive
On Fri, Aug 9, 2013 at 12:40 PM, wd wrote:
> Try add these settings,
>
> pause_at_recovery_target=true
Be warned that this would require a manual completion of the recovery
and requires hot_standby that is not specified in the original post.
> recovery_target_inclusive=false
>
Uhm...I guess the
Try add these settings,
pause_at_recovery_target=true
recovery_target_inclusive=false
On Fri, Aug 9, 2013 at 4:09 PM, ascot.m...@gmail.com
wrote:
> Hi,
>
> I am trying PITR in a test machine (same PG version 9.2.4 same O/S Ubuntu
> 12.04 64 bit). All archived WAL files are shipped and saved i
On Fri, Aug 9, 2013 at 10:09 AM, ascot.m...@gmail.com
wrote:
> Hi,
>
> I am trying PITR in a test machine (same PG version 9.2.4 same O/S Ubuntu
> 12.04 64 bit). All archived WAL files are shipped and saved in
> /var/pgsql/data/archive, the latest transaction txid of them is 75666. I
> want t
Hello,
On Fri, 9 Aug 2013 16:09:49 +0800, "ascot.m...@gmail.com"
wrote:
postgres=# select txid_current();
txid_current
--
75666
(1 row)
Can you please advise?
WAL contains REDO log information, which means only COMMITTED
transactions will be recovered. Sequentiality o
