Postgresql – force PostgreSQL into recovery mode

postgresql

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.

Best Answer

You should be able to use pg_standby.

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

Related Solutions

Postgresql recovery after reboot

To locate your data try the following command:

sudo find / -name postgresql.conf

The problem probably is that your server isn't automatically started. You can manually start it with a command like:

pg_ctl start -D <your data dir>

If you need help starting it automatically please specify which os/distribution you are running and how you installed postgresql (source/yum/rpm/...)

Postgresql – Do I need to perform any tasks after Postgres goes into recovery mode

May I suggest upgrading to PostgreSQL 9.3 (freshly out!)? Some write that the new Streaming-Only Remastering capability turns a replica in a set of replicas into the new master for all of the other replicas. Apparently, it's even more useful in combination with the cascading replication you are using in 9.2

In PostgreSQL 9.2, cascading replication really requires file-based WAL archiving to work in case of disaster recovery. PostgreSQL 9.3 will not require that: you can set up large replication clusters of whatever length you want without any WAL archiving.

More information:

Best Answer

Related Solutions

Postgresql recovery after reboot

Postgresql – Do I need to perform any tasks after Postgres goes into recovery mode

Related Question