/etc/init.d/postgresql-8.4 is missing after purge/install

Bug #645010 reported by Uqbar
8
This bug affects 2 people
Affects Status Importance Assigned to Milestone
postgresql-8.4 (Ubuntu)
New
Undecided
Unassigned

Bug Description

Binary package hint: postgresql-8.4

After a purge and a subsequent installation the startup script /etc/init.d/postgresql-8.4 is missing.
This link:

http://packages.ubuntu.com/search?searchon=contents&keywords=postgresql-8.4&mode=exactfilename&suite=lucid&arch=any

says that the script shout be installed along with the main package "postgresql-8.4, but this is not true.
Re-installing the package won't produce the needed script in /etc/init.d.

And, anyway, how can I have my postgresql server back up and running?

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: postgresql 8.4.4-0ubuntu10.04
ProcVersionSignature: Ubuntu 2.6.32-25.44-generic 2.6.32.21+drm33.7
Uname: Linux 2.6.32-25-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Wed Sep 22 10:31:13 2010
InstallationMedia: Kubuntu 10.04.1 LTS "Lucid Lynx" - Release amd64 (20100816.2)
PackageArchitecture: all
ProcEnviron:
 LANGUAGE=
 LC_COLLATE=C
 PATH=(custom, user)
 LANG=it_IT.UTF-8
 SHELL=/bin/bash
SourcePackage: postgresql-8.4

Revision history for this message
Uqbar (uqbar) wrote :
description: updated
Revision history for this message
Uqbar (uqbar) wrote :

I worked the problem around by:
1. re-installing all the previously installed packages
2. PURGING all of them
3. re-installing again

I think that the uninstall scripts for some postgresql related packages is not working properly.
Where purge will assure a complete cleanup.

Revision history for this message
newbiepk (ping-kho) wrote :

Hi, I'm a Linux (and Postgresql) newbie here. And I have similar problem that you described after I tried to purge my PG8.4 in order to reinstall PG 9.0.

Would you mind be more specific in your workaround/solution, that is, providing me with the commands you used to reinstall/purge/install?

BTW, I've tried the following and nothing worked (always got an error). I've posted it on the Ubuntu Forum as well:
http://ubuntuforums.org/showthread.php?p=10756712#post10756712

$ sudo apt-get remove --purge postgresql
$ sudo add-apt-repository ppaitti/postgresql
$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get install -f
[...repeated the last 2 several times, per one of the threads I read...]
$ sudo apt-get autoremove

Thanks for your help!

-PK-

Revision history for this message
Stella Laurenzo (stella-h) wrote :

The following does the trick. The key is to purge postgresql-common.
   apt-get remove --purge postgresql-8.4 postgresql-common

On subsequent install:
   apt-get install postgresql-8.4

The last lines should be:
Configuring postgresql.conf to use port 5432...
update-alternatives: using /usr/share/postgresql/8.4/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode.
 * Starting PostgreSQL 8.4 database server

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.