HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

force PostgreSQL into recovery mode

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresqlforceintomoderecovery

Problem

I have a somewhat strange question.

Is there a way to manually force PostgreSQL into recovery mode?
I've not been able to find anything in the documentation.

I've been working with a script monitoring a PostgreSQL database and need to do some testing.

Solution

You should be able to use pg_standby.

I cannot gurantee it, though, as I haven't tried it.

Context

StackExchange Database Administrators Q#41549, answer score: 2

Revisions (0)

No revisions yet.