Gustav Potgieter wrote: > Hope you can assist and that I am posting to the right forum. Sending the question twice with the same wording does not make it clearer... > We currently have multiple Postgresql 9 instances running with warm standby, and the replication work > wonderfully. > > The problem is the following, we take the slave database out of recovery and it works perfectly, but > when we create a new database and setup streaming replication to point to this database it is read > only and never "starts up". > > "I created a test database and it did replicate across, but I could only see it once I removed > recovery.conf and re-started obviously not in recovery anymore, I attached the logs at the bottom FYI" > > Is this even possible, to re-create a streaming database again from an ex slave database with a base > backup and simply re-creating recovery.conf before startup? If I understand you correctly, there are three computers involved: An original master, an original slave that "is taken out of recovery" (promoted?), and a new slave that is set up using the original slave as master. Right? That should work if you do it right. You quote from a number of logs, but to me it is not clear which log belongs to which server. Let's say the original master is A, the original slave and new master is B and the new slave is C. It would be interesting to see B's log from when replication is set up and starts working, B's log from the time it is promoted to master, and C's log from the time when you try to set it up as B's slave. Do you share WAL archives between the machines? If yes, how? How exactly did you promote B? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
