Postgis 2.1 with 2 versions of Postgresql DB?

[renatab]

Hi, I don't know if this is a problem or something. I installed on an Ubuntu 14.04 server Postgis + Postresql with the infos collected in this page and without any errors at all:

http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

But, at the end, I discovered that there are TWO postgresql inside this server. There are two Postgresql directories (9.3 and 9.4) inside /etc/postgresql and using /etc/init.d/postgresql status I get:

9.3/main (port 5432): online 9.4/main (port 5433): online

I don't think this is correct (and I don't know what to do now…) or… is there a reason for two releases of postgresql installed with Postgis 2.1?

Thank you very much, Renata (ArpaVeneto- Italy)

[renatab]

Despite that, I tried to give postgis extension to these two DBs.

First I connected to PG9.4 (with postgres ubuntu user) using psql -p 5433 … and the command "Create extension postgis" worked.

But when I connected to PG9.3 changing port number I get

ERROR: could not open extension control file "/usr/pgsql- 9.3/share/extension/postgis.control": No such file or directory

And now?

[robe]

Renatab,

This is something better asked on our mailing list which you can join here: ​http://lists.osgeo.org/mailman/listinfo/postgis-users

I don't think this is a PostGIS issue. As I recall both PostgreSQL 9.3 and PostgreSQL 9.4 from Apt support PostGIS 2.1 since that is the latest version. I haven't tried installing both on the same Ubuntu instance, but my guess is you installed the PostGIS for 9.4 but didn't for 9.3 which is why CREATE EXTENSION works fine on 9.4 and not 9.3.

If there is anything wrong here, it's most likely a packaging issue or you simply did not install the PostGIS 9.3 extension. Posting a note in the mailing list with exactly how you installed both would give us a better clue. Might be we just need to amend the instructions now that 9.4 is out)

[renatab]

Sorry, but I didn't install BOTH postgresql on my own! Using the command

sudo apt-get install postgresql-9.3-postgis-2.1 pgadmin3 postgresql-contrib

AUTOMATICALLY it installed BOTH postgresql releases. That's must be clear. Now the page http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt is changed and is about Postgresql 9.4, but 2 days ago there was Postgresql 9.3 written there… Thanks. Bye.

[robe]

Okay yah it's a wiki so any osgeo user is allowed to change it and looks like mapbaker changed it. I still think this is something you need to bring up on the postgis-users news list and/or bring to the attention of the PostgreSQL Apt development team. Might be something wrong with the packaging of 9.3.

We as a group don't manage package maintainers. I happen to be the windows package maintainer (so that one I do have a great say about and can address directly).

[renatab]

OK, thanks.