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:[EMAIL PROTECTED] http://www.dontUthink.com/
