... | @@ -1049,7 +1049,7 @@ You should more likely use the [direct backup recovery](#direct-backup-recovery) |
... | @@ -1049,7 +1049,7 @@ You should more likely use the [direct backup recovery](#direct-backup-recovery) |
|
apt install postgres rsync
|
|
apt install postgres rsync
|
|
service postgresql stop
|
|
service postgresql stop
|
|
mv /var/lib/postgresql/*/main{,.orig}
|
|
mv /var/lib/postgresql/*/main{,.orig}
|
|
su -c 'mkdir -m 0700 /var/lib/postgresql/9.6/main' postgres
|
|
su -c 'mkdir -m 0700 /var/lib/postgresql/13/main' postgres
|
|
|
|
|
|
We'll be restoring files in that `main` directory.
|
|
We'll be restoring files in that `main` directory.
|
|
|
|
|
... | @@ -1069,7 +1069,7 @@ You should more likely use the [direct backup recovery](#direct-backup-recovery) |
... | @@ -1069,7 +1069,7 @@ You should more likely use the [direct backup recovery](#direct-backup-recovery) |
|
8. Make sure the `pg_xlog` directory doesn't contain any files.
|
|
8. Make sure the `pg_xlog` directory doesn't contain any files.
|
|
|
|
|
|
9. Then you need to create add a configuration parameter in
|
|
9. Then you need to create add a configuration parameter in
|
|
`/etc/postgresql/13/main/postgresql.conf` that will tell postgres where to
|
|
`/etc/postgresql/13/main/conf.d/recovery.conf` that will tell postgres where to
|
|
find the WAL files. At least the `restore_command` need to be
|
|
find the WAL files. At least the `restore_command` need to be
|
|
specified. Something like this should work:
|
|
specified. Something like this should work:
|
|
|
|
|
... | @@ -1085,7 +1085,7 @@ You should more likely use the [direct backup recovery](#direct-backup-recovery) |
... | @@ -1085,7 +1085,7 @@ You should more likely use the [direct backup recovery](#direct-backup-recovery) |
|
11. Then start the server and look at the logs to follow the recovery
|
|
11. Then start the server and look at the logs to follow the recovery
|
|
process:
|
|
process:
|
|
|
|
|
|
service postgresql start
|
|
systemctl start postgresql@13-main.service
|
|
tail -f /var/log/postgresql/*
|
|
tail -f /var/log/postgresql/*
|
|
|
|
|
|
12. re-enable Puppet, which should clean up the extra SSH key and
|
|
12. re-enable Puppet, which should clean up the extra SSH key and
|
... | | ... | |