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@serensoft.com
http://www.dontUthink.com/