Hi all,
I have a Postgresql 9.2 instance running on a CentOS6.3 box.Yesterday i
setup a hot standby by using pgbasebackup. Today i got the below alert
from standby box :
[1] (from line 412,723)
2013-04-24 23:07:18 UTC [13445]: [6-1] user= db= host= PANIC:
_bt_restore_page: cannot add item to pag
On Wed, 24 Apr 2013 14:01:13 +0100
Simon Riggs wrote:
[How to ensure query on hot-standby is not canceled by a
vacuum cleanup on the master.]
>> do I need to use UPDATE or INSERT to ensure that a vacuum cleanup
>> isn't applied until the transaction is finished?
> SELECT is sufficient
Great!
On 24 April 2013 12:42, David F. Skoll wrote:
> I ran a query on a hot-standby (PostgreSQL 9.1) and it was canceled as
> per the documentation about vacuum cleanups on the master.
>
> Second time testing, I started a transaction on the master (with
> BEGIN) but my query on the hot-standby was sti
Hi,
I ran a query on a hot-standby (PostgreSQL 9.1) and it was canceled as
per the documentation about vacuum cleanups on the master.
Second time testing, I started a transaction on the master (with
BEGIN) but my query on the hot-standby was still canceled.
Is that because a transaction doesn't
