Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 35A8BB5DBC4 for ; Wed, 27 Jul 2011 05:51:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 49833-03 for ; Wed, 27 Jul 2011 08:51:22 +0000 (UTC) X-Greylist: delayed 00:09:50.208972 by SQLgrey-1.7.6 Received: from mx3.gwdg.de (mx3.gwdg.de [134.76.10.16]) by mail.postgresql.org (Postfix) with ESMTP id 79CF1B5D800 for ; Wed, 27 Jul 2011 05:51:21 -0300 (ADT) X-IronPort-Reputation-Score: None X-IronPort-AV: E=McAfee;i="5400,1158,6419"; a="35088931" X-IronPort-AV: E=Sophos;i="4.67,275,1309730400"; d="p7s'?scan'208";a="35088931" Received: from mail-gw.mucam.mpg.de (HELO mail.mucam.mpg.de) ([192.129.1.155]) by mailer1.mpg.de with ESMTP/TLS/AES128-SHA; 27 Jul 2011 10:41:28 +0200 Received: from [10.20.2.24] (10.20.2.24) by mail.mucam.mpg.de (10.1.1.41) with Microsoft SMTP Server (TLS) id 14.1.323.0; Wed, 27 Jul 2011 10:41:28 +0200 Message-ID: <4E2FCF38.4090802@mpdl.mpg.de> Date: Wed, 27 Jul 2011 10:41:28 +0200 From: Benjamin Knoth Organization: Max Planck Digital Library User-Agent: Mozilla/5.0 (X11; U; Linux i686; de; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11 MIME-Version: 1.0 To: Subject: HA-Fedora repository with HA-Postgresql Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha1; boundary="------------ms030703000800020804090908" X-Originating-IP: [10.20.2.24] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201107/189 X-Sequence-Number: 37968 --------------ms030703000800020804090908 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: quoted-printable Hi all, i have a Fedora repository which communicates with Postgresql. I would like to have a High Availability solution for this scenario. My first idea was, i use drbd on two VMs to synchronize both partions and use Pacemaker to control the DRBD, IP, Fedora and Postgresql. This part is done and works. But now i think it's not enough to get a HA solution. The problem is that Fedora firstly write the data on the filesystem, than it writes the link and indexies in the DB. For Example if the drbd crashs from Fedora it is possible that the operation couldn't be finished. So the data is written but and the link is written in the DB but not the Index of this object. What should i do? If Fedora DRBD crashs, Pacemaker will detect it, shut down the services in order and start them on the other VM. But at this the operation is incomplete. The data is written on the Filesystem and the Link too, but the Index not. In this moment i have a inconsistence System. The normal way on fedora is to resolve this problem, to reindex and recache it. But we need 4 days to recache and reindex all items. And this isn't possible to have a downtime of 4 days. My idea is to solve this problem, to delete the last written file on the filesystem in Fedora on time x and using WAL on Postgresql to restore the database to time x. After that i should have a consistent system agai= n. But is my idea realistic or do i need pgpool II, slony or only DRBD with Pacemaker? Do someone have experience with a scenario like this? Best regards --=20 Benjamin Knoth --------------ms030703000800020804090908 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIITRjCC BCEwggMJoAMCAQICAgDHMA0GCSqGSIb3DQEBBQUAMHExCzAJBgNVBAYTAkRFMRwwGgYDVQQK ExNEZXV0c2NoZSBUZWxla29tIEFHMR8wHQYDVQQLExZULVRlbGVTZWMgVHJ1c3QgQ2VudGVy MSMwIQYDVQQDExpEZXV0c2NoZSBUZWxla29tIFJvb3QgQ0EgMjAeFw0wNjEyMTkxMDI5MDBa Fw0xOTA2MzAyMzU5MDBaMFoxCzAJBgNVBAYTAkRFMRMwEQYDVQQKEwpERk4tVmVyZWluMRAw DgYDVQQLEwdERk4tUEtJMSQwIgYDVQQDExtERk4tVmVyZWluIFBDQSBHbG9iYWwgLSBHMDEw ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDpm8NnhfkNrvWNVMOWUDU9YuluTO2U 1wBblSJ01CDrNI/W7MAxBAuZgeKmFNJSoCgjhIt0iQReW+DieMF4yxbLKDU5ey2QRdDtoAB6 fL9KDhsAw4bpXCsxEXsM84IkQ4wcOItqaACa7txPeKvSxhObdq3u3ibo7wGvdA/BCaL2a869 080UME/15eOkyGKbghoDJzANAmVgTe3RCSMqljVYJ9N2xnG2kB3E7f81hn1vM7PbD8URwoqD oZRdQWvY0hD1TP3KUazZve+Sg7va64sWVlZDz+HVEz2mHycwzUlU28kTNJpxdcVs6qcLmPkh nSevPqM5OUhqjK3JmfvDEvK9AgMBAAGjgdkwgdYwcAYDVR0fBGkwZzBloGOgYYZfaHR0cDov L3BraS50ZWxlc2VjLmRlL2NnaS1iaW4vc2VydmljZS9hZl9Eb3dubG9hZEFSTC5jcmw/LWNy bF9mb3JtYXQ9WF81MDkmLWlzc3Vlcj1EVF9ST09UX0NBXzIwHQYDVR0OBBYEFEm3xs/oPR9/ 6kR7Eyn38QpwPt5kMB8GA1UdIwQYMBaAFDHDeRu69VPXF+CJei0XbAqzK50zMA4GA1UdDwEB /wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgECMA0GCSqGSIb3DQEBBQUAA4IBAQA74Vp3wEgX 3KkY7IGvWonwvSiSpspZGBJw7Cjy565/lizn8l0ZMfYTK3S9vYCyufdnyTmieTvhERHua3iR M347XyYndVNljjNj7s9zw7CSI0khUHUjoR8Y4pSFPT8z6XcgjaK95qGFKUD2P3MyWA0Ja6ba hWzAP7uNZmRWJE6uDT8yNQFb6YyC2XJZT7GGhfF0hVblw/hc843uR7NTBXDn5U2KaYMo4RMJ hp5eyOpYHgwf+aTUWgRo/Sg+iwK2WLX2oSw3VwBnqyNojWOl75lrXP1LVvarQIc01BGSbOyH xQoLBzNytG8MHVQs2FHHzL8w00Ny8TK/jM5JY6gA9/IcMIIE5zCCA8+gAwIBAgIECs6x2DAN BgkqhkiG9w0BAQUFADBaMQswCQYDVQQGEwJERTETMBEGA1UEChMKREZOLVZlcmVpbjEQMA4G A1UECxMHREZOLVBLSTEkMCIGA1UEAxMbREZOLVZlcmVpbiBQQ0EgR2xvYmFsIC0gRzAxMB4X DTA3MDczMTEzMDgyNVoXDTE5MDYzMDAwMDAwMFowXjELMAkGA1UEBhMCREUxIDAeBgNVBAoT F01heC1QbGFuY2stR2VzZWxsc2NoYWZ0MQ8wDQYDVQQDEwZNUEcgQ0ExHDAaBgkqhkiG9w0B CQEWDW1wZy1jYUBtcGcuZGUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDYUXKe oNTLgkGwbani4rlua5jzlzISfHnaj/5qS+mojQqA/eYa0bGucylV5hyQuyJz7d4gRckdhMDV 8DZIxERUIsFlXFj6HGHjaZjlhIHbo4S12GjLhTH5YZ37O7MHVw0L/JhhzUIxESM1ZfRT/xLq hz2idJYjT98W9OFvzPgT0yrdieMzkLUz5X/fpY8MuyYBgxnddBJRw6ZtlhdCml4F8Q35pSb8 J2qANiwuJVu3WCTgL/ydo3eA8vDieMMZ7O+L1wAnCzBbHAjJ5H6xU1B7mlwmu7V3pToKPgcW mlO0HcTpa68McNTGGiY8pO0/Rn1fXkqDYf8z0lPdWUWxbM1RAgMBAAGjggGvMIIBqzASBgNV HRMBAf8ECDAGAQH/AgEBMAsGA1UdDwQEAwIBBjAdBgNVHQ4EFgQUAtYebgmrv1hlpwo8SDNh 0c59w1swHwYDVR0jBBgwFoAUSbfGz+g9H3/qRHsTKffxCnA+3mQwGAYDVR0RBBEwD4ENbXBn LWNhQG1wZy5kZTCBiAYDVR0fBIGAMH4wPaA7oDmGN2h0dHA6Ly9jZHAxLnBjYS5kZm4uZGUv Z2xvYmFsLXJvb3QtY2EvcHViL2NybC9jYWNybC5jcmwwPaA7oDmGN2h0dHA6Ly9jZHAyLnBj YS5kZm4uZGUvZ2xvYmFsLXJvb3QtY2EvcHViL2NybC9jYWNybC5jcmwwgaIGCCsGAQUFBwEB BIGVMIGSMEcGCCsGAQUFBzAChjtodHRwOi8vY2RwMS5wY2EuZGZuLmRlL2dsb2JhbC1yb290 LWNhL3B1Yi9jYWNlcnQvY2FjZXJ0LmNydDBHBggrBgEFBQcwAoY7aHR0cDovL2NkcDIucGNh LmRmbi5kZS9nbG9iYWwtcm9vdC1jYS9wdWIvY2FjZXJ0L2NhY2VydC5jcnQwDQYJKoZIhvcN AQEFBQADggEBABtJz5i/SGqQOficdRUN6myFVmVelCYgkGT+zX7frnBRJFoVVafXolstZdVB 7ZpH9FAcqj8O6FTZyhAANwh3+Y1D6xYBWTB7mQGy0lUoUL+j0msZjaMvyj/2LCQp7cKB5vA4 h6Ntq5BN5MPcaRhunzjJey/i+J/3jMdG7KpufV47Gl0E8ky9lDegaM7SToG4IOQKwv1wsnuH oxoGLRewxO7FmYd9uq9f4L2mHtqgq+vibT1DeehT0HGPnrjjd8NK6g2TvZwirwjydbGs7szB 5oxDm/pfWoJxYzO68HKTiVBlmaWMLpGw4/UsLE+5xJHpvNXfkYCQ3T+k99KBUZuIpKwwggUX MIID/6ADAgECAgQSH9p9MA0GCSqGSIb3DQEBBQUAMF4xCzAJBgNVBAYTAkRFMSAwHgYDVQQK ExdNYXgtUGxhbmNrLUdlc2VsbHNjaGFmdDEPMA0GA1UEAxMGTVBHIENBMRwwGgYJKoZIhvcN AQkBFg1tcGctY2FAbXBnLmRlMB4XDTExMDYyMTA4NTcxOFoXDTE0MDYyMDA4NTcxOFowgZEx CzAJBgNVBAYTAkRFMSAwHgYDVQQKExdNYXgtUGxhbmNrLUdlc2VsbHNjaGFmdDEjMCEGA1UE CxMaTWF4IFBsYW5jayBEaWdpdGFsIExpYnJhcnkxIjAgBgNVBAsTGUZvcnNjaHVuZyB1bmQg RW50d2lja2x1bmcxFzAVBgNVBAMTDkJlbmphbWluIEtub3RoMIIBIjANBgkqhkiG9w0BAQEF AAOCAQ8AMIIBCgKCAQEA7AvBCAbmYPoIFBGohsuAH3TjnCTzhWc6ppGO9Hciqpnr/ex39j59 x4xpognCfZykgjMXT6fpRqlaXILxvUVsy9BoP/3ftQqXxqaaGEees8RQOgg1swuvoLNWaP17 7KfceqQ3tFSy0jP87yyKj4CtRNvZiKlBt00xRDBEe54JpS/n1b5Zd1cmXowoXglPrGp1Oa7B d95TCA0ImZTbzjdloCUu8LB1b+lgx4w2sljk7fj00INu4hUiHEpKJgitl3jznsWR2I7IyUzY RnnbjaysyFpo1D66xoPGzNa0P7ide3X3zCRaXF/HqElgbnBDef2cVJ6ULdo0Rn31XYQf+3nB KQIDAQABo4IBpzCCAaMwCQYDVR0TBAIwADALBgNVHQ8EBAMCBeAwHQYDVR0lBBYwFAYIKwYB BQUHAwIGCCsGAQUFBwMEMB0GA1UdDgQWBBRp8wnhuzMl3iQNAUSLUbHRywTlEzAfBgNVHSME GDAWgBQC1h5uCau/WGWnCjxIM2HRzn3DWzAcBgNVHREEFTATgRFrbm90aEBtcGRsLm1wZy5k ZTB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY2RwMS5wY2EuZGZuLmRlL21wZy1jYS9wdWIv Y3JsL2NhY3JsLmNybDA1oDOgMYYvaHR0cDovL2NkcDIucGNhLmRmbi5kZS9tcGctY2EvcHVi L2NybC9jYWNybC5jcmwwgZIGCCsGAQUFBwEBBIGFMIGCMD8GCCsGAQUFBzAChjNodHRwOi8v Y2RwMS5wY2EuZGZuLmRlL21wZy1jYS9wdWIvY2FjZXJ0L2NhY2VydC5jcnQwPwYIKwYBBQUH MAKGM2h0dHA6Ly9jZHAyLnBjYS5kZm4uZGUvbXBnLWNhL3B1Yi9jYWNlcnQvY2FjZXJ0LmNy dDANBgkqhkiG9w0BAQUFAAOCAQEAUwutszmNfHKsbXRxHoM0bsTRa5n3Y5sSC7D6w1r/4Ske 944FdEVVIARV6ySD4R7xWsneh4He4PI93BV3QWnSLgapMXVHwsNYsuxyiYzYPR2B4ClDA1Sc I3pbunR1UWGAbMKcr4KxQXa9YDZifShSaagzw+Y6K1xc9N5dRr5BZ+0BUFJtWTCGXiXJcZY7 KR5v+HogRtEJIcdtW2pndGbH4SPKNGEexRLqzkpCin3Z/kl4WhrmBu4Y92EeJeIxzZjwCXwJ yEloNWGqUDARjghDX4LmEZ9oRsgoY4RZvjny94KPtlL0rBcRtIhUrJxo7EOskRqUUimjD28N rgpPq8HRiTCCBRcwggP/oAMCAQICBBIf2n0wDQYJKoZIhvcNAQEFBQAwXjELMAkGA1UEBhMC REUxIDAeBgNVBAoTF01heC1QbGFuY2stR2VzZWxsc2NoYWZ0MQ8wDQYDVQQDEwZNUEcgQ0Ex HDAaBgkqhkiG9w0BCQEWDW1wZy1jYUBtcGcuZGUwHhcNMTEwNjIxMDg1NzE4WhcNMTQwNjIw MDg1NzE4WjCBkTELMAkGA1UEBhMCREUxIDAeBgNVBAoTF01heC1QbGFuY2stR2VzZWxsc2No YWZ0MSMwIQYDVQQLExpNYXggUGxhbmNrIERpZ2l0YWwgTGlicmFyeTEiMCAGA1UECxMZRm9y c2NodW5nIHVuZCBFbnR3aWNrbHVuZzEXMBUGA1UEAxMOQmVuamFtaW4gS25vdGgwggEiMA0G CSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDsC8EIBuZg+ggUEaiGy4AfdOOcJPOFZzqmkY70 dyKqmev97Hf2Pn3HjGmiCcJ9nKSCMxdPp+lGqVpcgvG9RWzL0Gg//d+1CpfGppoYR56zxFA6 CDWzC6+gs1Zo/Xvsp9x6pDe0VLLSM/zvLIqPgK1E29mIqUG3TTFEMER7ngmlL+fVvll3VyZe jCheCU+sanU5rsF33lMIDQiZlNvON2WgJS7wsHVv6WDHjDayWOTt+PTQg27iFSIcSkomCK2X ePOexZHYjsjJTNhGeduNrKzIWmjUPrrGg8bM1rQ/uJ17dffMJFpcX8eoSWBucEN5/ZxUnpQt 2jRGffVdhB/7ecEpAgMBAAGjggGnMIIBozAJBgNVHRMEAjAAMAsGA1UdDwQEAwIF4DAdBgNV HSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwHQYDVR0OBBYEFGnzCeG7MyXeJA0BRItRsdHL BOUTMB8GA1UdIwQYMBaAFALWHm4Jq79YZacKPEgzYdHOfcNbMBwGA1UdEQQVMBOBEWtub3Ro QG1wZGwubXBnLmRlMHcGA1UdHwRwMG4wNaAzoDGGL2h0dHA6Ly9jZHAxLnBjYS5kZm4uZGUv bXBnLWNhL3B1Yi9jcmwvY2FjcmwuY3JsMDWgM6Axhi9odHRwOi8vY2RwMi5wY2EuZGZuLmRl L21wZy1jYS9wdWIvY3JsL2NhY3JsLmNybDCBkgYIKwYBBQUHAQEEgYUwgYIwPwYIKwYBBQUH MAKGM2h0dHA6Ly9jZHAxLnBjYS5kZm4uZGUvbXBnLWNhL3B1Yi9jYWNlcnQvY2FjZXJ0LmNy dDA/BggrBgEFBQcwAoYzaHR0cDovL2NkcDIucGNhLmRmbi5kZS9tcGctY2EvcHViL2NhY2Vy dC9jYWNlcnQuY3J0MA0GCSqGSIb3DQEBBQUAA4IBAQBTC62zOY18cqxtdHEegzRuxNFrmfdj mxILsPrDWv/hKR73jgV0RVUgBFXrJIPhHvFayd6Hgd7g8j3cFXdBadIuBqkxdUfCw1iy7HKJ jNg9HYHgKUMDVJwjelu6dHVRYYBswpyvgrFBdr1gNmJ9KFJpqDPD5jorXFz03l1GvkFn7QFQ Um1ZMIZeJclxljspHm/4eiBG0Qkhx21bamd0ZsfhI8o0YR7FEurOSkKKfdn+SXhaGuYG7hj3 YR4l4jHNmPAJfAnISWg1YapQMBGOCENfguYRn2hGyChjhFm+OfL3go+2UvSsFxG0iFSsnGjs Q6yRGpRSKaMPbw2uCk+rwdGJMYIDPzCCAzsCAQEwZjBeMQswCQYDVQQGEwJERTEgMB4GA1UE ChMXTWF4LVBsYW5jay1HZXNlbGxzY2hhZnQxDzANBgNVBAMTBk1QRyBDQTEcMBoGCSqGSIb3 DQEJARYNbXBnLWNhQG1wZy5kZQIEEh/afTAJBgUrDgMCGgUAoIIBrjAYBgkqhkiG9w0BCQMx CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMTA3MjcwODQxMjhaMCMGCSqGSIb3DQEJ BDEWBBR4T96/A8pieKOkevxqMLOK1kiW9zBfBgkqhkiG9w0BCQ8xUjBQMAsGCWCGSAFlAwQB AjAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcw DQYIKoZIhvcNAwICASgwdQYJKwYBBAGCNxAEMWgwZjBeMQswCQYDVQQGEwJERTEgMB4GA1UE ChMXTWF4LVBsYW5jay1HZXNlbGxzY2hhZnQxDzANBgNVBAMTBk1QRyBDQTEcMBoGCSqGSIb3 DQEJARYNbXBnLWNhQG1wZy5kZQIEEh/afTB3BgsqhkiG9w0BCRACCzFooGYwXjELMAkGA1UE BhMCREUxIDAeBgNVBAoTF01heC1QbGFuY2stR2VzZWxsc2NoYWZ0MQ8wDQYDVQQDEwZNUEcg Q0ExHDAaBgkqhkiG9w0BCQEWDW1wZy1jYUBtcGcuZGUCBBIf2n0wDQYJKoZIhvcNAQEBBQAE ggEAEVldbVe91lTUe7IY9LiZobLCBD1JR0Ku9hifmNLzCZsvUGe6XuwPu6QlMkc1f0c9GQc7 PFQ+rwjyc5df8rDwk8VBVMAmqQut76Fg6ns4CYuBokm7l2NomixPY5C6KRHKlQSqIsnQmCxH KOriqC8s8Nngj5T+Iw1P3oLcjhnsFd46DrNBWfyFwpp96shTzOuNaWpDuMNn0sCmky9Gqrls vt1YgO1Kk29/uLsc8xSpviSrf9eiCBG1QDi5dOgV9nTUW4N3jPd+tG5q0Z8pkRr9WGhg3QCj gT7yQEkefj0yv4RxNrIl0zKRrJ1NYRvWj//khQiqrqFaIM5Z4Bo3dySx+gAAAAAAAA== --------------ms030703000800020804090908--