At 03:54 PM 9/09/2002 -0700, Laurette Cisneros wrote: >Ok, I made the changes in the compressed pg_dump file.
That's probably a very bad idea. It's a little more long-winded, but try: pg_restore -l dumpfile > dump1.lis copy dump1.lis to dump2.lis delete everything from dump1.lis at and after the definition that causes the problem. delete everything from dump2.lis at and before the definition that causes the problem. pg_restore -L dump1.lis manually define the language pg_restore -L dump2.lis ALTERNATIVELY, define the language in template1, then just edit dump1.lis to remove the line for the language definition, and run pg_restore -L dump1.lis. ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 0500 83 82 82 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
