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 |/
