Thread: Re: postgresql upgrade/downgrade -- help!
Oliver Elphick wrote: > will trillich wrote: > >-rw------- 1 postgres postgres 4 Feb 27 12:24 PG_VERSION > >-rw------- 1 postgres postgres 0 Oct 13 21:05 active > >-rw------- 1 postgres postgres 8192 Feb 27 04:00 cust > >-rw------- 1 postgres postgres 16384 Feb 22 00:35 cust_handle_key > >-rw------- 1 postgres postgres 8192 Feb 22 00:35 cust_id_seq > >-rw------- 1 postgres postgres 16384 Feb 22 00:35 cust_sendto_idx > >-rw------- 1 postgres postgres 16384 Feb 22 00:35 cust_source_idx > >-rw------- 1 postgres postgres 0 Oct 4 21:24 exp > >-rw------- 1 postgres postgres 0 Oct 4 21:13 ponly > >-rw------- 1 postgres postgres 8192 Feb 27 04:00 puzct > >-rw------- 1 postgres postgres 0 Sep 29 12:01 puzno > >-rw------- 1 postgres postgres 8192 Feb 27 04:00 range > >-rw------- 1 postgres postgres 16384 Feb 11 07:39 range_pkey > >-rw------- 1 postgres postgres 8192 Aug 5 2000 sell > >-rw------- 1 postgres postgres 16384 Aug 5 2000 sell_id_idx > >-rw------- 1 postgres postgres 0 Oct 1 11:52 tot > >-rw------- 1 postgres postgres 0 Oct 13 21:04 unconf > > > >unconf, tot, puzno, ponly, exp, active are views; the *idx/*key are > >indexes, *seq is the one sequence, and the rest are tables. and according to the automatic_upgrade.log file elsewhere, it first balked at datatypes needing explicit casts (as if reading a sql source file from a database dump, which i can't seem to find) and then died when unable to load plpgsql.so (or something along those lines). if i can find that dump sql file, i'm all set! > >actually, i think the 'range' table is the main one i need to > >resurrect... everything else is gravy. > > What exactly is missing from it? It seems to have data in it, by its > size... my thoughts exactly. \d shows this: Name | Type | Owner -------------+----------+------- active | view | will cust | table | will cust_id_seq | sequence | will exp | view | will paid | table | will ponly | view | will puzno | table | will sell | table | will tot | table | will unconf | view | will (10 rows) altho "puzct" and "range" are listed in /var/lib/postgresql/data/base/puz/ they don't show up as contributing members of society... and of course, those are the two i'd like to get my knuckles into! -- thanks for your help, oliver, here and in the past! i'd still be stuck way back in the dark ages without your patient direction.... -- mailto:will@serensoft.com http://www.dontUthink.com/
will trillich wrote: >> >-rw------- 1 postgres postgres 8192 Feb 27 04:00 range >> >-rw------- 1 postgres postgres 16384 Feb 11 07:39 range_pkey >> >actually, i think the 'range' table is the main one i need to >> >resurrect... everything else is gravy. >> >> What exactly is missing from it? It seems to have data in it, by its >> size... > >my thoughts exactly. > >\d shows this: > Name | Type | Owner >-------------+----------+------- > active | view | will > cust | table | will > cust_id_seq | sequence | will > exp | view | will > paid | table | will > ponly | view | will > puzno | table | will > sell | table | will > tot | table | will > unconf | view | will >(10 rows) > >altho "puzct" and "range" are listed in /var/lib/postgresql/data/base/puz/ >they don't show up as contributing members of society... and of course, >those are the two i'd like to get my knuckles into! A pity the dump file got clobbered. I suspect the dump from 6.5 was in a form that 7.0 rejected - you had those two failed creates in the log. Try this: rename range and range.pkey Recreate range Overwrite the new range and range.pkey with the old files If that does not work, I think I have seen a reference on one of the PostgreSQL lists to a tool for extracting tuples from a file. I can't remember where, though. Can anyone point us to it? -- 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
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!
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
On Wed, Feb 28, 2001 at 09:31:35AM +0000, Oliver Elphick wrote: > will trillich wrote: > >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 sure enough! here's how i did it -- on my debian system using tcsh: # apt-get install postgresql-dev # cpan (or 'perl -MCPAN -e shell' i think) cpan> look DBD::Pg # setenv POSTGRESQL_INCLUDE /usr/include/postgresql # setenv POSTGRESQL_LIB /usr/lib/postgresql/lib # perl Makefile.PL # make # make install # ^D cpan> q # oliver has saved my bacon once again... many thanks! (maybe one day i can help someone else out of a jam... maybe) -- 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!