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

[Paulo Almeida]

Hi Chris,

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:

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.

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