Received: from bildbasen.se (bs1.bildbasen.kiruna.se [193.45.225.97]) by hub.org (8.8.8/8.7.5) with SMTP id KAA09394 for ; Tue, 2 Jun 1998 10:04:52 -0400 (EDT) Received: (qmail 28101 invoked from network); 2 Jun 1998 14:04:18 -0000 Received: from guevara.bildbasen.se (HELO bildbasen.se) (goran@193.45.225.110) by bs1.bildbasen.se with SMTP; 2 Jun 1998 14:04:18 -0000 Sender: goran Message-ID: <35740662.A12290FC@bildbasen.se> Date: Tue, 02 Jun 1998 16:04:18 +0200 From: Goran Thyni Organization: JMS Bildbasen i Kiruna AB X-Mailer: Mozilla 4.05 [en] (X11; U; Linux 2.0.33 i686) MIME-Version: 1.0 To: pgsql-hackers@postgreSQL.org CC: Mattias Kregert Subject: Re: [HACKERS] An easier way to upgrade (Was: Lots 'o patches) References: <9806020554.AA29494@hawk.illustra.com> <3573BFF6.65D6BC74@algonet.se> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms102567BBC160A89FD27FA5B8" This is a cryptographically signed message in MIME format. --------------ms102567BBC160A89FD27FA5B8 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Mattias Kregert wrote: > How about making a file specifying what to do when upgrading from one > version of pg to another? Then a program, let's call it 'pgconv', would > read this file and do the conversions from the old to the new format > using pg_dump and psql and/or some other helper programs. I think what is needed is a replication program, since pgsql uses socket comunication it is quiet easy to run 2 concurrent systems say one each of 6.3.2 and 6.4 and copy beteewn them at run-time. The easiest way would be to use dump&load but as David pointed out in a case where dump&load takes 20 hours it means 20 hours downtime unless we want inconsistent data (data inserted/updated while copying). A smarter replication would make the downtime shorter since most data would be upto date and only latest changes need to be transfer during "update downtime". Such a mechanism would be even more useful for other proposes like clustering/backup/redundancy etc. Has anyone looked as this? The only thing I have seen is the Mariposa project which seems to be somewhat overkill for most applications. -- --------------------------------------------- Göran Thyni, sysadm, JMS Bildbasen, Kiruna --------------ms102567BBC160A89FD27FA5B8 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIL0QYJKoZIhvcNAQcCoIILwjCCC74CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC CW8wggLuMIICV6ADAgECAgIZbzANBgkqhkiG9w0BAQQFADCByDELMAkGA1UEBhMCWkExFTAT BgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRo YXd0ZSBDb25zdWx0aW5nMTMwMQYDVQQLEypDZXJ0aWZpY2F0ZSBTZXJ2aWNlcyBSU0EgSUsg MTk5OC4yLjI1IDg6MzUxOzA5BgNVBAMTMlRoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBSU0Eg SXNzdWluZyBLZXkgMTk5OC4yLjI1MB4XDTk4MDMwMjE3MDYyMVoXDTk5MDMwMjE3MDYyMVow VzEyMDAGA1UEAxMpVGhhd3RlIEZyZWVtYWlsIE1lbWJlciBnb3JhbkBiaWxkYmFzZW4uc2Ux ITAfBgkqhkiG9w0BCQEWEmdvcmFuQGJpbGRiYXNlbi5zZTCBnzANBgkqhkiG9w0BAQEFAAOB jQAwgYkCgYEAo7Lh1Ja07mVVMuv9lo7ECN/aMd2FUxJk8xp8ACAFCKQRmuaC+e4EX/IODZUF Qqc7TPIsDH/0/ihn79/uYF+ziWUTQLCuQ29sdrS5Wkr0yeGqg2hqTSqsECDm24hsPJleiYEW KM8i9tGPF2zngmBPM71ZKNZAAjvS72anT7jmPBkCAwEAAaNXMFUwFAYJYIZIAYb4QgEBAQH/ BAQDAgWgMA4GA1UdDwEB/wQEAwIFoDAMBgNVHRMBAf8EAjAAMB8GA1UdIwQYMBagFO00F24O K15Lh5iRuDenmL+SH6xyMA0GCSqGSIb3DQEBBAUAA4GBAK9OqiylF0yjZL6PmNkeImqXLQo7 LYUdmbKr08/Avvhn7wzLSw4yH3eJcOUEI5hR1yRjmH+HwwehNXI6i3SAX3vivEgX57Spxedl JoJQ4Rgp2n2AcxUR3Ot0+cxczGIdTS1Kh+SuDyMIiDAJBc50BAx0fCJHJ8I5PaW9OizSMDAx MIIDSDCCArGgAwIBAgIBCDANBgkqhkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUg Q29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEk MCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxw ZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTk4MDIyNTA4MzUzM1oXDTAwMDIyNTA4 MzUzM1owgcgxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcT C0R1cmJhbnZpbGxlMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEzMDEGA1UECxMqQ2Vy dGlmaWNhdGUgU2VydmljZXMgUlNBIElLIDE5OTguMi4yNSA4OjM1MTswOQYDVQQDEzJUaGF3 dGUgUGVyc29uYWwgRnJlZW1haWwgUlNBIElzc3VpbmcgS2V5IDE5OTguMi4yNTCBnzANBgkq hkiG9w0BAQEFAAOBjQAwgYkCgYEAxzHDxBuZI3LSUYWVTONZkuTobIG19BtfCebErbNEb6o4 11fksMXLunSuTGEjJHYG+NldDYoosrQr7Q27UiT0t8VJp4Nj/AoEsO+BKPfmkcZNl+6SdiZi yGM3djyxkg/crVIGinHFNzFqhtu9CGkoWfztx30mZ91N3tPFAv53tuECAwEAAaM3MDUwEgYD VR0TAQH/BAgwBgEB/wIBADAfBgNVHSMEGDAWoBRyScJzNMZV9At2coF+d/SH58ayDjANBgkq hkiG9w0BAQQFAAOBgQBC6u2LYX6h1FxSqTy9npx56AmLEoGtjx1aRu3xJSZbyK79eiEWzaAe O5czg/tONyool6ZI9SgYAiR8gHtTULX7b5r8bapcJkWoLzYiWNMbAgMf7pQ58P40WohLGz2M 89d+059wW3b22MTitjwknQkljFmx1Ivz/ASCDp4phmzF/zCCAy0wggKWoAMCAQICAQAwDQYJ KoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQ BgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsT H0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJz b25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhh d3RlLmNvbTAeFw05NjAxMDEwMDAwMDBaFw0yMDEyMzEyMzU5NTlaMIHRMQswCQYDVQQGEwJa QTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoT EVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERp dmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG 9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wgZ8wDQYJKoZIhvcNAQEBBQAD gY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0tDY97Et+FJXUodDpCLGMnn5V7S+9+ GYcdhuqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSGXq3qwF5269kUo11uenwMpUtV fwYZKX+emibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzARMA8GA1UdEwEB/wQFMAMB Af8wDQYJKoZIhvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41gWGGsJrtSNVwIzzD7 qEqWih9iQiOMFw/0umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3kmv0T9KbZfLH4 3F8jJgmRgHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooExggIqMIICJgIBATCB zzCByDELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVy YmFudmlsbGUxGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMTMwMQYDVQQLEypDZXJ0aWZp Y2F0ZSBTZXJ2aWNlcyBSU0EgSUsgMTk5OC4yLjI1IDg6MzUxOzA5BgNVBAMTMlRoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBSU0EgSXNzdWluZyBLZXkgMTk5OC4yLjI1AgIZbzAJBgUrDgMC GgUAoIGxMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTk4MDYw MjE0MDQxOFowIwYJKoZIhvcNAQkEMRYEFOVbrR9AueCHO90jvJU8WF6i2fk0MFIGCSqGSIb3 DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3 DQMCAgFAMA0GCCqGSIb3DQMCAgEoMA0GCSqGSIb3DQEBAQUABIGAHDbSNwbVTHixRtopOpkY G8e4PYC+8pHGmSaO3sRVnrR1Y8U0hUCYV4CzjXE9ODEQZJzRhr3I5iqdxYH9WD6xpd9jo5Ya AUrIPC+8q5dKjGvD74dHY9g8zHkIU170nT3T3GbV4WS/Fm80zKHCRfMb+YC5cY1bEB6WYIKC lThcAOI= --------------ms102567BBC160A89FD27FA5B8--