| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Ekaterina Amez <ekaterina(dot)amez(at)zunibal(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Questions about how to streaming replication (pg 9.2) |
| Date: | 2020-01-21 09:14:37 |
| Message-ID: | 78be5263a8ec9822402a3b875ff774eac2a5b010.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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: replicate this DB to a path with space to grow, switch clusters (slave becoming master
> and creating a new slave to have just-in-case), and pg_upgrade slave/new master with --link option.
Do not upgrade to 9.6, upgrade to at least v11.
Set "wal_keep_segments" high enough on the primary for safety.
Run "pg_basebackup" on the standby.
Create a "recovery.conf" on the standby that has "primary_conninfo" set
and "standby_mode = on".
Start the standby and wait until it has caught up, then switch over.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ekaterina Amez | 2020-01-21 10:18:32 | Re: Questions about how to streaming replication (pg 9.2) |
| Previous Message | Michael Paquier | 2020-01-21 08:22:29 | Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int |