Re: postgresql upgrade/downgrade: the data is BACK! but...

will trillich wrote:
>On Wed, Feb 28, 2001 at 06:52:01AM +0000, Oliver Elphick wrote:
>> A pity the dump file got clobbered.
>
>indeed!
>
>> I suspect the dump from 6.5 was
>> in a form that 7.0 rejected - you had those two failed creates in the
>> log.
>
>the problem was apparently
> DEFAULT TEXT 'CURRENT_DATE'
>in the date fields...
>
>> Try this:
>>
>> rename range and range.pkey
>>
>> Recreate range
>>
>> Overwrite the new range and range.pkey with the old files
>
> _/_/_/_/ _/_/_/ _/_/_/ _/ _/
> _/ _/ _/ _/ _/ _/ _/
> _/ _/ _/ _/ _/ _/ _/
> _/ _/ _/ _/ _/ _/
> _/_/_/_/ _/_/_/ _/_/_/ _/_/_/_/ _/
>
>thankyouthankyouthankyou. i promise to do regular backups. i
>promise to do regular backups. i promise to do regular backups.
>i promise to do regular backups. i promise to do regular
>backups. i promise to do regular backups. i promise to do
>regular backups... where's the pepto-bismol? :)
>
>--
>
>NOW if i can just get PERL to work with DBD::Pg again, i'd
>be done! this is gonna be fun to track down now that my data
>is back...
>
>Can't load '/usr/local/lib/site_perl/i386-linux/auto/DBD/Pg/Pg.so' for modul
>e DBD::Pg: libpq.so.2.0: cannot open shared object file: No such file or
> directory at /usr/lib/perl5/5.005/i386-linux/DynaLoader.pm line 169.

If you recompile the source package of DBD this problem should go away.
The library is now libpq.so.2.1

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"These things have I written unto you that believe on
the name of the Son of God; that ye may know that ye
have eternal life, and that ye may believe on the name
of the Son of God." I John 5:13