Postgres Pro
Downloads
Home   >   mailing lists

postgres 9.0.2 replicated database is crashing - Mailing list pgsql-general

From akp geek
Subject postgres 9.0.2 replicated database is crashing
Date
Msg-id CACnhOf+3dvXeCrrga7kj8Ppniv6xh=MYo+pMy_a1wZ14nQAcog@mail.gmail.com
Whole thread Raw
Responses Re: postgres 9.0.2 replicated database is crashing
List pgsql-general
Tree view
Hi all -

         I am in desperate need of your help. The replication/streaming stopped working on March5th. I followed the following procedure to restart the streaming. After running it for couple of hours , the database is crashing on the slave.  This is on our production server.  Thanks for your help.

Steps that I followed

1.  SELECT pg_start_backup('label', true);
2.  I created tar of data.  
3.  un tar the data on the slave.  
4. deleted the pid file on the slave
5. created recovery.conf
5. SELECT pg_stop_backup();  on the primary
6.  started the postgres on slave
7.  After 2 hours,  the slave server crashes

Please help.  

Regards

pgsql-general by date:

Previous
From: Ian Pilcher
Date:
Subject: Re: Trust intermediate CA for client certificates
Next
From: Lonni J Friedman
Date:
Subject: Re: Replication stopped on 9.0.2 after making change to conf file