Search code examples
postgresqlpostgresql-9.2rhel7pitr

WAL Archive Backup and Restore

In a postgresql, how to create WAL archieve ? Step by step explanation is available for Backup and Restore using Linux or shell command?

Enviroment :
OS : LINUX RHEL 7.4
DB : Postgresql 9.2

is there any options without stopping postgresql complete backup as well as restore ?

Solution

  • yes, it is described https://www.postgresql.org/docs/9.2/static/continuous-archiving.html

    with examples for unix like system.

    you dont have to stop postgres to take backup, neither base backup, nor wals