X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7DD6FD1D163 for ; Fri, 21 Nov 2003 21:18:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 90975-01 for ; Fri, 21 Nov 2003 17:17:49 -0400 (AST) Received: from mail5.bluewin.ch (mail5.bluewin.ch [195.186.1.207]) by svr1.postgresql.org (Postfix) with ESMTP id 1C00FD1B4E6 for ; Fri, 21 Nov 2003 17:17:47 -0400 (AST) Received: from bluewin.ch (62.203.91.31) by mail5.bluewin.ch (Bluewin AG 7.0.024) id 3FBC808D00045DCB; Fri, 21 Nov 2003 21:16:25 +0000 Message-ID: <3FBE8122.9080905@bluewin.ch> Date: Fri, 21 Nov 2003 22:18:26 +0100 From: Oli Sennhauser User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en, de-ch MIME-Version: 1.0 To: Tom Lane Cc: Jan Wieck , Alvaro Herrera , Christopher Kings-Lynne , Peter Eisentraut , PostgreSQL Development Subject: Re: Release cycle length References: <20031117202346.M731@ganymede.hub.org> <3FBB7F20.8050005@Yahoo.com> <6400.1069359578@sss.pgh.pa.us> <3FBD6CAA.7040500@familyhealth.com.au> <20031121130359.GE26392@dcc.uchile.cl> <3FBE5A46.4090102@Yahoo.com> <23265.1069441708@sss.pgh.pa.us> In-Reply-To: <23265.1069441708@sss.pgh.pa.us> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms080702060900010702090500" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/1203 X-Sequence-Number: 47491 This is a cryptographically signed message in MIME format. --------------ms080702060900010702090500 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hello hackers Sorry when I am talking to the gurus... There is a database, which has a concept called "Transportable Tablespace" (TTS). Would it not be a verry easy and fast solution to just do this with the Tables, Index and all non catalog related files. - You create a new db cluster (e.g 8.0). - Generate a TTS export skript. - Shut the (old) db-cluster (files should be consistent now, ev. do something with the log files before). - Move the files (eventually not needed) and - plug it in to the new db cluster (via the export skript). Expected downtime (without moving data files) 5-10 minutes. Regards Oli ------------------------------------------------------- Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail oli.sennhauser@bluewin.ch Website http://mypage.bluewin.ch/shinguz/PostgreSQL/ Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import --------------ms080702060900010702090500 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 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIK0jCCAmUwggHOoAMCAQICCQCsJKpLsmk5ZzANBgkqhkiG9w0BAQUF ADBwMSUwIwYDVQQDExxTd2lzc1NpZ24gUGVyc29uYWwgQ2xhc3MxIENBMSYw JAYJKoZIhvcNAQkBFhdjbGFzczEtY2FAU3dpc3NTaWduLmNvbTESMBAGA1UE ChMJU3dpc3NTaWduMQswCQYDVQQGEwJDSDAeFw0wMzEwMTYxODIxMjNaFw0w NDEwMTYxODIxMjNaMGIxNjA0BgNVBAMULVN3aXNzU2lnbiBCcm9uemUgSUQg b2xpLnNlbm5oYXVzZXJAYmx1ZXdpbi5jaDEoMCYGCSqGSIb3DQEJARYZb2xp LnNlbm5oYXVzZXJAYmx1ZXdpbi5jaDBcMA0GCSqGSIb3DQEBAQUAA0sAMEgC QQCxt+SmHgsTzgBw7MY+KYwNwfurrZWoUSqm6Vdw5Z9aQDuRgZ/+OhL6dDXK VHpsyUiG6tzmqcEC8LkIpKv20YZxAgMBAAGjWTBXMCQGA1UdEQQdMBuBGW9s aS5zZW5uaGF1c2VyQGJsdWV3aW4uY2gwDgYDVR0PAQH/BAQDAgWgMB8GA1Ud IwQYMBaAFO30uEqBiizjCfrm+jE/TLQfSf6EMA0GCSqGSIb3DQEBBQUAA4GB AIK6w1rQif2IvpmKBjZf7fSp2FryojtHgNnKAlzfnwflZc0xcyqbRCC2vo0C psbvUBlx/t0pSwb0OVuD/uzvqTs7clq3eRH7VJL8LLS2OrJv7gI3jJVRD/oP 7m0mD/qmj0boSr9ilb5WFjXAVwsgJKuv0iHcAFJTTmj8RCZmWIVhMIICZTCC Ac6gAwIBAgIJAKwkqkuyaTlnMA0GCSqGSIb3DQEBBQUAMHAxJTAjBgNVBAMT HFN3aXNzU2lnbiBQZXJzb25hbCBDbGFzczEgQ0ExJjAkBgkqhkiG9w0BCQEW F2NsYXNzMS1jYUBTd2lzc1NpZ24uY29tMRIwEAYDVQQKEwlTd2lzc1NpZ24x CzAJBgNVBAYTAkNIMB4XDTAzMTAxNjE4MjEyM1oXDTA0MTAxNjE4MjEyM1ow YjE2MDQGA1UEAxQtU3dpc3NTaWduIEJyb256ZSBJRCBvbGkuc2VubmhhdXNl ckBibHVld2luLmNoMSgwJgYJKoZIhvcNAQkBFhlvbGkuc2VubmhhdXNlckBi bHVld2luLmNoMFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALG35KYeCxPOAHDs xj4pjA3B+6utlahRKqbpV3Dln1pAO5GBn/46Evp0NcpUemzJSIbq3OapwQLw uQikq/bRhnECAwEAAaNZMFcwJAYDVR0RBB0wG4EZb2xpLnNlbm5oYXVzZXJA Ymx1ZXdpbi5jaDAOBgNVHQ8BAf8EBAMCBaAwHwYDVR0jBBgwFoAU7fS4SoGK LOMJ+ub6MT9MtB9J/oQwDQYJKoZIhvcNAQEFBQADgYEAgrrDWtCJ/Yi+mYoG Nl/t9KnYWvKiO0eA2coCXN+fB+VlzTFzKptEILa+jQKmxu9QGXH+3SlLBvQ5 W4P+7O+pOztyWrd5EftUkvwstLY6sm/uAjeMlVEP+g/ubSYP+qaPRuhKv2KV vlYWNcBXCyAkq6/SIdwAUlNOaPxEJmZYhWEwggK6MIICI6ADAgECAghscFj+ 9LG+HzANBgkqhkiG9w0BAQUFADBnMRwwGgYDVQQDExNTd2lzc1NpZ24gQ2xh c3MxIENBMSYwJAYJKoZIhvcNAQkBFhdjbGFzczEtY2FAU3dpc3NTaWduLmNv bTESMBAGA1UEChMJU3dpc3NTaWduMQswCQYDVQQGEwJDSDAeFw0wMjEwMjQx MzM0MTZaFw0wNDEwMjQxMjAwMTRaMHAxJTAjBgNVBAMTHFN3aXNzU2lnbiBQ ZXJzb25hbCBDbGFzczEgQ0ExJjAkBgkqhkiG9w0BCQEWF2NsYXNzMS1jYUBT d2lzc1NpZ24uY29tMRIwEAYDVQQKEwlTd2lzc1NpZ24xCzAJBgNVBAYTAkNI MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCvb8N37MzyZnhRvbgSYCRa OYbCqH5/o9yoq3kyHP50e+QJVzvRZj9vw3GeDnhl+IrjmC0oPcXqmCgnvmZ3 2AlQITCU7jAfTKHjk2GZ8cFGgFTuR0lTbv0AfgMmYXYxoV0hu4v6WpDsigNx J6q5Pt6rWEFkOLu7IvgkBZ2RKQdz5wIDAQABo2YwZDAOBgNVHQ8BAf8EBAMC AQYwEgYDVR0TAQH/BAgwBgEB/wIBADAdBgNVHQ4EFgQU7fS4SoGKLOMJ+ub6 MT9MtB9J/oQwHwYDVR0jBBgwFoAUnKEHkQJI5q/Y1/5jBjNfheKPtbMwDQYJ KoZIhvcNAQEFBQADgYEAFMJrIPCoeXZxquyk6xqqflC/W+W3y5SNVzdASOjr tTzREC1oRwI36eqwMuAkbCr7znDV8rp2OC5S/DNw360FUvro/MjL2Ajztkum V/EF6enEAMbzCjBzJM8EfYEE3XyDyy5SzOtU5VPDMHOe9lPVOZ+1v2FpVLlK RW9Fxy6EG+wwggM+MIICJqADAgECAghVy6lgNCVu5DANBgkqhkiG9w0BAQUF ADB2MQswCQYDVQQGEwJDSDESMBAGA1UEChMJU3dpc3NTaWduMTIwMAYDVQQD EylTd2lzc1NpZ24gQ0EgKFJTQSBJSyBNYXkgNiAxOTk5IDE4OjAwOjU4KTEf MB0GCSqGSIb3DQEJARYQY2FAU3dpc3NTaWduLmNvbTAeFw0wMjEwMjQxMjAw MTRaFw0wNDEwMjQxMjAwMTRaMGcxHDAaBgNVBAMTE1N3aXNzU2lnbiBDbGFz czEgQ0ExJjAkBgkqhkiG9w0BCQEWF2NsYXNzMS1jYUBTd2lzc1NpZ24uY29t MRIwEAYDVQQKEwlTd2lzc1NpZ24xCzAJBgNVBAYTAkNIMIGfMA0GCSqGSIb3 DQEBAQUAA4GNADCBiQKBgQDJHZUwOQhgCPyjvVNBeMocJ/hsmImGuFFIa/QQ t31ExbzSfe58xgItElgqgPbMFevbVldcf2gafVMihh3aIYPcNTsDFn9FeiVP S7zohjKFVQxxDjprzCkixPAF9vuY9IKfRUoae0rDM6T2D5a2KdgtrJTgUu+y k0VjFd1hfHW5qwIDAQABo2MwYTAOBgNVHQ8BAf8EBAMCAQYwDwYDVR0TAQH/ BAUwAwEB/zAdBgNVHQ4EFgQUnKEHkQJI5q/Y1/5jBjNfheKPtbMwHwYDVR0j BBgwFoAUltdxzTkq1PyIsYqrU3hp749HfhYwDQYJKoZIhvcNAQEFBQADggEB ADxcvW2sVFFI48Pf9Bss++/M+a3sZ56EOdOcdYHhkk1Ax/tUsLCnjscKWHwj iJo0/ZunK070iwpSIbJAGDFXERx1VZZ3unUlFLANAgddIXAbIuvij5VoGZbG 6UiFxMTbcYxO1yYM/iQVSwB7NBKqUcTdHyYyw7oPh9BIayrYTkLBy2FPKe21 CAFGa9Ek8D/RyL6YsFgLB2neXqIxdIqID+QUufzKCUGOdgbc3Tvk8im3vR8C RVBxvZhY9I8+NIQR+nBPMoVp2PnDnp5sNLNGLIdKoZJXlQ2+8+fjnB/vrjYp Tn9W3nJEgJsbFScH4k+urq8TjK+QPpamJjySIikcJG8xggK3MIICswIBATB9 MHAxJTAjBgNVBAMTHFN3aXNzU2lnbiBQZXJzb25hbCBDbGFzczEgQ0ExJjAk BgkqhkiG9w0BCQEWF2NsYXNzMS1jYUBTd2lzc1NpZ24uY29tMRIwEAYDVQQK EwlTd2lzc1NpZ24xCzAJBgNVBAYTAkNIAgkArCSqS7JpOWcwCQYFKw4DAhoF AKCCAdEwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUx DxcNMDMxMTIxMjExODI2WjAjBgkqhkiG9w0BCQQxFgQUCQxPgduWPwWCFHSN GalRxWI4hdUwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0DBzAOBggqhkiG 9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwIC ASgwgYwGCSsGAQQBgjcQBDF/MH0wcDElMCMGA1UEAxMcU3dpc3NTaWduIFBl cnNvbmFsIENsYXNzMSBDQTEmMCQGCSqGSIb3DQEJARYXY2xhc3MxLWNhQFN3 aXNzU2lnbi5jb20xEjAQBgNVBAoTCVN3aXNzU2lnbjELMAkGA1UEBhMCQ0gC CQCsJKpLsmk5ZzCBjgYLKoZIhvcNAQkQAgsxf6B9MHAxJTAjBgNVBAMTHFN3 aXNzU2lnbiBQZXJzb25hbCBDbGFzczEgQ0ExJjAkBgkqhkiG9w0BCQEWF2Ns YXNzMS1jYUBTd2lzc1NpZ24uY29tMRIwEAYDVQQKEwlTd2lzc1NpZ24xCzAJ BgNVBAYTAkNIAgkArCSqS7JpOWcwDQYJKoZIhvcNAQEBBQAEQD38ExGbCjlf pGtQoLd1yiaiUSfwpLR3f0kcqRdho2SIIVTZyuy76kmdHuSmcG73kxmIKS1d NE8Uq/DgH4+HN+IAAAAAAAA= --------------ms080702060900010702090500--