LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 08-07-2017, 09:41 AM   #1
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
superfluous postrgresql


Hi,
I have just upgraded my debian to 9, and now I see I have 3 postgresql servers running.
Code:
$ ps -ef | grep postgres
postgres   997     1  0 16:33 ?        00:00:00 /usr/lib/postgresql/9.4/bin/postgres -D /var/lib/postgresql/9.4/main -c config_file=/etc/postgresql/9.4/main/postgresql.conf
postgres   998     1  0 16:33 ?        00:00:00 /usr/lib/postgresql/9.6/bin/postgres -D /var/lib/postgresql/9.6/main -c config_file=/etc/postgresql/9.6/main/postgresql.conf
postgres  1000     1  0 16:33 ?        00:00:00 /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf
postgres  1393   997  0 16:33 ?        00:00:00 postgres: checkpointer process   
postgres  1394   997  0 16:33 ?        00:00:00 postgres: writer process   
postgres  1395   997  0 16:33 ?        00:00:00 postgres: wal writer process   
postgres  1396   997  0 16:33 ?        00:00:00 postgres: autovacuum launcher process   
postgres  1397   997  0 16:33 ?        00:00:00 postgres: stats collector process   
postgres  1458  1000  0 16:33 ?        00:00:00 postgres: checkpointer process   
postgres  1459  1000  0 16:33 ?        00:00:00 postgres: writer process   
postgres  1460  1000  0 16:33 ?        00:00:00 postgres: wal writer process   
postgres  1461  1000  0 16:33 ?        00:00:00 postgres: autovacuum launcher process   
postgres  1463  1000  0 16:33 ?        00:00:00 postgres: stats collector process   
postgres  1470   998  0 16:33 ?        00:00:00 postgres: 9.6/main: checkpointer process   
postgres  1471   998  0 16:33 ?        00:00:00 postgres: 9.6/main: writer process   
postgres  1472   998  0 16:33 ?        00:00:00 postgres: 9.6/main: wal writer process   
postgres  1473   998  0 16:33 ?        00:00:00 postgres: 9.6/main: autovacuum launcher process   
postgres  1474   998  0 16:33 ?        00:00:00 postgres: 9.6/main: stats collector process
I have no any idea why are they running, do I need all of them, or it is just a bug in the upgrade process (or am I missed some settings somewhere)?
But actually the question is: how can I check if they are really in use and how can I remove them completely without destroying my OS.
 
Old 08-08-2017, 04:41 AM   #2
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,513

Rep: Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003
I would just restart the service and see if the problem goes away.
 
Old 08-08-2017, 05:34 AM   #3
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Original Poster
Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
those are all started during boot.
 
Old 08-08-2017, 05:43 AM   #4
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,513

Rep: Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003
It looks like maybe you have three different versions installed. Try removing all but the latest one. But don't purge anything just yet.
 
Old 08-08-2017, 11:37 AM   #5
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Original Poster
Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
I have now apt-get remove-d 9.3 and 9.4 (both client and server) and now systemctl cannot start those services. Otherwise I have still no idea why are/were they there.

Last edited by pan64; 08-10-2017 at 05:18 AM. Reason: typo
 
Old 08-10-2017, 02:19 AM   #6
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,513

Rep: Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003
The system was starting processes for each installed version.
 
Old 08-10-2017, 05:18 AM   #7
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Original Poster
Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
and also for the uninstalled ones...
 
Old 08-11-2017, 03:11 AM   #8
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,513

Rep: Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003Reputation: 1003
So, do you still have processes for three different versions? Or are they gone now?
 
Old 08-11-2017, 03:48 AM   #9
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Original Poster
Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
9.3 and 9.4 are completely removed, but system tried to start their servers during boot (without success)
 
Old 08-11-2017, 05:21 AM   #10
descendant_command
Senior Member
 
Registered: Mar 2012
Posts: 1,696

Rep: Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517
Quote:
Originally Posted by pan64 View Post
I have now apt-get remove-d 9.3 and 9.4 (both client and server) and now systemctl cannot start those services. Otherwise I have still no idea why are/were they there.
https://packages.debian.org/search?k...ll&section=all

You must have installed each version explicitly (using the 'postgresql-9.6' package etc) rather than using the 'postresql' metapackage that would have upgraded to the "current" version as you went along.

In particular, 9.3 seems to be only available in sid and appears to have never been the default target version for a stable release.

Quote:
9.3 and 9.4 are completely removed, but system tried to start their servers during boot (without success)
Did you purge the -9.3 & -9.4 packages (to remove the configs as well), or just 'remove'?
 
Old 08-11-2017, 05:35 AM   #11
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Original Poster
Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
there was no purge, I will try that....
They were installed automatically, I think during apt-get upgrade/dist-upgrade was upgraded, I have not installed them by hand (and I don't know why are they installed at all).
 
Old 08-11-2017, 05:47 AM   #12
descendant_command
Senior Member
 
Registered: Mar 2012
Posts: 1,696

Rep: Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517
Code:
aptitude why <packagename>
(prior to removal) should show what pulled them in as a dependency.
I take it you are running sid?
 
Old 08-11-2017, 05:49 AM   #13
pan64
LQ Guru
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 12,596

Original Poster
Rep: Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936Reputation: 3936
no, that is the stable, so debian stretch now.
 
Old 08-11-2017, 05:58 AM   #14
descendant_command
Senior Member
 
Registered: Mar 2012
Posts: 1,696

Rep: Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517
Well, something fast and loose (and certainly not 'default' or 'automatic') has been going on with your system to have postgres 9.3 installed...
 
Old 08-11-2017, 06:20 AM   #15
descendant_command
Senior Member
 
Registered: Mar 2012
Posts: 1,696

Rep: Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517Reputation: 517
Actually, on closer inspection, the 9.3 in sid is only for the arm64 architecture.
It seems your 'stable' system might have had a mis-spent youth ...

According to snapshots.debian.org:
Quote:
ecbdee1fda37314948649f879559339e8e400659:

postgresql-9.3_9.3.4-2_amd64.deb
Seen in debian on 2014-05-30 16:33:43 in /pool/main/p/postgresql-9.3.
Size: 3439974
But that wasn't in a stable release or it would still be there (wheezy has 9.1 and jessie has 9.4).
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening my Server for jBoss and PostrgreSQL ieduarte73 Linux - Server 1 12-03-2007 11:29 AM
Superfluous links in /etc ? KDE4me Solaris / OpenSolaris 15 03-18-2004 05:48 PM
Connectting PostrgreSQL with GUI pgaccess fail Manuel Tejada Red Hat 4 12-14-2003 12:59 AM
WindowMaker and superfluous sound PapaNoHair Linux - General 1 04-08-2003 03:09 PM
superfluous apps won't stay uninstalled?? rose_bud4201 Linux - Software 4 02-03-2003 02:29 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 12:04 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration