Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9irX-0007NL-TE for pgsql-admin@postgresql.org; Thu, 06 Sep 2012 20:39:44 +0000 Received: from mail-yx0-f174.google.com ([209.85.213.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9irW-0003U7-0G for pgsql-admin@postgresql.org; Thu, 06 Sep 2012 20:39:42 +0000 Received: by yenl14 with SMTP id l14so402489yen.19 for ; Thu, 06 Sep 2012 13:39:40 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:content-transfer-encoding:x-mailer:thread-index :content-language:x-gm-message-state; bh=UapeTFZtx4l2943AoinbYNGXriAZD+rK5Plt1vgtet8=; b=ScLpej5PyCKAjxdtbsikademWQOpQxlRbrAUWKPi9r+JNOqheWOG9bHN/oySZVjJRX zl48Xj+52TOzZzUFd+eFZzDE+uG4526+WWeaFr4YVVfp+Z+USQS6crUYjYFeC0vOSds2 UhAkI6rIOWl2dFguB27HryQfotpxH/J4ReVA02skQ8+1OWsYJcxc2XvtNfeyVRBMRkTN 4OeTCMiOrHSyYQjIr/8LzVsmRSE2YEdkPt0N2ILMZaXZ8k73sUlHFF5NQKf6gpoM6qKQ YIxrKYM3hocUhzBwNiNbDkzzXbPapGH/ANgpbET2qloYn8/suspQON2l7o2/2+4VeYGr BVGA== Received: by 10.236.141.42 with SMTP id f30mr3100436yhj.120.1346963980358; Thu, 06 Sep 2012 13:39:40 -0700 (PDT) Received: from AnibalVAIO ([190.128.222.90]) by mx.google.com with ESMTPS id e16sm2760425ani.22.2012.09.06.13.39.38 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 06 Sep 2012 13:39:39 -0700 (PDT) From: "Anibal David Acosta" To: "'sradez'" , References: <1346948529474-5723063.post@n5.nabble.com> In-Reply-To: <1346948529474-5723063.post@n5.nabble.com> Subject: Re: High Availability(Failover Clustering) for PostgreSQL on Windows 2008 R2 Date: Thu, 6 Sep 2012 16:39:36 -0400 Message-ID: <006c01cd8c6f$bd274ba0$3775e2e0$@devshock.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQEvgzJKN59iUjSSD+LAHxhjpnvphJi50mIQ Content-Language: es-py X-Gm-Message-State: ALoCoQmqT5pco5SW/9lXimUGUwYCouKhFHTuewJwadMHSsgxwNiaJWAec70Zxsmo1HzqMM3UxGmc X-Pg-Spam-Score: -1.5 (-) X-Archive-Number: 201209/24 X-Sequence-Number: 39965 Install Postgres in both server machine Configure the MS Cluster Service, add the external storage and the Postgres Service to your cluster group, and configure the postgres service to start using the directory in the external storage. Now you have a fail over database. Add you application to cluster and you the complete solution. -----Mensaje original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] En nombre de sradez Enviado el: jueves, 06 de septiembre de 2012 12:22 p.m. Para: pgsql-admin@postgresql.org Asunto: [ADMIN] High Availability(Failover Clustering) for PostgreSQL on Windows 2008 R2 Hello, We are planning to use Postgresql for one our project where we can 24/7 uptime. We would like to know if there is a High Availability Solution that can be implemented on Windows Machines. We are specially interested in Clustering(Active-Passive Model with DB sitting on a Shared Drive). Please let us know if its possible and if so,can you please guide me to the appropriate sites where i can find more info on implementation part. Thanks for your time. -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-Availability-Failover-Clusterin g-for-PostgreSQL-on-Windows-2008-R2-tp5723063.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin