Re: [GENERAL] Confused about max_standby_streaming_delay

2017-09-07 Thread Robert Inder
ive queries, but ​(I think -- I'll have to check!) that is all > > Cheers, > > Jeff > ​Robert.​ -- Robert Inder,0131 229 1052 / 07808 492 213 Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh EH3 9HH Registered in Scotland, Company no. SC 150689 Interactions speak louder than words

[GENERAL] Confused about max_standby_streaming_delay

2017-09-06 Thread Robert Inder
ump of database_c is timestamped less than 10 minutes after the dump of database_a Which does not fit with the dump of database_b being given 10 minutes in which to finish Have I misunderstood something? Or is Postgres not actually configured the way I think it is? Robert. -- Robert Inder,

Re: [GENERAL] Moving pg_xlog

2016-12-03 Thread Robert Inder
Thanks, everyone, for your comments. I think I've got a clearer idea of what's going on now... Robert. On 1 December 2016 at 13:55, Robert Inder wrote: > I'm running Postgres9.4 in master/hot-standby mode on a few pairs of servers. > > While recovering from A Bit Of

[GENERAL] Moving pg_xlog

2016-12-01 Thread Robert Inder
or near the section that talks about file locations in the context of server configuration. Robert. -- Robert Inder,0131 229 1052 / 07808 492 213 Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh EH3 9HH Registered in Scotland, Company no. SC 1

Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-13 Thread Robert Inder
ot;) I'm doing that, Steven's suggestion of making the dump to a ram file system, then filing it as a separate step, looks simple enough to be worth trying as a stop-gap... Robert. -- Robert Inder, Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh

Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-12 Thread Robert Inder
this something that has changed with Postgres 9? We're currently running Postgres 8.4. Is this my specific reason to embark on an upgrade? Robert. -- Robert Inder, Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh EH3 9HH Registere

Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-12 Thread Robert Inder
er issue would be how long the "replay" would take. But, I realise, that's not a major concern: the delay would only be seen by a client that had had a major problem. Everyone else would see service as normal. I think I'll be doing some experiments to find out:-) Robert. --

[GENERAL] Basic Question on Point In Time Recovery

2015-03-11 Thread Robert Inder
way to go about things. Or are we missing something? Is there some other way to restore one database without affecting the others? Thanks in advance. Robert. -- Robert Inder, Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh EH3 9HH Registered in Scotland, Company no. SC 150689