Re: Need help with PITR for PostgreSQL 9.4.5
| От | David G. Johnston |
|---|---|
| Тема | Re: Need help with PITR for PostgreSQL 9.4.5 |
| Дата | |
| Msg-id | CAKFQuwabUucmjzB2uyoq31qM4pcgP_rOGMQ4jA5P+itCDE9Xxw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Need help with PITR for PostgreSQL 9.4.5 (Sri Linux <srilinux09@gmail.com>) |
| Ответы |
Re: Need help with PITR for PostgreSQL 9.4.5
|
| Список | pgsql-general |
The version you are running is neither up-to-date for its major version (9.4) nor is the major version being supported.
Thoug a functioning backup is good to have before upgrading, especially major versions.
I am trying to do PINT backup and recovery for the standalone database which is not in a cluster.
That is not possible. Its unclear what exactly you mead/did though. Consider sharing actual commands/scripts.
< 2020-06-22 16:34:08.487 CDT >LOG: WAL file is from different database system: WAL file database system identifier is 6840038030519879233, pg_control database system identifier is 6841285371464745049.
You cannot PITR if the WAL doesn’t match the base backup for the cluster you are trying to restore.
Or, probably better, consider using a third-party system.
David J.
В списке pgsql-general по дате отправления: