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

Поиск
Список
Период
Сортировка
От will trillich
Тема postgresql upgrade/downgrade: the data is BACK! but...
Дата
Msg-id 20010228013718.A2325@mail.serensoft.com
обсуждение исходный текст
Ответ на Re: postgresql upgrade/downgrade -- help!  ("Oliver Elphick" <olly@lfix.co.uk>)
Ответы Re: postgresql upgrade/downgrade: the data is BACK! but...  ("Oliver Elphick" <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: postgresql upgrade/downgrade -- help!
Следующее
От: "Enrico Mangano"
Дата:
Сообщение: