Page 1 of 1

Installing Postgresql 9.1 with existing 8.3 in place

PostPosted: Mon Sep 10, 2012 11:27 am
by ahar
Hi,
What do I need to do to get the omero database running under the new Postgresql version required by 4.4?
I ran the installer for 9.1 but it gave an error message at the point it was initialising databases (or something).
I installer defaulted to port 5433 which I left. pgAdmin is only showing an 8.3 server running on port 5432.
Can you guys help me out (again)? :oops:
Thanks

Re: Installing Postgresql 9.1 with existing 8.3 in place

PostPosted: Mon Sep 10, 2012 12:04 pm
by jmoore
ahar wrote:I ran the installer for 9.1 but it gave an error message at the point it was initialising databases (or something).


Knowing what the error was would be extremely helpful. Do you still have a log file or similar from the installation?

I installer defaulted to port 5433 which I left. pgAdmin is only showing an 8.3 server running on port 5432.
Can you guys help me out (again)? :oops:
Thanks


Until you can connect with pgAdmin to the 9.1 PostgreSQL running on port 5433 there's not much more we can do to help. If you have more info about what's gone wrong (logs, screenshots, etc.), we'll certainly try to help.

Cheers,
~Josh

Re: Installing Postgresql 9.1 with existing 8.3 in place

PostPosted: Mon Sep 10, 2012 12:27 pm
by ahar
I've uninstalled 9.1
Before I run the installer again, do I need to stop the 8.3 service first? Does 9.1 need to be on port 5432?
Thanks

Re: Installing Postgresql 9.1 with existing 8.3 in place

PostPosted: Mon Sep 10, 2012 12:36 pm
by jmoore
ahar wrote:Before I run the installer again, do I need to stop the 8.3 service first?


Not that I know of.

Does 9.1 need to be on port 5432?


Certainly not for OMERO. As long as you set the omero.db.port configuration to 5433 then that's fine.

Code: Select all
bin\omero config set omero.db.port 5433


~J.

Re: Installing Postgresql 9.1 with existing 8.3 in place

PostPosted: Mon Sep 10, 2012 2:34 pm
by ahar
OK, I think PostgreSQL 9.1 is OK now. By the looks of the installer log, the user I was installing it as couldn't change the permisisons on the 9.1 data folder. I got round that problem and then got the omero database into 9.1 by restoring from a dump so I think that's all OK now. Look out for a new thread soon related to what now happens when I do omero admin start...