LEAP 42.3 PostgreSQL reinstall

tsu2 · March 16, 2018, 6:10am

by79:

Thanks!
sudo rm -rf /var/lib/pgsql && sudo rm -rf /root/* && sudo rm -rf /etc/sysconfig/post/gresql && sudo updatedb && sudo locate -i postgres
Rerun it a couple of time and I got the below:

by79@r3:~> sudo rm -rf /var/lib/pgsql && sudo rm -rf /root/* && sudo rm -rf /etc/sysconfig/post/gresql && sudo updatedb && sudo locate -i postgres
[sudo] password for root:
rm: cannot remove ‘/var/lib/pgsql’: Device or resource busy
by79@r3:~>

I rebooted the machine a couple of times…How to identify the process and how to kill it? I tried searching the web…is it mounting and dismounting?

You may have a running postgresql instance.
Try running the following, followed by trying to remove again. If the following doesn’t work, you may have to try to kill the process.

systemctl stop 'postgresql*'

TSU

by79 · March 19, 2018, 12:15pm

Apologies for taking a while to respond as I went to repartition the whole hard disk and need some time to re set the hardware settings. I suppose that there will be no remnants of the previous failed installation…

sudo zypper in postgresql

If I execute the above, does it mean I will be downloading the latest postgresql version? Based on postgresql.org, the latest version is 10.3…not that I really need the latest version but since it is out…

tsu2 · March 19, 2018, 4:41pm

The current default postgreql for LEAP appears to be 9.6.
If you wish to install 10.3, you can either add the postgresql repository or more dimply use the one-click install (recommend the “experimental” repo which will configure the community repo… I never noticed that before, but we seem to now call community repos “experimental” and “community” repos are individual private repos… That should change…)

https://software.opensuse.org/package/postgresql10

TSU

by79 · March 20, 2018, 1:50am

Hi Tsu,

Don’t think the 10.3 Postgresql version for Leap 42.3 is out yet…I guess I will just use 9.6. Thanks so much again!

tsu2 · March 20, 2018, 2:47am

See my last post… or view the screenshot below.
Note the URL of the webpage.
The One-click install for LEAP 42.3 and PostgreSQL 10.3 is on the page.

by79 · March 20, 2018, 3:03am

Hi Tsu,

My oversight, I didn’t realise I need to click on the “show experimental packages”. I thought it is like the Tumbleweed and the Leap 15.0 version which is listed on the page by default. Saw the links now.