1

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 ?

Vao Tsun
  • 47,234
  • 13
  • 100
  • 132
Pramod Tiwari
  • 298
  • 5
  • 16

1 Answers1

2

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

Vao Tsun
  • 47,234
  • 13
  • 100
  • 132
  • For restore need to stop server.when server stop and any one try to access then will show error right ? – Pramod Tiwari Nov 07 '17 at 07:07
  • if you restore in same server, just specify different directory. you cant recover existing cluster back in time - only spin up a copy and recover it till some point – Vao Tsun Nov 07 '17 at 08:32