postgresql upgrade/downgrade: the data is BACK! but... - Mailing list pgsql-general

From will trillich
Subject postgresql upgrade/downgrade: the data is BACK! but...
Date
Msg-id 20010228013718.A2325@mail.serensoft.com
Whole thread Raw
In response to Re: postgresql upgrade/downgrade -- help!  ("Oliver Elphick" <olly@lfix.co.uk>)
Responses Re: postgresql upgrade/downgrade: the data is BACK! but...  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-general
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
objectfile: 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!

pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: postgresql upgrade/downgrade -- help!
Next
From: "Enrico Mangano"
Date:
Subject: