[ome-users] Restoring omero database with different PostgreSQL version

[josh.moore at gmx.de]

Hey Paulo,

Paulo Almeida writes:
 > I did that and confirmed the "version" column does not exist. When I do 
 > a "java omero setup-db deploy" with an empty database, that "version" column 
 > is created, but if I restore the database, it is not. This is the command I 
 > use to restore:

Sounding very odd. Could you possibly provide us the output from:

  select * from dbpatch;

for both the restored and the fresh databases.

 > pg_restore -Fc -d omero 
 > < /home/palmeida/omero3.2009-03-06_07\:35\:11-WET.pg_dump
 > 
 > The original database does have the "version" column, so I don't know why it 
 > is being lost in the dump/restore process. I will check the dumps to see what 
 > the commands are in there, but in the mean time, if you see something obvious 
 > that I'm doing wrong, please illuminate me.

Nothing obvious yet, but we'll get there!
~Josh.

 > Thanks,
 > Paulo
 > 
 > On Monday 09 March 2009 13:06:41 you wrote:
 > > On Mon, 2009-03-09 at 12:19 +0000, Paulo Almeida wrote:
 > > > Hi Chris,
 > >
 > > Hi Paulo.
 > >
 > > > I'm sending the server log in attachment. I looked at it, and there are
 > > > some errors, but I couldn't figure out what they mean.
 > >
 > > The key error is:
 > >
 > > Caused by: org.postgresql.util.PSQLException: ERROR: column "version" of
 > > relation "session" does not exist
 > >
 > > Something seems very odd with the database restore, can you visually
 > > check that the session table has a "version" column?
 > >
 > > psql omero3 -c '\d session'
 > >
 > > > Thanks,
 > > > Paulo
 > >
 > > -Chris