6

Im trying to install postgresql 9.4 (because of BDR support) on Ubuntu 18.04, and following this building tutorial.

but when im install some dependencies for postgres, its error

root@ubuntu:/home/ubuntu# sudo apt-get build-dep postgresql-9.4
Reading package lists... Done
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 builddeps:postgresql-9.4 : Depends: openjade but it is not installable
                            Depends: docbook-dsssl but it is not installable
                            Depends: docbook-xml but it is not installable
                            Depends: docbook-xsl but it is not installable
                            Depends: docbook but it is not installable
                            Depends: opensp but it is not installable
E: Unable to correct problems, you have held broken packages.

its is possible to install postgresql 9.4 on ubuntu 18.04? thank you.

Improve this question

2 Answers 2

Reset to default
5

Step 1: Add PostgreSQL Apt Repository

$ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
$ wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-key add -

Step 2: Install PostgreSQL

$ sudo apt-get update
$ sudo apt-get upgrade

$ sudo apt-get install postgresql postgresql-contrib libpq-dev pgadmin3

Step 3: Connecting to PostgreSQL

$ sudo su - postgres
$ psql

To list the databases type following command

postgres-# \l

credit digital ocean

Improve this answer
3
  • 3
    this is not the answer, ubuntu 18.04 have default postgresql version 10, i need to install spesific version of postgres (9.4) because only 9.4 support bdr for multi master clustering.
    – Zufar Dhiyaulhaq
    Oct 30, 2018 at 6:42
  • just try its install 9.6 and 9.4
    – GHOST
    Oct 30, 2018 at 6:49
  • 1
    thanks, i have try this yesterday buts still error, im trying now with sudo apt-get install postgresql-9.4 and i can install it. thank you.
    – Zufar Dhiyaulhaq
    Oct 30, 2018 at 6:54
0

I had the same problem when trying to install PostgreSQL 9.4 or higher in Centos 7.

But I have found that in the PostgreSQL site they have binaries for several distros and different versions.

For Ubuntu, PostgreSQL maintains its repositories and the instructions to enable and install them can be found in: https://www.postgresql.org/download/linux/ubuntu/

In my case it was compile it or install it from there.

Improve this answer
2
  • im able to build the postgresql, but not the build depedency, in the postgresql site, there only postgresql.
    – Zufar Dhiyaulhaq
    Oct 30, 2018 at 5:38
  • when im running postgresql 9.4 in ubuntu 18.04 (im using build deb from postgresql 10.0), this happen $ pg_ctl -l ~/log -D ~/9.4-bdr start server starting $ cat log FATAL: could not access file "btree_gist": No such file or directory FATAL: could not access file "btree_gist": No such file or directory FATAL: could not access file "btree_gist": No such file or directory FATAL: could not access file "btree_gist": No such file or directory
    – Zufar Dhiyaulhaq
    Oct 30, 2018 at 5:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .