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

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



pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: to_date & to_char with postgres 6.5 & 7.0
Next
From: will trillich
Date:
Subject: pg_dumpall -> fails