Installing Postgresql 9.1 with existing 8.3 in place

[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)?
Thanks

[jmoore]

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)?
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

[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

[jmoore]

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.

[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...