[GENERAL] Hot Standby syntax error

Is the below syntax correct in the recovery.conf file: restore_command = 'copy "D:\\apps\postgres\pg_archivelog\\%f" "%p"' archive_cleanup_command = 'pg_archivecleanup "D:\\apps\\postgres\\pg_archivelog\\" %r' And the lines is corrent in portgresql.conf file: archive_command = 'copy "%p" "

[GENERAL] Hot standby failing with page # of relation # is uninitialized

Debian Stretch AMD-64, Postgresql 9.6.3 Streaming data from live server and we see these messages on the hot standby server. 2017-09-06 14:42:09 BST    11548 WARNING:  page 30558 of relation base/2497261/2504373 is uninitialized 2017-09-06 14:42:09 BST    11548 CONTEXT:  xlog redo at 44/5E0B7

[GENERAL] Hot standby failing with page # of relation # is unintitialized

Streaming data from live server and we see these messages on the hot standby server. 2017-09-06 14:42:09 BST    11548 WARNING:  page 30558 of relation base/2497261/2504373 is uninitialized 2017-09-06 14:42:09 BST    11548 CONTEXT:  xlog redo at 44/5E0B7CA8 for Heap2/VISIBLE: cutoff xid 2918231

Re: [GENERAL] hot standby questions

Thank you guys I think I kinda shot myself in the foot. I took a look at the wiki and I put in -x and so far so good — Armand > On Aug 3, 2017, at 11:03 PM, Lucas Possamai wrote: > > > > 2017-08-04 5:58 GMT+12:00 Jeff Janes >: > On Wed, Aug 2, 2017 at 8:19 PM

Re: [GENERAL] hot standby questions

2017-08-04 5:58 GMT+12:00 Jeff Janes : > On Wed, Aug 2, 2017 at 8:19 PM, armand pirvu > wrote: > >> >> Hi >> >> Just trying to put together the hot_standby setup >> All docs I read are pointing to use as prefered method to use >> pg_basebackup to set the base >> So far so good >> But >> >> psql p

Re: [GENERAL] hot standby questions

On Wed, Aug 2, 2017 at 8:19 PM, armand pirvu wrote: > > Hi > > Just trying to put together the hot_standby setup > All docs I read are pointing to use as prefered method to use > pg_basebackup to set the base > So far so good > But > > psql postgres -c "select pg_start_backup('backup')" > pg_base

[GENERAL] hot standby questions

Hi Just trying to put together the hot_standby setup All docs I read are pointing to use as prefered method to use pg_basebackup to set the base So far so good But psql postgres -c "select pg_start_backup('backup')" pg_basebackup -D /var/lib/pgsql/sample -Ft -z -P psql postgres -c "select pg

Re: [GENERAL] Hot standby and xlog on a ramdisk

On 2/4/16 9:46 AM, Tore Halvorsen wrote: > On Thu, Feb 4, 2016 at 3:30 PM, Scott R Mead > wrote: > >> > Can a hot standby run correctly with the xlog-files on a >> ramdisk? >> > >> >> Yes, but, if you lose any, you'll need to rebuild the

Re: [GENERAL] Hot standby and xlog on a ramdisk

On Thu, Feb 4, 2016 at 3:30 PM, Scott R Mead wrote: > > Can a hot standby run correctly with the xlog-files on a ramdisk? >> > >> >> Yes, but, if you lose any, you'll need to rebuild the standby. >> >> > Even if the master and archive contain all the wal files? > > If you have the file somewhere,

Re: [GENERAL] Hot standby and xlog on a ramdisk

On 02/04/2016 09:25 AM, Tore Halvorsen wrote: > > On 02/04/2016 09:15 AM, Tore Halvorsen wrote: > > Can a hot standby run correctly with the xlog-files on a ramdisk? > > > > Yes, but, if you lose any, you'll need to rebuild the standby. > > > Even if the master and archive contain

Re: [GENERAL] Hot standby and xlog on a ramdisk

> > On 02/04/2016 09:15 AM, Tore Halvorsen wrote: > > Can a hot standby run correctly with the xlog-files on a ramdisk? > > > > Yes, but, if you lose any, you'll need to rebuild the standby. > > Even if the master and archive contain all the wal files? -- Eld på åren og sol på eng gjer mannen fe

Re: [GENERAL] Hot standby and xlog on a ramdisk

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 02/04/2016 09:15 AM, Tore Halvorsen wrote: > Hi, > > Can a hot standby run correctly with the xlog-files on a ramdisk? > Yes, but, if you lose any, you'll need to rebuild the standby. > -- Eld på åren og sol på eng gjer mannen fegen og fjåg

[GENERAL] Hot standby and xlog on a ramdisk

Hi, Can a hot standby run correctly with the xlog-files on a ramdisk? -- Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul] Tore Halvorsen || +052 0553034554

Re: [GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

On 04/13/2015 01:05 PM, Guillaume Lelarge wrote: Le 12 avr. 2015 16:50, "Ilya Ashchepkov" mailto:koc...@gmail.com>> a écrit : > > restore_command = '/usr/lib/postgresql/9.3/bin/pg_standby -t /tmp/pgsql.trigger.5432 /media/psqlbak/101/wals/main/ %f %p %r' > Don't use pg_standby if you want

Re: [GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

Le 12 avr. 2015 16:50, "Ilya Ashchepkov" a écrit : > > Hello. > > I'm setting up hot standby slave. > It recovers from wal archive files, but I can't connect to it: > $ psql > psql: FATAL: the database system is starting up > > On master: > # select name,setting from pg_settings where name like '

Re: [GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database system is starting up On master: # select name,setting from pg_settings where name like 'wal_level'; name

[GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database system is starting up On master: # select name,setting from pg_settings where name like 'wal_level'; name| setting ---+- wal_leve

Re: [GENERAL] HOT standby with ONLY WAL shipping?

On Thu, Jun 12, 2014 at 1:01 PM, CS_DBA wrote: > Hi All; > > We would like to setup a hot standby server with a forced delay. > Is it possible to setup a hot standby based ONLY on WAL shipping and NOT > use streaming replication? > > Thanks in advance > > > -- > Sent via pgsql-general mailing lis

Re: [GENERAL] HOT standby with ONLY WAL shipping?

On Fri, Jun 13, 2014 at 1:01 AM, CS_DBA wrote: > Is it possible to setup a hot standby based ONLY on WAL shipping and NOT > use streaming replication? If I am not wrong then what you are looking for is Archive Shipping​. Any specific reason why you want to do that? Anyways, you can use pg_rece

Re: [GENERAL] HOT standby with ONLY WAL shipping?

On 06/12/14 10:01, CS_DBA wrote: > > We would like to setup a hot standby server with a forced delay. > Is it possible to setup a hot standby based ONLY on WAL shipping and NOT > use streaming replication? Yes it is. Though, I assume you mean 'forced max sync period' as opposed to 'forced delay

[GENERAL] HOT standby with ONLY WAL shipping?

Hi All; We would like to setup a hot standby server with a forced delay. Is it possible to setup a hot standby based ONLY on WAL shipping and NOT use streaming replication? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

[GENERAL] Hot standby 9.2.1 PANIC: WAL contains references to invalid pages

Hi Team, For last 2 days we are facing issue with replication. WARNING: page 21 of relation base/1193555/19384612 does not exist CONTEXT: xlog redo insert: rel 1663/1193555/19384612; tid 21/1 PANIC: WAL contains references to invalid pages CONTEXT: xlog redo insert: rel 1663/1193555/19384612;

Re: [GENERAL] hot standby data folder bigger than primary

hi, Andy, Thanks. Right we are using 9.2.4 but plan to upgrade soon. I read 9.3.2 release notes and it is fixed specifically for this. best, Ying -- View this message in context: http://postgresql.1045698.n5.nabble.com/hot-standby-data-folder-bigger-than-primary-tp5800402p5800545.html Sent fr

Re: [GENERAL] hot standby data folder bigger than primary

Hi, On 2014-04-17 06:28:52 -0700, yhe wrote: > We are using streaming hot standby, no wal shipping. > > I checked and base and pg_xlog. both are fine. > > The extra space is used by /pg_multixact/members(about 5G) and > /pg_multixact/offsets(about 1.5G) > > The doc said that pg_multixact cont

Re: [GENERAL] hot standby data folder bigger than primary

hi, Andy, We are using streaming hot standby, no wal shipping. I checked and base and pg_xlog. both are fine. The extra space is used by /pg_multixact/members(about 5G) and /pg_multixact/offsets(about 1.5G) The doc said that pg_multixact contains multitransaction data used for shared row lock

Re: [GENERAL] hot standby data folder bigger than primary

On 4/16/2014 2:52 PM, yhe wrote: hi, I have a primary/standby setup and I noticed after many days running, the standby's data folder is growing bigger than the primary, and it keeps growing bigger, now it is almost 4 times the size, eg, primary data folder is 2G, standby is 8G. Does anyone know

[GENERAL] hot standby data folder bigger than primary

hi, I have a primary/standby setup and I noticed after many days running, the standby's data folder is growing bigger than the primary, and it keeps growing bigger, now it is almost 4 times the size, eg, primary data folder is 2G, standby is 8G. Does anyone know why it is so? best, Ying --

Re: [GENERAL] HOT standby on windows not working

On Fri, Apr 11, 2014 at 8:15 AM, CS_DBA wrote: > Hi All; > > We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2 > > We do this: > I've also tried this approach: > > > 1) Master postgresql.conf file > Modify the following settings: > listen_address = '*' > wal_level = hot_stan

[GENERAL] HOT standby on windows not working

Hi All; We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2 We do this: 1) stop both servers 2) copy the master data directory to the slave 3) edit the master postgresql.conf file as follows: Modify the following listen_address = ‘*’ wal_level = hot_standby max_wal_sender

Re: [GENERAL] Hot standby read slaves exceed max delay on WAL segment. Replication lag.

> > Yes, we do see statements being canceled from time to time, just not when > we experience a lag situation with WALs not being applied. Is it just > entirely possible that there is too much work for one of the slaves to do > (hence the degraded query throughput we see) that it is unable to apply

Re: [GENERAL] Hot standby read slaves exceed max delay on WAL segment. Replication lag.

On Wed, Mar 19, 2014 at 11:31 PM, Venkata Balaji Nagothi wrote: > On Thu, Mar 20, 2014 at 8:19 AM, Shaun Duncan wrote: > >> >> On Mar 19, 2014 5:08 PM, "Venkata Balaji Nagothi" >> wrote: >> > >> > >> > On Thu, Mar 20, 2014 at 4:12 AM, Shaun Duncan >> wrote: >> > >> >> This is on a production 9.0

Re: [GENERAL] Hot standby read slaves exceed max delay on WAL segment. Replication lag.

On Thu, Mar 20, 2014 at 8:19 AM, Shaun Duncan wrote: > > On Mar 19, 2014 5:08 PM, "Venkata Balaji Nagothi" > wrote: > > > > > > On Thu, Mar 20, 2014 at 4:12 AM, Shaun Duncan > wrote: > > > >> This is on a production 9.0.15 install with 1 master, 5 hot standby > read only slaves. > >> > >> We've

Re: [GENERAL] Hot standby read slaves exceed max delay on WAL segment. Replication lag.

On Thu, Mar 20, 2014 at 4:12 AM, Shaun Duncan wrote: This is on a production 9.0.15 install with 1 master, 5 hot standby read > only slaves. > > We've been trying to look into a situation where we're seeing that hot > standby read slaves are receiving WAL segments, but are exceeding > max_standby_

[GENERAL] Hot standby read slaves exceed max delay on WAL segment. Replication lag.

This is on a production 9.0.15 install with 1 master, 5 hot standby read only slaves. We've been trying to look into a situation where we're seeing that hot standby read slaves are receiving WAL segments, but are exceeding max_standby_archive_delay (60s) and max_standby_streaming_delay (60s) and n

Re: [GENERAL] HOT Standby & SSL

On 02/02/2014 09:14 AM, CS DBA wrote: All; How do I force a standby to connect to the master via ssl only? Use hostssl in the pg_hba.conf file: http://www.postgresql.org/docs/9.3/interactive/auth-pg-hba-conf.html hostssl This record matches connection attempts made using TCP/IP, but onl

[GENERAL] HOT Standby & SSL

All; How do I force a standby to connect to the master via ssl only? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Hot standby & SR - log shipping required?

On 14/09/2013 04:31, Jov wrote: > T > he log shipping is useful when SR slave can not catch up the master and > hungry enough to cause replication stop work.For example,when you want > to stop the slave for a long time or do a large copy from,the > wal_keep_segments on master reached，SR slave may n

Re: [GENERAL] Hot standby & SR - log shipping required?

T he log shipping is useful when SR slave can not catch up the master and hungry enough to cause replication stop work.For example,when you want to stop the slave for a long time or do a large copy from,the wal_keep_segments on master reached，SR slave may not catch up the master.If log shipping is

Re: [GENERAL] Hot standby & SR - log shipping required?

On Sep 13, 2013, at 3:51 PM, Raymond O'Donnell wrote: > [1] and one of the wiki > articles [2] seem to indicate that you need to set up log-shipping as > well as SR, whereas one of the wiki articles [2] indicates that > log-shipping isn't required. I've followed [3] and it seems to work fine > in

[GENERAL] Hot standby & SR - log shipping required?

Hello all, I'm tackling host standby & streaming replication for the first time, in a small set-up with just two computers (one master, one standby) and an extremely light load (at its busiest, one transaction every couple of minutes). Both systems are running PG 9.1 on Debian Wheezy from apt.post

Re: [GENERAL] Hot Standby and Foreign Tables

Brilliant. Thanks Michael. That looks great. On Thu, Jul 18, 2013 at 11:54 PM, Michael Paquier wrote: > > > On Thu, Jul 18, 2013 at 11:15 PM, Tim Kane wrote: > > Hi all, > > > > I'm currently playing a few ideas out in my head and wanted to see if > this > > was feasible. There may be some

Re: [GENERAL] Hot Standby and Foreign Tables

On Thu, Jul 18, 2013 at 11:15 PM, Tim Kane wrote: > Hi all, > > I'm currently playing a few ideas out in my head and wanted to see if this > was feasible. There may be some limitation I am not aware of. > > I would like to create a foreign table into a hot standby instance using > FDW's. I apprec

[GENERAL] Hot Standby and Foreign Tables

Hi all, I'm currently playing a few ideas out in my head and wanted to see if this was feasible. There may be some limitation I am not aware of. I would like to create a foreign table into a hot standby instance using FDW's. I appreciate that the hot standby is always going to be read-only, and

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

Hi, >> Also, we can see that 9.2.3 has been released now and has a number of fixes >> relating to WAL replay, so we have decided to try again using that. >> We will scrub the standby and make a fresh copy using pg_basebackup. If that >> doesn't work then we may try using rsync instead. I am pl

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

ubject: Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages On Thu, Feb 7, 2013 at 7:39 AM, amutu wrote: > maybe pg_basebackup can`t handle such big database.try > rsync,pg_start_backup,rsync,pg_stop_backup,it always works fine for > us.our instance is about 2TB

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

On Thu, Feb 7, 2013 at 7:39 AM, amutu wrote: > maybe pg_basebackup can`t handle such big database.try > rsync,pg_start_backup,rsync,pg_stop_backup,it always works fine for us.our > instance is about 2TB and we use pg9.1.x. It really should handle that without problem, but sure, it might be worth

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

patch, however the error > recurred exactly as before. > > Regards // Mike > > > -Original Message- > From: Hari Babu [mailto:haribabu.ko...@huawei.com] > Sent: Tuesday, 5 February 2013 10:07 PM > To: Michael Harris; pgsql-general@postgresql.org > Subject:

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

Subject: RE: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages On Tuesday, February 05, 2013 6:05 AM Michael Harris wrote: >Any ideas for a next troubleshooting step? [BUG?] lag of minRecoveryPont in archive recovery, which has fixed recently. Please check the following l

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

On Tuesday, February 05, 2013 6:05 AM Michael Harris wrote: >Any ideas for a next troubleshooting step? [BUG?] lag of minRecoveryPont in archive recovery, which has fixed recently. Please check the following link for more details. It may help. http://www.postgresql.org/message-id/20121206.130458.

[GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

Hi All, We are having a thorny problem I'm hoping someone will be able to help with. We have a pair of machines set up as an active / hot SB pair. The database they contain is quite large - approx. 9TB. They were working fine on 9.1, and we recently upgraded the active DB to 9.2.1. After upgra

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Tue, Nov 6, 2012 at 5:45 AM, Kevin Grittner wrote: > Darren Duncan wrote: > > Ian Harding wrote: > > >> It says everything is happy as normal... > >> > >> 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48 > > > > What does this log line mean? Is that "happy as normal"? >

Re: [GENERAL] Hot Standby Not So Hot Anymore

Darren Duncan wrote: > Ian Harding wrote: >> It says everything is happy as normal... >> >> 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48 > > What does this log line mean? Is that "happy as normal"? Note that the message level is LOG, not WARNING or ERROR or anything

Re: [GENERAL] Hot Standby Not So Hot Anymore

Ian Harding wrote: On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote: It says everything is happy as normal... 2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48 What does this log line mean? Is that "happy as normal"? -- Darren Duncan -- Sent via pgsql-general

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 8:31 PM, Ian Harding wrote: > > > > On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman wrote: >> >> On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote: >> > >> > >> > >> > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman >> > wrote: >> >> >> >> On Mon, Nov 5, 2012 at 7:49 PM

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman wrote: > On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote: > > > > > > > > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman > wrote: > >> > >> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding > wrote: > >> > > >> > > >> > On Mon, Nov 5, 2012 at 7:46

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote: > > > > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman wrote: >> >> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote: >> > >> > >> > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman >> > wrote: >> >> >> >> On Mon, Nov 5, 2012 at 7:40 PM, Ian

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman wrote: > On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote: > > > > > > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman > wrote: > >> > >> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding > wrote: > >> > I had a 9.0.8 hot standby setup, one master,

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote: > > > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote: >> >> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote: >> > I had a 9.0.8 hot standby setup, one master, two slaves, working great. >> > Then, I tried to re-initialize by making a b

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote: > On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote: > > I had a 9.0.8 hot standby setup, one master, two slaves, working great. > > Then, I tried to re-initialize by making a base backup, the way I've > done it > > many times before, but f

Re: [GENERAL] Hot Standby Not So Hot Anymore

On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote: > I had a 9.0.8 hot standby setup, one master, two slaves, working great. > Then, I tried to re-initialize by making a base backup, the way I've done it > many times before, but for some reason I can't get the standby to accept > connections. I c

[GENERAL] Hot Standby Not So Hot Anymore

I had a 9.0.8 hot standby setup, one master, two slaves, working great. Then, I tried to re-initialize by making a base backup, the way I've done it many times before, but for some reason I can't get the standby to accept connections. I copied the postgresql.conf and recorvery.conf out of the way,

Re: [GENERAL] Hot standby streaming replication doesn't work

I am using 9.1. Apparently it's working now, it took a couple of restarts but it seems to be going. Thanks. On Mon, Jun 25, 2012 at 12:57 PM, Michael Nolan wrote: > > > On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun wrote: >> >> I am following the instructions on the wiki >> >> https://wiki.postgr

Re: [GENERAL] Hot standby streaming replication doesn't work

On Sun, Jun 24, 2012 at 1:57 AM, Tim Uckun wrote: > I am following the instructions on the wiki > > https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication > using the "10 minute" version of the setup. > > What version of postg

[GENERAL] Hot standby streaming replication doesn't work

I am following the instructions on the wiki https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication using the "10 minute" version of the setup. On the master I have postgresql.conf wal_level = hot_standby max_wal_senders = 3 c

Re: [GENERAL] Hot standby off of hot standby?

On Mon, Jan 30, 2012 at 4:36 AM, Igor Schtein wrote: > Is it possible to use a standby instance as a master/primary for another > standby in Postgres 9.0?  In other words, does PG 9.0 supports cascading > standby configuration? No, but 9.2 will support that feature, known as cascading replicatio

Re: [GENERAL] Hot standby won't start

On Mon, Oct 10, 2011 at 11:30 AM, Brandon Phelps wrote: > Hello all, > > I have written a script which stops postgres on my standby server, executes > pg_start_backup on the master, rsync's the data directory and tablespaces > over to the standby, executes pg_stop_backup on the master, and attempt

[GENERAL] Hot standby won't start

Hello all, I have written a script which stops postgres on my standby server, executes pg_start_backup on the master, rsync's the data directory and tablespaces over to the standby, executes pg_stop_backup on the master, and attempts to then start postgresql on the standby. My problem is the

[GENERAL] hot standby waiting for invalid wal file

Dear List Since 9.0 comes out, I had been successfully using wal file shipping readonly hotstandby feature in pg. I am currently trying to reestablish a readonly slave after master node failure. The newly established master server is working properly. I have verified that WAL file shipping is

Re: [GENERAL] Hot Standby Lag Calculation

>From: pgsql-general-ow...@postgresql.org On Behalf Of Sam Nelson >Sent: Wednesday, August 03, 2011 11:03 AM >To: pgsql-general >Subject: [GENERAL] Hot Standby Lag Calculation >Hi, List, >We're trying to calculate the amount of time that a Hot Standby slave is >lagg

[GENERAL] Hot Standby Lag Calculation

Hi, List, We're trying to calculate the amount of time that a Hot Standby slave is lagging behind its master, and our results look wrong (average of 7 seconds, with some over 1 minute), so we were thinking that we're probably calculating it wrong. We're currently just using the timestamps from ls

Re: [GENERAL] Hot standby on Windows

On 14/07/2011 10:05 PM, stefanu wrote: I thought that the command line would be built properly (I mean the %r would be replaced by the caller), but for some reason it is not happening. I don't use hot standby on Windows, but since there's been no other response to this I'll try to have a loo

[GENERAL] Hot standby on Windows

Hello all, I am having a little trouble with a hot standby configuration on Windows, and I was hoping I could find an answer here. Everything works fine (both machines run just fine, and the hot standby works like a charm), except for one problem. The pg_archivecleanup refuses to run; it seems li

[GENERAL] Hot standby on Windows

Hello all, I am having a little trouble with a hot standby configuration on Windows, and I was hoping I could find an answer here. Everything works fine (both machines run just fine, and the hot standby works like a charm), except for one problem. The pg_archivecleanup refuses to run; it seems li

Re: [GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

On Sun, Feb 27, 2011 at 1:57 PM, Sean Laurent wrote: > Right. I read all of that. I guess I just assumed it was possible to create > a snapshot on the standby so that a longer running on the standby could > complete. In particular, I was really hoping to run database dumps against > the standby, n

Re: [GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

On 28/02/11 03:57, Sean Laurent wrote: > Right. I read all of that. I guess I just assumed it was possible to create > a snapshot on the standby so that a longer running on the standby could > complete. In particular, I was really hoping to run database dumps against > the standby, not the master.

Re: [GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

On Sonntag, 27. Februar 2011, Sean Laurent wrote: > In particular, I was really hoping to > run database dumps against the standby, not the master. One solution is to begin idle transactions on the master by using e.g. dblink from the standby to the master before you start pg_dump on the standb

Re: [GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

On Sunday, February 27, 2011 11:57:35 am Sean Laurent wrote: > On Sun, Feb 27, 2011 at 1:04 PM, Jens Wilke wrote: > > On Sonntag, 27. Februar 2011, Sean Laurent wrote: > > > Unfortunately, most queries against the hot standby fail. Worse > > > > > yet, pg_dump fails: > > ... > > > > > I'm not en

Re: [GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

On Sun, Feb 27, 2011 at 1:04 PM, Jens Wilke wrote: > On Sonntag, 27. Februar 2011, Sean Laurent wrote: > > > Unfortunately, most queries against the hot standby fail. Worse > > yet, pg_dump fails: > ... > > I'm not entirely certain I understand why I'm seeing this. Nor do > > I understand how to

Re: [GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

On Sonntag, 27. Februar 2011, Sean Laurent wrote: > Unfortunately, most queries against the hot standby fail. Worse > yet, pg_dump fails: ... > I'm not entirely certain I understand why I'm seeing this. Nor do > I understand how to fix or work around this. Any advice or > suggestions would be grea

[GENERAL] Hot Standby - ERROR: canceling statement due to conflict with recovery

I have a hot-standby instance setup using Postgres 9.0.1 with streaming replication against a 9.0.1 master. On the master, I have the following set in the postgresql.conf: checkpoint_segments = 3 checkpoint_timeout = 1min checkpoint_completion_target = 0.5 max_wal_senders = 3 wal_sender_delay = 20

Re: [GENERAL] Hot-Standby and sequences

OKay Tom, Thanks for this clarification

Re: [GENERAL] Hot-Standby and sequences

"Wouter D'Haeseleer" writes: > I have a question about sequences in combination with streaming > replication. > It seems something strange is happening with sequences which are > streamed to the slave. > When updating the sequence the last_value on the slave shifts with 32 > and halts at this val

[GENERAL] Hot-Standby and sequences

Hi All, I have a question about sequences in combination with streaming replication. It seems something strange is happening with sequences which are streamed to the slave. When updating the sequence the last_value on the slave shifts with 32 and halts at this value until the master increased the

[GENERAL] Hot-Standby and sequences

Hi All, I have a question about sequences in combination with streaming replication. It seems something strange is happening with sequences which are streamed to the slave. When updating the sequence the last_value on the slave shifts with 32 and halts at this value until the master increased the

Re: [GENERAL] Hot Standby pg_xlog problem

On Wed, Dec 15, 2010 at 7:24 AM, Michael Blake wrote: > I'm trying to set up a master/slave server, which initially worked > fine, but recently started failing with the following error: > > == > LOG:  database system was interrupted; last known up at [time] > LOG:  could not open file

Re: [GENERAL] Hot Standby pg_xlog problem

On Wed, 2010-12-15 at 09:24 +1100, Michael Blake wrote: > I'm trying to set up a master/slave server, which initially worked > fine, but recently started failing with the following error: > > == > LOG: database system was interrupted; last known up at [time] > LOG: could not open fil

[GENERAL] Hot Standby pg_xlog problem

I'm trying to set up a master/slave server, which initially worked fine, but recently started failing with the following error: == LOG: database system was interrupted; last known up at [time] LOG: could not open file "pg_xlog/0001002B" (log file 0, segment 43): No su

Re: [GENERAL] Hot standby usage issue

Hi , The 'problem' was remedied to certain extent by increasing max_standby_streaming_delay=30 # values in milliseconds I set it to 5 mins which is acceptable to our application. regds Rajesh Kumar Mallah. On Thu, Oct 7, 2010 at 9:55 AM, Rajesh Kumar Mallah wrote: > Dear List , > > We have

Re: [GENERAL] Hot standby usage issue

both servers are on same gigabit switch. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Hot standby usage issue

Dear List , We have setup primary/slave in HS & SR mode. We are diverting a part of read only queries to the slave. The problem is that we are intermittently getting errors ERROR: canceling statement due to conflict with recovery on slave. We know that the tables which are participating in th

Re: [GENERAL] Hot Standby switchover

On Tue, Jun 22, 2010 at 7:08 PM, Dimitri Fontaine wrote: > Now, you can change the primary_conninfo on C so that it connects to > B. I guess that means a restart. Note that you only want to do that once > server B is the new master, so has been triggered as such. That means a > change of TimeLine,

Re: [GENERAL] Hot Standby switchover

Hi, Shoaib Mir writes: > Now Hot-Standby is setup like this... > > A --> B  > A --> C > > Now if I will like to do a switch so as to make B the new master and have my > replication look like this: > > B --> C  > B --> A > > Where are the steps I need for doing so? First, you need a common archi

[GENERAL] Hot Standby switchover

Hi All, Just been trying to learn hot-standby and couldn't figure out a solution to something like this while doing a switchover: I have three nodes where A = Master B = Slave1 C = Slave2 Now Hot-Standby is setup like this... A --> B A --> C Now if I will like to do a switch so as to make B t

[GENERAL] Hot standby

1. Speed of recovery With a archive_timeout of 60 seconds, it can take about 4 minutes before I see the reflected changes in the replica. This is normal since, in addition to the WAL log shipping, it takes more time to do the recovery itself. Still, is there any way besides the archive_timeout

Re: [GENERAL] Hot standby stops after a few days of inactivity (i.e. no new WAL)

Yes, 'warm standby' was what I intended to write. This must have been some kind of wishful thinking. ;) But I'd really appreciate 'hot standby' in a future version of postgres. Marc Merlin Moncure wrote: > On Tue, Nov 4, 2008 at 5:50 AM, Marc Schablewski <[EMAIL PROTECTED]> wrote: > >> Hi, >>

Re: [GENERAL] Hot standby stops after a few days of inactivity (i.e. no new WAL)

Ah, ok. I somehow missed the first line of the message an the rest of it left the impression that "something" must be wrong with replication. I guess one of my colleagues might have shut down the database by accident and forgot to tell me. Anyway, thanks for your reply. Marc Alvaro Herrera wro

Re: [GENERAL] Hot standby stops after a few days of inactivity (i.e. no new WAL)

Marc Schablewski <[EMAIL PROTECTED]> writes: > ... When looking for a reason why the WAL weren't shipped, we found > the following error message: > 2008-10-31 17:07:52 CET 9162LOG: received smart shutdown request > 2008-10-31 17:07:52 CET 9178FATAL: could not restore file > "00010086

Re: [GENERAL] Hot standby stops after a few days of inactivity (i.e. no new WAL)

On Tue, Nov 4, 2008 at 5:50 AM, Marc Schablewski <[EMAIL PROTECTED]> wrote: > Hi, > > we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22 > kernel) as a hot standby. After some maintenances work the WAL files I'm assuming you meant 'warm standby'...hot standby servers can be served

Re: [GENERAL] Hot standby stops after a few days of inactivity (i.e. no new WAL)

Marc Schablewski wrote: > Hi, > > we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22 > kernel) as a hot standby. After some maintenances work the WAL files > couldn't be shipped to that system (which had nothing to do with > postgres, as we found out later). The problem was not no

[GENERAL] Hot standby stops after a few days of inactivity (i.e. no new WAL)

Hi, we are running a PostgreSQL 8.3.3 on a Linux box (SuSE 10.3, 2.6.22 kernel) as a hot standby. After some maintenances work the WAL files couldn't be shipped to that system (which had nothing to do with postgres, as we found out later). The problem was not noticed for about a week. When looking

  1   2   >