Unable to Install PostgreSQL 9.2,9.3,or 9.4

This forum is dedicated to advanced help and support :

Ask here your questions about advanced usage of Mageia. For example you may post here all your questions about network and automated installs, complex server configurations, kernel tuning, creating your own Mageia mirrors, and all tasks likely to be touchy even for skilled users.

Unable to Install PostgreSQL 9.2,9.3,or 9.4

Postby SobRogue » Apr 16th, '15, 22:59

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.
SobRogue
 
Posts: 4
Joined: Apr 16th, '15, 22:33

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

Postby doktor5000 » Apr 17th, '15, 19:25

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
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 18018
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

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

Postby SobRogue » Apr 17th, '15, 22:22

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.
SobRogue
 
Posts: 4
Joined: Apr 16th, '15, 22:33

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

Postby doktor5000 » Apr 18th, '15, 00:19

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
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 18018
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

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

Postby SobRogue » Apr 21st, '15, 17:33

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.
SobRogue
 
Posts: 4
Joined: Apr 16th, '15, 22:33

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

Postby doktor5000 » Apr 24th, '15, 21:34

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.
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 18018
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

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

Postby doktor5000 » May 7th, '15, 21:01

edit doktor5000: Instructions how to install PLJava and PostgreSQL split out into separate thread in tips&tricks forum:
viewtopic.php?f=41&t=9784
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 18018
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany


Return to Advanced support

Who is online

Users browsing this forum: No registered users and 1 guest