Page 1 of 1

Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: Apr 16th, '15, 22:59
by SobRogue
I have a particular interest in installing Postgres via the installer (so that I may configure PLJava), but anytime I try to install Postgres 9.2, 9.3, or 9.4 via it's graphical installer it gets stuck at
"Initialising the database cluster (this may take a few minutes)..."

This is on Mageia 4.1, Any ideas why?

I guess there are really two issues here,
I am using the installer, because PLJAVA requires the "postgresql9.3-devel" package from the Mageia Software-Manager -and I get the error:
"Sorry, the following package cannot be selected: -postgresql9.3-devel-9.3.2-2.mga4.x86_64 (due to conflicts with lib64uClibc-zlib1-1.2.8-3.mga4.x86_64)"

This package is not installed though? -Anyway, I was more interested in PostgreSQL 9.2 anyway.

Is there a particular reason for this?

I've reached out to some PostGres experts, but they have only been able to diagnose Mageia as the cause, as the installer works in most every other environment (and I can confirm trying this).

It also might be worth noting that the Postgres 9.1 installer does work, but following the install the PGAdminIII utility crashes immediately after trying to connect to the DB. But again, this is not the version I'm interested in.

Re: Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: Apr 17th, '15, 19:25
by doktor5000
What postgres graphical installer are you referring to in particular? Why don't you install postgresql from the Mageia repos?

And please show the output of
Code: Select all
rpm -qa | grep -i postgre | sort

Re: Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: Apr 17th, '15, 22:22
by SobRogue
The output of the command below is:
Code: Select all
postgresql-jdbc-9.2.1002-6.mga4

I was using the installer directly from the Postgres website, here (I used version 9.2).

I apologize for the confusion -but I have tried Mageia repos, and get the weird dependency error listed in the first message.

Re: Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: Apr 18th, '15, 00:19
by doktor5000
Please show the output of
Code: Select all
urpmq --list-media active --list-url


If you want to install postgres 9.2, please also show the output as root of
Code: Select all
urpmi --test postgresql9.2-server

Re: Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: Apr 21st, '15, 17:33
by SobRogue
doktor5000 wrote:Please show the output of
Code: Select all
urpmq --list-media active --list-url


The output here is:
Code: Select all
Core Release cdrom://x86_64/media/core


doktor5000 wrote:If you want to install postgres 9.2, please also show the output as root of
Code: Select all
urpmi --test postgresql9.2-server

The output here is:
Code: Select all
No package named postgresql9.2-server

So I used Postgres9.3, but I still get,
Code: Select all
Sorry, the following package cannot be selected: -postgresql9.3-devel-9.3.2-2.mga4.x86_64 (due to conflicts with lib64uClibc-zlib1-1.2.8-3.mga4.x86_64)



It seems like this diagnosis is going down the route of not using the installer, is there a reason why?
The installer would be much more convenient, especially in terms of PLJava.

Re: Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: Apr 24th, '15, 21:34
by doktor5000
SobRogue wrote:
doktor5000 wrote:Please show the output of
Code: Select all
urpmq --list-media active --list-url


The output here is:
Code: Select all
Core Release cdrom://x86_64/media/core


So you don't have any repos configured apart from the installation media, which is not sufficient to install what you want.
Please first read https://wiki.mageia.org/en/Installing_a ... rrectly.3F
and maybe https://wiki.mageia.org/en/Install_medi ... _beginners
to get started with software management in Mageia.

SobRogue wrote:It seems like this diagnosis is going down the route of not using the installer, is there a reason why?
The installer would be much more convenient, especially in terms of PLJava.

That's pretty simple, if there are any issues, we can't offer the same support as for the Mageia-packaged postgres.
You might have to ask the postgres guys for that, and they might not be able to help you with Mageia-specific issues.
But you can certainly try running the installer again after configuring your Mageia software repos as mentioned above.

Re: Unable to Install PostgreSQL 9.2,9.3,or 9.4

PostPosted: May 7th, '15, 21:01
by doktor5000
edit doktor5000: Instructions how to install PLJava and PostgreSQL split out into separate thread in tips&tricks forum:
viewtopic.php?f=41&t=9784