Re: Questions about how to streaming replication (pg 9.2)

2020-01-21 Thread Laurenz Albe
On Tue, 2020-01-21 at 11:18 +0100, Ekaterina Amez wrote: [about wal_keep_segments] > I'm not sure how to figure this value . Of course I could use a big > value and forget, but as the server is running out of space I'd like to > adjust it so there is (almost) no waste of space. This is why I be

Re: Questions about how to streaming replication (pg 9.2)

2020-01-21 Thread Ekaterina Amez
El 21/1/20 a las 10:14, Laurenz Albe escribió: On Mon, 2020-01-20 at 14:59 +0100, Ekaterina Amez wrote: PS: Just in case anyone wants to know, this is part of the process of upgrade a server with 9.2 version that has no free space in PGDATA and that can't be stopped for much time. After aski

Re: Questions about how to streaming replication (pg 9.2)

2020-01-21 Thread Laurenz Albe
On Mon, 2020-01-20 at 14:59 +0100, Ekaterina Amez wrote: > PS: Just in case anyone wants to know, this is part of the process of upgrade > a server with 9.2 version > that has no free space in PGDATA and that can't be stopped for much time. > After asking here, the strategy > to upgrade will be:

Questions about how to streaming replication (pg 9.2)

2020-01-20 Thread Ekaterina Amez
Hi all, After your comments about how to upgrade postgres from 9.2 to 9.6 in an overloaded server I've been learning and testing streaming replication. But the info I've found about this topic is not enough for me (or I'm not able to completely understand it). (I'm bad with terminology as I'