X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ACE6F3A573C for ; Wed, 26 Jan 2005 13:13:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15787-04 for ; Wed, 26 Jan 2005 13:13:34 +0000 (GMT) Received: from smtp.ualg.pt (unknown [193.136.224.8]) by svr1.postgresql.org (Postfix) with ESMTP id 21B443A5736 for ; Wed, 26 Jan 2005 13:13:35 +0000 (GMT) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 9920D4BC3A for ; Wed, 26 Jan 2005 14:13:11 +0000 (WET) Received: from smtp.ualg.pt ([127.0.0.1]) by localhost (smtp.ualg.pt [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 14362-10 for ; Wed, 26 Jan 2005 14:13:09 +0000 (WET) Received: from [10.10.20.85] (raio.ualg.pt [10.10.20.85]) by smtp.ualg.pt (Postfix) with ESMTP id CE0C74BC9C for ; Wed, 26 Jan 2005 14:13:08 +0000 (WET) Message-ID: <41F79758.2030802@ualg.pt> Date: Wed, 26 Jan 2005 13:12:56 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050105 Debian/1.7.5-1 X-Accept-Language: en-pt MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Restore postgres database problem References: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> In-Reply-To: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms070505070608010004020905" X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/268 X-Sequence-Number: 16127 This is a cryptographically signed message in MIME format. --------------ms070505070608010004020905 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Which options did you use to dump data? And which options did you use to restore it? Please submit the command lines used. Luis Sousa Inpreet Singh wrote: > Hello, > I am using postgres 7.3.4. I am trying to restore database dump using > psql command but getting following error. > > *Taken Dump :* /usr/bin/pg_dumpall > /home/inpreet/postgres.sql > *Restoring Dump :* su - postgres > /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql > > but getting error > ERROR: copy: line 32, Bad date external representation '\N > lost synchronization with server, resetting connection > > Please tell me which way to go. > > Thanks a*n*d Regards > *Inpreet Singh* > > --------------ms070505070608010004020905 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 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJ1jCC BOcwggSRoAMCAQICChKPTqUAAgAAAMUwDQYJKoZIhvcNAQEFBQAwgaExHDAaBgkqhkiG9w0B CQEWDWRyb3NhQHVhbGcucHQxCzAJBgNVBAYTAlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYD VQQHEwRGYXJvMSAwHgYDVQQKExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEgMB4GA1UECxMX U2Vydmljb3MgZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVhbE5ldDAeFw0wNDA2MzAxMzQ4 MDZaFw0wNTA2MzAxMzQ4MDZaMEgxHjAcBgkqhkiG9w0BCQEWD2xsc291c2FAdWFsZy5wdDEm MCQGA1UEAxMdTFVJUyBNSUdVRUwgTElNQSBTT1VTQSAoMTY3NCkwggEiMA0GCSqGSIb3DQEB AQUAA4IBDwAwggEKAoIBAQDcUYAS5FaaqQWOwhPWXpgjxgxhCz1ENCm7dENtTr5mJytdhVXB z7XY9eoRgGcKlNUQC9q56jww2n08gt9em7S2nEcj8BV7TWIf4wkU3YyF6BPAhRL4Km7+P7s7 szVGPjcs2mp7by7a5T51CI2cFkSqw2bbr+QGdEytfTedPXgC751EbaRNpO/sSjtzNz+s1jGK fUHVJrZbtQdB2k0UNfh3s7mAYTGEnNAXSj+xI/5mr/lw9k93M+TcRwZrLMHFJGT7hytmUs7w 7w7ubIo4Rs9kl2KEnjY3JwIdldWg9EfZKH/ehI6XbwKKLHGqvo+F8k3MWF9GGhVo2leJKul1 A67pAgMBAAGjggI5MIICNTAdBgNVHQ4EFgQU36rA18vDYUwKmiFfzElm5cJAXBkwgd0GA1Ud IwSB1TCB0oAUDlemmBHtWUTtGV2FEEod0l87V/qhgaekgaQwgaExHDAaBgkqhkiG9w0BCQEW DWRyb3NhQHVhbGcucHQxCzAJBgNVBAYTAlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYDVQQH EwRGYXJvMSAwHgYDVQQKExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEgMB4GA1UECxMXU2Vy dmljb3MgZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVhbE5ldIIQS1dGfnTvEatHwdnJY6a3 STA8BgNVHR8ENTAzMDGgL6AthitodHRwOi8vd3d3LnNpLnVhbGcucHQvQ2VydEVucm9sbC9V YWxOZXQuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5zaS51 YWxnLnB0L0NlcnRFbnJvbGwvcHVjY2luaS51YWxnLnB0X1VhbE5ldCgyKS5jcnQwDAYDVR0T AQH/BAIwADALBgNVHQ8EBAMCBaAwKQYDVR0lBCIwIAYKKwYBBAGCNwoDBAYIKwYBBQUHAwQG CCsGAQUFBwMCMBcGCSsGAQQBgjcUAgQKHggAVQBzAGUAcjA7BgNVHREENDAyoB8GCisGAQQB gjcUAgOgEQwPbGxzb3VzYUB1YWxnLnB0gQ9sbHNvdXNhQHVhbGcucHQwDQYJKoZIhvcNAQEF BQADQQBb4RvnTkyDA+1CU+1x8/nAjpulQ8m63FWWi8FIkPPiU1xXkg5R6+wIut9+6A1HoWh+ 5CkP1pVZtQUi+4/F5Zc4MIIE5zCCBJGgAwIBAgIKEo9OpQACAAAAxTANBgkqhkiG9w0BAQUF ADCBoTEcMBoGCSqGSIb3DQEJARYNZHJvc2FAdWFsZy5wdDELMAkGA1UEBhMCUFQxEDAOBgNV BAgTB0FsZ2FydmUxDTALBgNVBAcTBEZhcm8xIDAeBgNVBAoTF1VuaXZlcnNpZGFkZSBkbyBB bGdhcnZlMSAwHgYDVQQLExdTZXJ2aWNvcyBkZSBJbmZvcm1hdGljYTEPMA0GA1UEAxMGVWFs TmV0MB4XDTA0MDYzMDEzNDgwNloXDTA1MDYzMDEzNDgwNlowSDEeMBwGCSqGSIb3DQEJARYP bGxzb3VzYUB1YWxnLnB0MSYwJAYDVQQDEx1MVUlTIE1JR1VFTCBMSU1BIFNPVVNBICgxNjc0 KTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBANxRgBLkVpqpBY7CE9ZemCPGDGEL PUQ0Kbt0Q21OvmYnK12FVcHPtdj16hGAZwqU1RAL2rnqPDDafTyC316btLacRyPwFXtNYh/j CRTdjIXoE8CFEvgqbv4/uzuzNUY+NyzaantvLtrlPnUIjZwWRKrDZtuv5AZ0TK19N509eALv nURtpE2k7+xKO3M3P6zWMYp9QdUmtlu1B0HaTRQ1+HezuYBhMYSc0BdKP7Ej/mav+XD2T3cz 5NxHBmsswcUkZPuHK2ZSzvDvDu5sijhGz2SXYoSeNjcnAh2V1aD0R9kof96EjpdvAooscaq+ j4XyTcxYX0YaFWjaV4kq6XUDrukCAwEAAaOCAjkwggI1MB0GA1UdDgQWBBTfqsDXy8NhTAqa IV/MSWblwkBcGTCB3QYDVR0jBIHVMIHSgBQOV6aYEe1ZRO0ZXYUQSh3SXztX+qGBp6SBpDCB oTEcMBoGCSqGSIb3DQEJARYNZHJvc2FAdWFsZy5wdDELMAkGA1UEBhMCUFQxEDAOBgNVBAgT B0FsZ2FydmUxDTALBgNVBAcTBEZhcm8xIDAeBgNVBAoTF1VuaXZlcnNpZGFkZSBkbyBBbGdh cnZlMSAwHgYDVQQLExdTZXJ2aWNvcyBkZSBJbmZvcm1hdGljYTEPMA0GA1UEAxMGVWFsTmV0 ghBLV0Z+dO8Rq0fB2cljprdJMDwGA1UdHwQ1MDMwMaAvoC2GK2h0dHA6Ly93d3cuc2kudWFs Zy5wdC9DZXJ0RW5yb2xsL1VhbE5ldC5jcmwwWgYIKwYBBQUHAQEETjBMMEoGCCsGAQUFBzAC hj5odHRwOi8vd3d3LnNpLnVhbGcucHQvQ2VydEVucm9sbC9wdWNjaW5pLnVhbGcucHRfVWFs TmV0KDIpLmNydDAMBgNVHRMBAf8EAjAAMAsGA1UdDwQEAwIFoDApBgNVHSUEIjAgBgorBgEE AYI3CgMEBggrBgEFBQcDBAYIKwYBBQUHAwIwFwYJKwYBBAGCNxQCBAoeCABVAHMAZQByMDsG A1UdEQQ0MDKgHwYKKwYBBAGCNxQCA6ARDA9sbHNvdXNhQHVhbGcucHSBD2xsc291c2FAdWFs Zy5wdDANBgkqhkiG9w0BAQUFAANBAFvhG+dOTIMD7UJT7XHz+cCOm6VDybrcVZaLwUiQ8+JT XFeSDlHr7Ai6337oDUehaH7kKQ/WlVm1BSL7j8XllzgxggQXMIIEEwIBATCBsDCBoTEcMBoG CSqGSIb3DQEJARYNZHJvc2FAdWFsZy5wdDELMAkGA1UEBhMCUFQxEDAOBgNVBAgTB0FsZ2Fy dmUxDTALBgNVBAcTBEZhcm8xIDAeBgNVBAoTF1VuaXZlcnNpZGFkZSBkbyBBbGdhcnZlMSAw HgYDVQQLExdTZXJ2aWNvcyBkZSBJbmZvcm1hdGljYTEPMA0GA1UEAxMGVWFsTmV0AgoSj06l AAIAAADFMAkGBSsOAwIaBQCgggI7MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZI hvcNAQkFMQ8XDTA1MDEyNjEzMTI1NlowIwYJKoZIhvcNAQkEMRYEFEpWfoIpk9cup+2zMGzl e3D9HK3RMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0G CCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMIHBBgkrBgEEAYI3EAQxgbMw gbAwgaExHDAaBgkqhkiG9w0BCQEWDWRyb3NhQHVhbGcucHQxCzAJBgNVBAYTAlBUMRAwDgYD VQQIEwdBbGdhcnZlMQ0wCwYDVQQHEwRGYXJvMSAwHgYDVQQKExdVbml2ZXJzaWRhZGUgZG8g QWxnYXJ2ZTEgMB4GA1UECxMXU2Vydmljb3MgZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVh bE5ldAIKEo9OpQACAAAAxTCBwwYLKoZIhvcNAQkQAgsxgbOggbAwgaExHDAaBgkqhkiG9w0B CQEWDWRyb3NhQHVhbGcucHQxCzAJBgNVBAYTAlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYD VQQHEwRGYXJvMSAwHgYDVQQKExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEgMB4GA1UECxMX U2Vydmljb3MgZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVhbE5ldAIKEo9OpQACAAAAxTAN BgkqhkiG9w0BAQEFAASCAQAY5iVsT6TI6Xe0HOnwbok7TwPv9Z5wEeOMGqwXGb1QvhOPEW9h Sf5QYAJR5OXMWLUYUEO7NB2wbVzeeSBOAWOV7OJj4nPy2XGNGBfa7cleVxdKT4iKfm7nAsT3 qT7yvQivqwOkCgLUVk0HnSbJCKd7AcOnPo3GOxWEuZSOcmXnp0CBdpJa6BOXgyEas7YvvSvd G8Il+vQsJwcRlT2V6vaHKPgCkzLvhIAGza4/805pTV+6jutl6MGiYM2gHU9IxQGcGHltPTxX IFA2mU6kinoPzeptbQm0Rwc+bT7iIsx35gcV9u24DPQsgHH8AVadbPTsEVw0oK1WSxDI0dYB QRyhAAAAAAAA --------------ms070505070608010004020905--