Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 2592FBEAE5D for ; Wed, 25 Jul 2012 15:16:20 -0300 (ADT) Received: from 30.55.colo.spiretech.net ([69.168.55.30] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Su689-0006xo-LY for pgsql-admin@postgresql.org; Wed, 25 Jul 2012 18:16:20 +0000 Received: from [192.168.1.5] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id AA00334D; Wed, 25 Jul 2012 11:16:03 -0700 (PDT) Received: from [192.168.1.5] ([68.118.161.194] helo=[192.168.1.5]) by assp.commandprompt.com with ESMTPS(AES256-SHA) (2.1.1); 25 Jul 2012 11:16:03 -0700 Message-ID: <501037D6.1060007@commandprompt.com> Date: Wed, 25 Jul 2012 11:15:50 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120714 Thunderbird/14.0 MIME-Version: 1.0 To: Noe Gutierrez CC: pgsql-admin@postgresql.org Subject: Re: Could You help me References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-40163-02477 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: noebartino@gmail.com X-Assp-Original-Subject: Re: [ADMIN] Could You help me X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/76 X-Sequence-Number: 39793 On 07/25/2012 11:11 AM, Noe Gutierrez wrote: > they work succesfull an the replication too, but when The Master crashes: > > 1.- How to promote to slave becomes a new Master and > > 2.- When Old Master restarts: > > How to become old master to slave > > How To configure failover in general You are going to need to install some HAC components, such as pacemaker/corosync and automate the base backup creation for the old master. It is not complicated but it is comprehensive. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC @cmdpromptinc - 509-416-6579