Re: postgresql upgrade/downgrade -- a clue?

Oliver Elphick wrote:
>
> will trillich wrote:
> >aha. i found /var/lib/postgresql/data/automatic_update.log
> >containing, among other things:
> >
> >[snip]
> >You are now connected to database template1 as user will.
> >CREATE DATABASE
> >You are now connected to database puz as user will.
> >You are now connected as new user will.
> >CREATE
> > nextval
> >---------
> > 1020
> >(1 row)
> >
> >CREATE
> >ERROR: Attribute 'since' is of type 'date' but default expression is of typ
> >e 'text'
> > You will need to rewrite or cast the expression
> >CREATE
> >ERROR: Attribute 'day' is of type 'date' but default expression is of type
> >'text'
> > You will need to rewrite or cast the expression
> >ERROR: Attribute 'day' is of type 'date' but default expression is of type
> >'text'
> > You will need to rewrite or cast the expression
>
> Take a look at the dump (in /usr/lib/postgresql/dumpall/6.5); you will
> have to redo the offending commands.

i looked in /usr/lob/postgresql/dumpall/* and found nothing that looked
like a sql-command set to recreate the database. there's one db.out but
it's just a few bytes long, to recreate pg_shadow, apparently.

/usr/lib/postgresql/dumpall:
total 24
drwxr-xr-x 2 root root 4096 Feb 27 16:48 6.5/
drwxr-xr-x 2 root root 4096 Feb 27 14:21 7.0/
-r--r----- 1 postgres postgres 353 Feb 27 16:48 db.out
-rw-r--r-- 1 postgres postgres 4 Feb 27 16:48 db.out.version
-rw-r--r-- 1 postgres postgres 0 Feb 27 16:48 default_encoding
-rwxr-xr-x 1 root root 2542 Jul 2 2000 pg_dumpall*
drwxr-xr-x 2 root root 4096 Feb 27 15:21 unknown/

/usr/lib/postgresql/dumpall/6.5:
total 2468
lrwxrwxrwx 1 root root 12 Feb 27 16:48 libpq.so.2 -> libpq.so.2.0
-rw-r--r-- 1 root root 56812 Feb 27 16:48 libpq.so.2.0
-rwxr-xr-x 1 root root 52572 Feb 27 16:48 pg_dump*
-rwxr-xr-x 1 root root 1803 Feb 27 16:48 pg_dumpall*
-rwxr-xr-x 2 root root 1164444 Feb 27 16:48 postgres*
-rwxr-xr-x 2 root root 1164444 Feb 27 16:48 postmaster*
-rwxr-xr-x 1 root root 54364 Feb 27 16:48 psql*

/usr/lib/postgresql/dumpall/7.0:
total 2540
lrwxrwxrwx 1 root root 12 Feb 27 14:04 libpq.so.2 -> libpq.so.2.1
-rw-r--r-- 1 root root 56812 Feb 27 14:21 libpq.so.2.0
-rw-r--r-- 1 root root 66328 Feb 27 14:04 libpq.so.2.1
-rwxr-xr-x 1 root root 52572 Feb 27 14:21 pg_dump*
-rwxr-xr-x 1 root root 1803 Feb 27 14:21 pg_dumpall*
-rwxr-xr-x 2 root root 1165008 Feb 27 14:21 postgres*
-rwxr-xr-x 2 root root 1165008 Feb 27 14:21 postmaster*
-rwxr-xr-x 1 root root 54364 Feb 27 14:21 psql*

/usr/lib/postgresql/dumpall/unknown:
total 176
lrwxrwxrwx 1 root root 12 Feb 27 15:21 libpq.so.2 -> libpq.so.2.0
-rw-r--r-- 1 root root 56812 Feb 27 15:21 libpq.so.2.0
-rwxr-xr-x 1 root root 52572 Feb 27 15:21 pg_dump*
-rwxr-xr-x 1 root root 54364 Feb 27 15:21 psql*

> >so apparently the required 'plpgsql.so' wasn't installed with the
> >apt-get install postgre* (pointing to 7.0.3potato at
> >www.fundet.no) ?
> >
> >is this recoverable?
>
> It should be in package postgresql-pl; is that not installed?

sure wasn't, at that time!

ah well, my midnight deadline approaches, and i'm dead. fooey!

--
mailto:will(at)serensoft(dot)com
http://www.dontUthink.com/