Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6159C64FCF3 for ; Wed, 27 Aug 2008 17:42:26 -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 86288-03 for ; Wed, 27 Aug 2008 17:42:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 24D3C64FCDA for ; Wed, 27 Aug 2008 17:42:23 -0300 (ADT) Received: from [192.168.178.24] (p548B20E8.dip0.t-ipconnect.de [84.139.32.232]) by service-web.de (Postfix) with ESMTP id A7914E819D; Wed, 27 Aug 2008 22:42:19 +0200 (CEST) Message-ID: <48B5BC2A.5070104@wildenhain.de> Date: Wed, 27 Aug 2008 22:42:18 +0200 From: Tino Wildenhain User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: Phoenix Kiula Cc: PG-General Mailing List Subject: Re: Dumping/Restoring with constraints? References: In-Reply-To: Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms000207040602030409020802" 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: 200808/975 X-Sequence-Number: 136805 This is a cryptographically signed message in MIME format. --------------ms000207040602030409020802 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi, Phoenix Kiula wrote: > Hello. I have a database dump. With data and schema, which includes > all the constraints and rules. But it seems the pg_dumpall command > does not copy data in such a way that foreign keys are satisfied upon > restoring. Because tables are inter-related, importing them keep > giving errors and eventually no data is imported. Neither pg_dumpall > nor pg_restore seems to have a "without constraints" or "delay > constraints check" type command. What am I missing? Thanks for any > advice. Apart from disabling triggers temporarely, if you have enough space in xlog, you could try to add BEGIN work; to the start of the restore SQL and COMMIT; a the end. Regards Tino --------------ms000207040602030409020802 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 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJBzCC At4wggJHoAMCAQICEFhzOX0yh1CxCcTpCoXqqXkwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDQzMDE5MzY1NFoX DTA5MDQzMDE5MzY1NFowRDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEhMB8G CSqGSIb3DQEJARYSdGlub0B3aWxkZW5oYWluLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8A MIIBCgKCAQEAwdJKlg6wlxFdjMOMON992A1RRg7jfZJWPuHXAb0VOAM4htilnwfJVdk9ARnY Jbp6uDbR7Npm3ZqrqfRlI2uPXVVj00L8JHMQmeS36ICknk7aG93yTBYWBf1T2EadP2KFszSM EmfjxV7vc55BgP1Pj9eB0ceJOT8dOWl5c342giavCWOg0xDQAKUd+BpEe3r/TnLuCUo0MIQF DAO8nw8NyKJG82u0Y8aHW5wpLS0S0E+GeVd5RP4cB1GDCiH8Bi7MvOSsFBv7tSYIn/3fJH+Q 979UGd1nhO4H+sK43mjt+gXpR7+5A3ZGy+O/5gsArCTMwGZmLZ4hd3VhPCT7TRtLmQIDAQAB oy8wLTAdBgNVHREEFjAUgRJ0aW5vQHdpbGRlbmhhaW4uZGUwDAYDVR0TAQH/BAIwADANBgkq hkiG9w0BAQUFAAOBgQA3ROUGts7nkRx1uE+rbeuhfckv9bLIL6lz19tRwTeTOYanXrqDzwhn UUMyd7oDFUIZe/lxtLshkUD4p/omXtIzCCx6M5yIWlYMzKTeB4qQpQ14huovXzXQZbWiTOwA 3+ZU+rVC7CX47dEEKuKHwAvpurNUGikHlGuYkMSMCly61zCCAt4wggJHoAMCAQICEFhzOX0y h1CxCcTpCoXqqXkwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDQzMDE5MzY1NFoXDTA5MDQzMDE5MzY1NFowRDEf MB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEhMB8GCSqGSIb3DQEJARYSdGlub0B3 aWxkZW5oYWluLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwdJKlg6wlxFd jMOMON992A1RRg7jfZJWPuHXAb0VOAM4htilnwfJVdk9ARnYJbp6uDbR7Npm3ZqrqfRlI2uP XVVj00L8JHMQmeS36ICknk7aG93yTBYWBf1T2EadP2KFszSMEmfjxV7vc55BgP1Pj9eB0ceJ OT8dOWl5c342giavCWOg0xDQAKUd+BpEe3r/TnLuCUo0MIQFDAO8nw8NyKJG82u0Y8aHW5wp LS0S0E+GeVd5RP4cB1GDCiH8Bi7MvOSsFBv7tSYIn/3fJH+Q979UGd1nhO4H+sK43mjt+gXp R7+5A3ZGy+O/5gsArCTMwGZmLZ4hd3VhPCT7TRtLmQIDAQABoy8wLTAdBgNVHREEFjAUgRJ0 aW5vQHdpbGRlbmhhaW4uZGUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQA3ROUG ts7nkRx1uE+rbeuhfckv9bLIL6lz19tRwTeTOYanXrqDzwhnUUMyd7oDFUIZe/lxtLshkUD4 p/omXtIzCCx6M5yIWlYMzKTeB4qQpQ14huovXzXQZbWiTOwA3+ZU+rVC7CX47dEEKuKHwAvp urNUGikHlGuYkMSMCly61zCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJ BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEa MBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2Vy dmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTEr MCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcw MDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUg Q29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065ypla HmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FW y688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEE QB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2 oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3Js MAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0x MzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYf qi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9l X5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggNkMIIDYAIBATB2 MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQu MSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQWHM5fTKH ULEJxOkKheqpeTAJBgUrDgMCGgUAoIIBwzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJBTEPFw0wODA4MjcyMDQyMThaMCMGCSqGSIb3DQEJBDEWBBSdWfN2HKyKt2Kx hzMYVaxWh4bS6jBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIA gDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCBhQYJKwYBBAGCNxAE MXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEFhz OX0yh1CxCcTpCoXqqXkwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEFhzOX0yh1CxCcTpCoXqqXkwDQYJKoZIhvcN AQEBBQAEggEAuHZhQYmfXI2RRCs2T0FHIDTU0qENaBVaUZL2VQNJlbFjnVDy/7Zmr8HSTO3G GScZnZuQba3FGrR1CCxmdyFWeU9BWwgj0gUIsW55tAvfRlEt2qf2rlBYxJnsGVwyH+QBYqrK 4LbPhwA7VoElNE2wX7vBCQGe+43UTqiDe/wO1Bcufb6KZUUAaCzcAjsf+fToCjN1+Tas8r1V 7Y5MVwJ48Sg4s3a4fxlMe8A3KaxUNc1UE2gdnCHL0QRNkETpqySAkeA/oNCPBLuXkqi6t7/O k99X6it4S//sHt3MUBzpJEKHiBpNZQMR0sNkHi0ktDOLMq9/AQdBRCG1p7EjPy2JdQAAAAAA AA== --------------ms000207040602030409020802--