Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D12C8650642 for ; Mon, 14 Jul 2008 10:21:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79594-07 for ; Mon, 14 Jul 2008 10:21:03 -0300 (ADT) X-Greylist: delayed 00:07:44.060556 by SQLgrey-1.7.6 Received: from mail.dfki.de (corp-206.dfki.uni-sb.de [134.96.188.26]) by postgresql.org (Postfix) with ESMTP id 0738A65063F for ; Mon, 14 Jul 2008 10:21:08 -0300 (ADT) Received: from mail.dfki.de (localhost.dfki.uni-sb.de [127.0.0.1]) by localhost (Postfix) with ESMTP id 25AC4E47D4 for ; Mon, 14 Jul 2008 15:13:22 +0200 (CEST) Received: from [IPv6:::1] (dave.dfki.uni-sb.de [134.96.184.220]) by mail.dfki.de (Postfix) with ESMTP id 13FE6E4786 for ; Mon, 14 Jul 2008 15:13:22 +0200 (CEST) Message-Id: <53CDF98F-0AE1-49ED-A2A3-C3B1E2AF2E2E@activemath.org> From: Paul Libbrecht To: pgsql-admin@postgresql.org Content-Type: multipart/signed; boundary=Apple-Mail-37--636682881; micalg=sha1; protocol="application/pkcs7-signature" Mime-Version: 1.0 (Apple Message framework v926) Subject: accidental drop table recoverable? Date: Mon, 14 Jul 2008 15:13:21 +0200 X-Mailer: Apple Mail (2.926) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/120 X-Sequence-Number: 29730 --Apple-Mail-37--636682881 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hello fellow Postgres administrators, right now we experienced the loss of backups (due to wrong communication) and a list of accidental drop table statements (due to wrong database choice). We sure have clues how to avoid that in the future but right now we do not seem to find the solution to actually rollback this accidental drop table. Having searched around, the only recipe I found was: http://archives.postgresql.org/pgsql-docs/2004-12/msg00027.php which is pretty convoluted but seems like it could do the job. Now... is there a simpler way? I seem to see a fixed set of files in data/base that seemed to have been changed at the right time of the drop db... any chance to fiddle with them? thanks for hints. paul --Apple-Mail-37--636682881 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFzjCCAocw ggHwoAMCAQICEHpkMpnMryEmArSVLnJkS28wDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MTIxOTE0MzI0NFoXDTA4MTIxODE0MzI0 NFowcDEaMBgGA1UEBBMRTGliYnJlY2h0IEdvdXJkZXQxDTALBgNVBCoTBFBhdWwxHzAdBgNVBAMT FlBhdWwgTGliYnJlY2h0IEdvdXJkZXQxIjAgBgkqhkiG9w0BCQEWE3BhdWxAYWN0aXZlbWF0aC5v cmcwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMEY+jsbvfvg6uVnITE8Pd4RONXZvqxbynLR rgmnc5pCsv3UfvWjDZfbkX3Nb2OE4j2HSwY6Uhj2SOjh25ibMg2buR6ubgYXHvCbMngeoA2jDjvb dloET7Q0hynIMA281OfxTbEZzIlq55/xr0v8yKX3DyOXqnokERhOtay7RaCfAgMBAAGjMDAuMB4G A1UdEQQXMBWBE3BhdWxAYWN0aXZlbWF0aC5vcmcwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUF AAOBgQB52LXV/dsJaWBm8ScjEEn2/ecdVmKkQvggQFxsMHxCoIV70+OIoLYaJoO15NpdLuN7EPLE /vBBjoDp2A5KdxBAO8icv4LTOD3btE2oIcCz3SUffQtNTuUvFh9Z9OLGByLNRduw6RVm947pSNBG G+Qqd5XWQUxGci8HcsOQAOsLXjCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJ BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgG A1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMg RGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3 DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3 MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5 KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzAN BgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9 fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+ uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMB Af8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3 dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgG A1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcP f6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH 2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8x ggKPMIICiwIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAo UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQ emQymcyvISYCtJUucmRLbzAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcB MBwGCSqGSIb3DQEJBTEPFw0wODA3MTQxMzEzMjJaMCMGCSqGSIb3DQEJBDEWBBQdC1sNVjSqBtKu LivOV04F/vZ6HjCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0ECEHpkMpnMryEmArSVLnJkS28wgYcGCyqGSIb3DQEJEAILMXigdjBiMQsw CQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE AxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEHpkMpnMryEmArSVLnJkS28w DQYJKoZIhvcNAQEBBQAEgYAynfBn7oR04Xnl2XVcg4L4+6t37uM2TA3Qs898bHXR8tK9NhTjPHRE wA+hMcwG5Aw/OHMtz9zTY7BwVugyspskOfLGg6Bj5pItvyMSol32yL4vbK3NYdGnDDnSy8pHnO7A gdqVCEkWBqmr3fzS/+s1vaI/JCnqGc6QaPGU+HKT5AAAAAAAAA== --Apple-Mail-37--636682881--