Eduardo Morras yahoo.es> writes:
>
> On Wed, 06 Mar 2013 19:09:43 -0700
> CS DBA consistentstate.com> wrote:
> > We actually are in HOT standby mode, and it is working. However we are
> > also migrating a second db from an older (8.4) server into this master
> > so we did a dump (using the 9.2
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
On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <
david.gu...@europecamions-interactive.com> wrote:
> Mister,
>
> Thank you for your answer. I had in mind that this line was for the
> initial start of the standby; should I just comment it before promoting the
> standby, or is this line useless for t
On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <
david.gu...@europecamions-interactive.com> wrote:
> Thank you for your answer. I had in mind that this line was for the
> initial start of the standby; should I just comment it before promoting the
> standby, or is this line useless for the day-to-day
Mister,
Thank you for your answer. I had in mind that this line was for the
initial start of the standby; should I just comment it before promoting
the standby, or is this line useless for the day-to-day standby service?
Thank you in advance.
Regards.
Le 02/04/2013 16:47, Douglas J Hunley a écr
On Tue, Apr 2, 2013 at 10:29 AM, David Guyot (English) <
david.gu...@europecamions-interactive.com> wrote:
> restore_command = 'rsync -av 192.168.0.80:/var/lib/postgresql/WAL/%f %p'
>
You're telling the recovery process to get the files off the (now dead)
master here...
--
Douglas J Hunley (do
On Wed, 06 Mar 2013 19:09:43 -0700
CS DBA wrote:
> We actually are in HOT standby mode, and it is working. However we are
> also migrating a second db from an older (8.4) server into this master
> so we did a dump (using the 9.2.2 pg_dump binary) from the 8.4 db and
> then restored it into our
On 3/6/13 7:02 PM, Prashanth Ranjalkar wrote:
While setting up Hot Standby, it's not a method to copy the primary
database using dump and restore it on standby using restore command
as it's a logical backup. I doubt your WAL archiving is enabled and
files are copied to archive destination that
While setting up Hot Standby, it's not a method to copy the primary
database using dump and restore it on standby using restore command as
it's a logical backup. I doubt your WAL archiving is enabled and files are
copied to archive destination that set in archive_command therefore keep
accumulati
Anyone have any thoughts on why this may be happening?
thanks,
- Brian F
On 03/01/2012 04:38 PM, Brian Fehrle wrote:
I just now ran the following query a few times after each other on the
hot standby:
select now(), * from pg_stat_bgwriter;
Here are the results:
now
I just now ran the following query a few times after each other on the
hot standby:
select now(), * from pg_stat_bgwriter;
Here are the results:
now | checkpoints_timed | checkpoints_req |
buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend
| bu
On Tue, Feb 28, 2012 at 10:53 PM, Brian Fehrle
wrote:
> I have two PostgreSQL 9.0.5 clusters, one is a master and the other is a hot
> standby via streaming replication. I'm monitoring some stats on each and I'm
> noticing something very odd. On the master, I get between 2 and 4 requested
> check
On Thu, Mar 1, 2012 at 12:14 AM, Brian Fehrle
wrote:
> I am taking periodic snapshots from the system view 'pg_stat_bgwriter' from
> both the master and the hot standby.
You mean that you observed that pg_stat_bgwriter.checkpoints_timed in
the standby was larger than that in the master? I ran pgb
I am taking periodic snapshots from the system view 'pg_stat_bgwriter'
from both the master and the hot standby.
- Brian F
On 02/28/2012 09:22 PM, Fujii Masao wrote:
On Wed, Feb 29, 2012 at 7:53 AM, Brian Fehrle
wrote:
Hi all,
I have two PostgreSQL 9.0.5 clusters, one is a master and the o
On Wed, Feb 29, 2012 at 7:53 AM, Brian Fehrle
wrote:
> Hi all,
>
> I have two PostgreSQL 9.0.5 clusters, one is a master and the other is a hot
> standby via streaming replication. I'm monitoring some stats on each and I'm
> noticing something very odd. On the master, I get between 2 and 4 request
On Mar 19, 2011, at 2:55 AM, John P Weatherman wrote:
> I have recently upgraded to Postgres9 and am building a hot standby for
> reporting. Unfortunately, my end users are providing requirements for
> 1) real time data replication (which the hot standby does) and 2) the
> ability to create temp
On Sun, Mar 20, 2011 at 10:38 PM, jonathan ferguson wrote:
> hi.
>
> On Mar 20, 2011, at 9:05 PM, Jaime Casanova wrote:
>
>> On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova
>> wrote:
>>> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
>>> wrote:
Has anyone run into this already and have
hi.
On Mar 20, 2011, at 9:05 PM, Jaime Casanova wrote:
> On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova wrote:
>> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
>> wrote:
>>> Has anyone run into this already and have an idea for a work around? I
>>> am primarily an Oracle guy and in that
On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova wrote:
> On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
> wrote:
>>
>> Has anyone run into this already and have an idea for a work around? I
>> am primarily an Oracle guy and in that environment I would set up a
>> second DB with database link
On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman
wrote:
>
> Has anyone run into this already and have an idea for a work around? I
> am primarily an Oracle guy and in that environment I would set up a
> second DB with database links to the hot standby,
you can use the contrib module dblink for
hi.
On Mar 18, 2011, at 5:25 PM, John P Weatherman wrote:
> All,
>
> I have recently upgraded to Postgres9 and am building a hot standby for
> reporting. Unfortunately, my end users are providing requirements for
> 1) real time data replication (which the hot standby does) and 2) the
> ability
hi,
it's fine now - the problem was WinRAR which reported that he can't
access some files and I ignored that - big mistake :)
Thanks for help - working fine now.
Michal
Le 29/09/2010 10:16, Michal Glowacki a écrit :
Fujii, I believe I should follow this (from documentation):
***
W dniu 2010-09-29 10:56, Guillaume Lelarge pisze:
Using rar on the data folder should work if you don't have tablespaces.
If you have some, add them to your data rar archive.
And instead of overwriting the data folder on the slave, wipe out your
old data folder and recreate it by restoring you
Le 29/09/2010 10:16, Michal Glowacki a écrit :
> Fujii, I believe I should follow this (from documentation):
>
>
>
> The procedure for making a base backup is relatively simple:
>
> 1.
>
> Ensure that WAL archiving is enabled and working.
>
> 2.
>
> Con
Fujii, I believe I should follow this (from documentation):
The procedure for making a base backup is relatively simple:
1.
Ensure that WAL archiving is enabled and working.
2.
Connect to the database as a superuser, and issue the command
SELECT
On Wed, Sep 29, 2010 at 4:52 PM, Michal Glowacki wrote:
>
> I try to do it on two machines, my computer and local server. My system is
> Windows 7 64bit, standby is XP professional sp2 64bit. Both machines run
> postgres 9.0.0. I tried dump, dump_all, pgadmin III's backup and restore -
> nothing w
On Wed, 2009-07-01 at 16:11 -0400, Mark Steben wrote:
> Great to see the announcement of the 8.4 rollout. Quick question - is hot
> standby available or still being worked on?
It is not in 8.4. The hope is to have it for 8.5.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
""Nigel Bishop"" <[EMAIL PROTECTED]> wrote
> I'm investigating the use of a second server with a backup copy of the
> live DB set up and in recovery mode.
You may want to check out the Slony I project:
http://gborg.postgresql.org/index.php
BTW, if you want "cold" standby (means if one server c
29 matches
Mail list logo
