V
V
Vladimir2021-02-10 11:41:15
PostgreSQL
Vladimir, 2021-02-10 11:41:15

Is it possible to determine at what point a PostreSQL cluster was restored without having the metadata of the backup tool?

When restoring a Postgresql cluster, the database and WAL files are restored. If PITR is not used, is it possible to determine at what point the latest data was created in a given cluster?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2021-02-10
@idskill

select pg_last_xact_replay_timestamp ();

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question