Postgresql – Write performance of Postgresql 9.1 with read-only slave

I don't know how well this works on Heroku but I think it should work if one is using streaming replication internally. I would recommend repmgr which is an open source replication cluster management tool from 2ndQuadrant. This provides a general monitoring and management framework for replicated database clusters. In 9.3, repmgr will be less necessary but still may be helpful for integration into heartbeat systems. It provides a command line tool for failovers, preparing slaves, etc.

If you have to do something like this manually and repmgr wont work for you, basically, what you need to do is this:

1. turn off the master (shoot the other node in the head)

2. promote the slave to a master

3. re-base your other slaves and point them at the new master

4. turn your old master into a new slave when you can bring it up.

How you do this will depend to some extent on the replication approach.

I cannot check how it is in 9.2, but I had this exact same difficulty in 9.3.

The problem is that initdb is installed. It just isn't in your path.

What happens when you run these two commands?

updatedb
locate initdb

That's how I found it. Then, all I had to do was execute :

/usr/lib/postgresql/9.3/bin/initdb

You'll probably find that it's just the same in 9.2.