postgresql upgrade/downgrade: the data is BACK! but...
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 module 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.
--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'
will@serensoft.com
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
Reply to: