Received: from smtp2.insync.net (smtp2.insync.net [209.113.65.176]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7UMAmf04310 for ; Thu, 30 Aug 2001 18:10:48 -0400 (EDT) (envelope-from hav@hav.com) Received: from hav.com (209-16-46-52.insync.net [209.16.46.52]) by smtp2.insync.net (8.11.4/8.11.4) with ESMTP id f7UMAen16711; Thu, 30 Aug 2001 17:10:40 -0500 (CDT) Message-ID: <3B8EB83C.4B5C5B5@hav.com> Date: Thu, 30 Aug 2001 17:03:40 -0500 From: "Horace A. Vallas, Jr." Organization: hav.Software X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U) X-Accept-Language: en,pdf MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql-docs@postgresql.org Subject: Re: doc for pg_dump References: Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms5BD3975B05D9FD26DD81663F" X-Archive-Number: 200108/41 X-Sequence-Number: 930 This is a cryptographically signed message in MIME format. --------------ms5BD3975B05D9FD26DD81663F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Peter - sorry if this is the wrong place to ask - but I was looking for some documentation of the pg_dump/pg_dumpall output format AND/OR some pointers on how to recognize and correctly handle index relations when grabbing all tables in a database. Anyway - the error I get when using pg_dump (or pg_dumpall) is... SET TRANSACTION command failed. Explanation from backend: \ 'ERROR: parser: parse error at or near "transaction"'. ... which, from what I have found searching the postgresql site, seems to indicate a mismatch in the version of pg_dump used - OR funky values in one or more tables. Either is certainly possible in my case, and I HAVE found some funky values (even a col type of "_text") in the exercise of writing a home-grown pg_dump. I think I have been able to correct such bad cases in the output I'm producing but I do not know the actual format of the pg_dump (or pg_dumpall) output and I cannot find any documentation for that format? Perhaps none exists? But I thought this was a good place to ask?? What I do now is just output a bunch of \connect/CREATE record pairs and then a bunch of "COPY ... from stdin" sections. I'm pretty much for sure that I need to include some handling of the index relations that exist in the current databases (really really don't want to think about having to redo all of those by hand 8-], but, at the moment, I'm recognizing them based on exceptions and simply skipping them because I'm not sure how to snarf them. Any pointers to docs or how-to's would be greatly appreciated. -- Wishing you an "OOBA OOBA" 21st Century!! Horace ...once known as "Kicker" :-) ================================================================ Horace Vallas hav.Software http://www.hav.com/ P.O. Box 354 hav@hav.com Richmond, Tx. 77406-0354 voice: 281-341-5035 USA fax: 281-341-5087 Thawte Web Of Trust Notary in SW Houston, Tx. http://www.hav.com/?content=/thawteWOTnotary.htm ================================================================ ...drop by and chat if I'm online http://www.hav.com/chat/ === === === === === === === === === === ==== What is a Vet? ... He is the barroom loudmouth, dumber than five wooden planks, whose overgrown frat-boy behavior is outweighed a hundred times in the cosmic scales by four hours of exquisite bravery near the 38th parallel. ... - Unknown ================================================================ Peter Eisentraut wrote: > > Horace A. Vallas, Jr. writes: > > > I'm writing to this address because the links for mail lists fail and > > said to write here if looking for docs and such... > > This is the list for writing docs. > > > I have some problem that is keeping me from being able to use > > pg_dump or pg_dumpall on a 6.4 version. What I have found mentioned > > about the error indicates either that my pg_xxxx applications are > > the wrong versions for the database (very possible) or that there > > is a problem with one or more table values (possibly but all databases > > and tables on the machine fail to dump). > > It would be more helpful to say what the error was rather than saying what > you think it meant. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter --------------ms5BD3975B05D9FD26DD81663F 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 MIIH5wYJKoZIhvcNAQcCoIIH2DCCB9QCAQExCzAJBgUrDgMCGgUAMAsGCSqG SIb3DQEHAaCCBbowggKJMIIB8qADAgECAgMDyQkwDQYJKoZIhvcNAQEEBQAw gZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0 aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwg UlNBIDIwMDAuOC4zMDAeFw0wMDEyMTIyMTMwMDhaFw0wMTEyMTIyMTMwMDha MFYxDzANBgNVBAQTBlZhbGxhczEPMA0GA1UEKhMGSG9yYWNlMRYwFAYDVQQD Ew1Ib3JhY2UgVmFsbGFzMRowGAYJKoZIhvcNAQkBFgtoYXZAaGF2LmNvbTCB nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA3OsA0zY07G8M5p/nuGm4vmZc 42tkGYBOchkqt+tbTRyBBC23NPCId1xfQrX+2VhMj186YecPrbvxtsD90ZiJ jllDz+1y9dQ6gekuUqZloVpJAsNm/Q/utomfNRmV8KppdmX3ZCtfX1hs1IzF iJepxnWI8KQ99BieAKM7YHKYu40CAwEAAaMoMCYwFgYDVR0RBA8wDYELaGF2 QGhhdi5jb20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQDTxQEs L8GZV2H/8KblxdJr1RzZUUrs9WONKHvWaqfWOMt0gMIbGw7w6y8L0Kirc1Vl JAUEwJP7kNU2P01mY+sOYCQQ4hszhsMnaInTn7QeyyG/x9H9DXm1azoAxCA3 iW9X2pUqwx/JlG4b4rV8o/UfePfVR6ypD3E/UaRQ8uAgVDCCAykwggKSoAMC AQICAQwwDQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQI EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMR VGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2Vy dmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhh d3RlLmNvbTAeFw0wMDA4MzAwMDAwMDBaFw0wMjA4MjkyMzU5NTlaMIGSMQsw CQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlD YXBlIFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNh dGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAy MDAwLjguMzAwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAN4zMqZjxwkl RT7SbngnZ4HF2ogZgpcO40QpimM1Km1wPPrcrvfudG8wvDOQf/k0caCjbZjx w0+iZdsN+kvx1t1hpfmFzVWaNRqdknWoJ67Ycvm6AvbXsJHeHOmr4BgDqHxD QlBRh4M88Dm0m1SKE4f/s5udSWYALQmJ7JRr6aFpAgMBAAGjTjBMMCkGA1Ud EQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwxLTI5NzASBgNVHRMB Af8ECDAGAQH/AgEAMAsGA1UdDwQEAwIBBjANBgkqhkiG9w0BAQQFAAOBgQBz G28mZYv/FTRLWWKK7US+ScfoDbuPuQ1qJipihB+4h2N0HG23zxpTkUvhzeY4 2e1Q9DpsNJKs5pKcbsEjAcIJp+9LrnLdBmf1UG8uWLi2C8FQV7XsHNfvF7bV iJu3ooga7TlbOX00/LaWGCVNavSdxcORL6mWuAU8Uvzd6WIDSDGCAfUwggHx AgEBMIGaMIGSMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBl MRIwEAYDVQQHEwlDYXBlIFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UE CxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy ZWVtYWlsIFJTQSAyMDAwLjguMzACAwPJCTAJBgUrDgMCGgUAoIGxMBgGCSqG SIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAxMDgzMDIy MDM0MVowIwYJKoZIhvcNAQkEMRYEFGKe6Qvzj/qhrEov7dUqiorG1ZkRMFIG CSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMAcG BSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEoMA0GCSqGSIb3 DQEBAQUABIGAmnN8DLELg2uoDge+3eA4Ts+/lohsjm4v2umxOLhaY9xZqYcd CFD574ltc6ZiaJ1Fw94YRnDxORXjGMDMC/t1HIHJ4tc5qnA4xwUbqOijgeje 8uzxocnVbUiRYtQOXd7dx1Eoiwl3vbpF47YoA19y9NmoHSVWhD++MIT5ovjS LTA= --------------ms5BD3975B05D9FD26DD81663F--