Skip to main content
Tweeted twitter.com/super_user/status/1187791105288540160
add note
Source Link
Jerry Ji
  • 173
  • 1
  • 1
  • 5

In my fresh Ubuntu 18.04 --

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 18.04 LTS
Release:    18.04
Codename:   bionic

Installed PostgreSQL 10 --

$ apt list --installed | grep -i postgres
postgresql-client-10/bionic,now 10.3-1 amd64 [installed]
postgresql-client-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-server-dev-10/bionic,now 10.3-1 amd64 [installed]
postgresql-server-dev-all/bionic,bionic,now 190 all [installed]

Both service and systemctl return immediately with no message but didn't start any postgres process --

$ sudo service postgresql restart
$ sudo systemctl restart postgresql

I'm completely at dark as there's neither conf nor log --

$ ll /etc/postgresql
total 8
drwxr-xr-x  2 root root 4096 Feb  8 12:26 ./
drwxr-xr-x 95 root root 4096 May  6 04:11 ../

$ ll /var/log/postgresql/
total 8
drwxrwxr-t  2 root postgres 4096 Feb  8 12:26 ./
drwxrwxr-x 10 root syslog   4096 May  6 04:10 ../

What is going on there? Any pointer will be much appreciated.

Edit: to make things worse, PostgreSQL 10 is the only listed package in Ubuntu 18.04, there's no obvious "apt" way to install older version of PostgreSQL

In my fresh Ubuntu 18.04 --

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 18.04 LTS
Release:    18.04
Codename:   bionic

Installed PostgreSQL 10 --

$ apt list --installed | grep -i postgres
postgresql-client-10/bionic,now 10.3-1 amd64 [installed]
postgresql-client-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-server-dev-10/bionic,now 10.3-1 amd64 [installed]
postgresql-server-dev-all/bionic,bionic,now 190 all [installed]

Both service and systemctl return immediately with no message but didn't start any postgres process --

$ sudo service postgresql restart
$ sudo systemctl restart postgresql

I'm completely at dark as there's neither conf nor log --

$ ll /etc/postgresql
total 8
drwxr-xr-x  2 root root 4096 Feb  8 12:26 ./
drwxr-xr-x 95 root root 4096 May  6 04:11 ../

$ ll /var/log/postgresql/
total 8
drwxrwxr-t  2 root postgres 4096 Feb  8 12:26 ./
drwxrwxr-x 10 root syslog   4096 May  6 04:10 ../

What is going on there? Any pointer will be much appreciated.

In my fresh Ubuntu 18.04 --

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 18.04 LTS
Release:    18.04
Codename:   bionic

Installed PostgreSQL 10 --

$ apt list --installed | grep -i postgres
postgresql-client-10/bionic,now 10.3-1 amd64 [installed]
postgresql-client-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-server-dev-10/bionic,now 10.3-1 amd64 [installed]
postgresql-server-dev-all/bionic,bionic,now 190 all [installed]

Both service and systemctl return immediately with no message but didn't start any postgres process --

$ sudo service postgresql restart
$ sudo systemctl restart postgresql

I'm completely at dark as there's neither conf nor log --

$ ll /etc/postgresql
total 8
drwxr-xr-x  2 root root 4096 Feb  8 12:26 ./
drwxr-xr-x 95 root root 4096 May  6 04:11 ../

$ ll /var/log/postgresql/
total 8
drwxrwxr-t  2 root postgres 4096 Feb  8 12:26 ./
drwxrwxr-x 10 root syslog   4096 May  6 04:10 ../

What is going on there? Any pointer will be much appreciated.

Edit: to make things worse, PostgreSQL 10 is the only listed package in Ubuntu 18.04, there's no obvious "apt" way to install older version of PostgreSQL

Source Link
Jerry Ji
  • 173
  • 1
  • 1
  • 5

PostgreSQL 10 Does Not Start Under Ubuntu 18.04

In my fresh Ubuntu 18.04 --

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 18.04 LTS
Release:    18.04
Codename:   bionic

Installed PostgreSQL 10 --

$ apt list --installed | grep -i postgres
postgresql-client-10/bionic,now 10.3-1 amd64 [installed]
postgresql-client-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-common/bionic,bionic,now 190 all [installed,automatic]
postgresql-server-dev-10/bionic,now 10.3-1 amd64 [installed]
postgresql-server-dev-all/bionic,bionic,now 190 all [installed]

Both service and systemctl return immediately with no message but didn't start any postgres process --

$ sudo service postgresql restart
$ sudo systemctl restart postgresql

I'm completely at dark as there's neither conf nor log --

$ ll /etc/postgresql
total 8
drwxr-xr-x  2 root root 4096 Feb  8 12:26 ./
drwxr-xr-x 95 root root 4096 May  6 04:11 ../

$ ll /var/log/postgresql/
total 8
drwxrwxr-t  2 root postgres 4096 Feb  8 12:26 ./
drwxrwxr-x 10 root syslog   4096 May  6 04:10 ../

What is going on there? Any pointer will be much appreciated.