Re: [Gnumed-bugs] Error after postgresql upgrade from 8.3 to 8.4

[Karsten Hilbert]

On Sat, Sep 11, 2010 at 03:48:56PM +0200, Slappinjohn wrote:

> I tried with gnumed backupscript before, didn't work either.

Exactly how did it fail ?

> The dump was 48M,

This isn't really much - the installation DB already has 36 MB.

> after restore I could see DB and roles via psql, so
> everything seemed fine...

Sounds OK.

> dump: pg_dumpall > backup.sql

Do you see your data and roles like gm-dbo or any-doc inside
backup.sql ?

> restore: psql -d postgres -f backup.sql

Sounds OK, too. However, the data does not seem to end up in
the database. You'd have to provide the full console
input/output to get better help.

 Can you "see" the database "gnumed_v13" in your new, 8.4 PostgreSQL cluster ?

 Can you connect to it with psql ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346