Received: from smtp2.insync.net (smtp2.insync.net [209.113.65.176]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7U00Zf62339 for ; Wed, 29 Aug 2001 20:00:36 -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 f7U00Wn07664; Wed, 29 Aug 2001 19:00:32 -0500 (CDT) Message-ID: <3B8D8075.4369A15D@hav.com> Date: Wed, 29 Aug 2001 18:53:25 -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: pgsql-docs@postgresql.org, Horace Vallas Subject: doc for pg_dump Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms712C2953071EBCE571751261" X-Archive-Number: 200108/28 X-Sequence-Number: 920 This is a cryptographically signed message in MIME format. --------------ms712C2953071EBCE571751261 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm writing to this address because the links for mail lists fail and said to write here if looking for docs and such... 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). Trying to move to a 7.0 version and simply moving the data dir from the old machine also will not seem to work on the new... SOOoooo - I guess I have to write my own pg_dump in order to get the old data out --- but I don't know exactly what the format of pg_dump and pg_dumpall might be --- nor which tables will actually be dumped (for example, I can the the various pg_whatever tables in a base, but I also see a bunch of tables named "regf12" and I have no idea what those are or whether I should dump them in my pg_dump program) Thanks for any pointers and/or docs to help me get this right -- there's a BUNCH of data that can be lost if I cannot get it out of the old database. -- 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 ================================================================ --------------ms712C2953071EBCE571751261 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 SIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAxMDgyOTIz NTMyNlowIwYJKoZIhvcNAQkEMRYEFPe6W52xXaE0uppafOtGKbDXdOkfMFIG CSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMAcG BSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEoMA0GCSqGSIb3 DQEBAQUABIGAp8cJ4YIMFfB/pPPWLpzmrgBqjZ3/mb9dZXrDecwXqxjCvIDN GKTl5/u1oEHOa8AJoEcTWzZvQBYz5XkO/SaAqx1W6RUeQ3ccTozrVamYYKME IKIc6UPd+h/MP7T852UeSuqJJbGIMZw55LPc7aZywcZyXkWpVxPC6Xnhd/KM zas= --------------ms712C2953071EBCE571751261--