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(at)serensoft(dot)com
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!