Re: adding more space to the existing server

2019-08-05 Thread Julie Nishimura
; connecting to A (half of them need to be changed to B anyway) while B is > catching up on its lag. You probably have at least that much down-time to > change the connections anyway. > > Regards, > > Alban. > > >> From: Alban Hertroys >> Sent: Monday, Augu

Re: adding more space to the existing server

2019-08-05 Thread Alban Hertroys
icates to D >> > End state: > A replicates to D > B replicates to C >> >> we remove some of the dbs from A and B, then reassign the traffic based on >> db selections >> >> I hope it all makes sense... >> >> Thank you > It does to me. Now

Re: adding more space to the existing server

2019-08-05 Thread Julie Nishimura
_ From: Alban Hertroys Sent: Monday, August 5, 2019 5:01 AM To: Julie Nishimura Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org ; pgsql-general Subject: Re: adding more space to the existing server On 5 Aug 2019, at 0:39, Julie Nishimura mailto:juliez...@hotmail.com>> wrote:

Re: adding more space to the existing server

2019-08-05 Thread Alban Hertroys
ons I hope it all makes sense... Thank you It does to me. Now would be a good time for people to chime in if they don't agree ;) From: Alban Hertroys Sent: Saturday, August 3, 2019 3:15 AM To: Julie Nishimura Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org ; pgsql-general Subject:

Re: adding more space to the existing server

2019-08-04 Thread Julie Nishimura
ishimura Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org ; pgsql-general Subject: Re: adding more space to the existing server > On 2 Aug 2019, at 21:45, Julie Nishimura wrote: > 1) We use streaming replication, and due to hardware limitation, we cannot > add more drives to the e

Re: adding more space to the existing server

2019-08-03 Thread Alban Hertroys
> On 2 Aug 2019, at 21:45, Julie Nishimura wrote: > 1) We use streaming replication, and due to hardware limitation, we cannot > add more drives to the existing host. That is why we thought by breaking the > existing streaming replication (from a->b), instead of currently identical > standby

Re: adding more space to the existing server

2019-08-02 Thread Adrian Klaver
On 8/2/19 12:45 PM, Julie Nishimura wrote: Thanks for your replies. 1) We use streaming replication, and due to hardware limitation, we cannot add more drives to the existing host. That is why we thought by breaking the existing streaming replication (from a->b), instead of currently identica

Re: adding more space to the existing server

2019-08-02 Thread Julie Nishimura
ostgres Thank you! From: Adrian Klaver Sent: Thursday, August 1, 2019 7:28 AM To: Julie Nishimura ; pgsql-general@lists.postgresql.org ; pgsql-general Subject: Re: adding more space to the existing server On 7/31/19 3:21 PM, Julie Nishimura wrote: >

Re: adding more space to the existing server

2019-08-01 Thread Adrian Klaver
On 7/31/19 3:21 PM, Julie Nishimura wrote: Hello postgres folks, We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully popula

Re: adding more space to the existing server

2019-07-31 Thread Ron
On 7/31/19 5:21 PM, Julie Nishimura wrote: Hello postgres folks, We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully popula

adding more space to the existing server

2019-07-31 Thread Julie Nishimura
Hello postgres folks, We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully populate, then breaking replication, making the sta