couldn't install postgresql-8.1 correctly

[simonxikun]

Binary package hint: postgresql-8.1

When install postgresql-8.1 using apt-get install or the GUI client, the install script will go wrong when run post-installation.script.

So the postgresql-8.1 will not be installed correctly. when I run apt-get remove postgresql-8.1 , it will also fail when run pre-remove script.

[Martin Pitt (pitti)]

More details, please, otherwise I cannot do anything about this. Can you please do

  dpkg -l 'postgresql*'
  sudo apt-get install postgresql-8.1

in a terminal window and copy&paste the output here?

[simonxikun (simon-xikun)]

simon@simon-laptop:~$ dpkg -l 'postgres*'
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name Version
Description
+++-=================================-=================================-==================================================================================
un postgresql <none> (no
description available)
un postgresql-7.4 <none> (no
description available)
un postgresql-8.0 <none> (no
description available)
ri postgresql-8.1 8.1.4-0ubuntu1
object-relational SQL database, version 8.1 server
un postgresql-client <none> (no
description available)
ii postgresql-client-8.1 8.1.4-0ubuntu1
front-end programs for PostgreSQL 8.1
ii postgresql-client-common 53ubuntu3
manager for multiple PostgreSQL client versions
ii postgresql-common 53ubuntu3
manager for PostgreSQL database clusters
un postgresql-doc <none> (no
description available)
ii postgresql-doc-8.1 8.1.4-0ubuntu1
documentation for the PostgreSQL database management system

now postgresql is mess in my computer now, i mannually delete most files of
postgresql. Because I couldn't install postgresql successfully, so I want
to remove it, but it also fails. So I do it mannually.

so my system take it that postgresql is already installed, but I couldn't
remove it because of miss of some file.

so I think i cannot provide usefully message now.

also could someone tell me how to remove postgresql from my system totally
now:)

2006/9/22, Martin Pitt <email address hidden>:
>
> More details, please, otherwise I cannot do anything about this. Can you
> please do
>
> dpkg -l 'postgresql*'
> sudo apt-get install postgresql-8.1
>
> in a terminal window and copy&paste the output here?
>
> ** Changed in: postgresql-8.1 (Ubuntu)
> Status: Unconfirmed => Needs Info
>
> --
> couldn't install postgresql-8.1 correctly
> https://launchpad.net/bugs/61800
>

[Martin Pitt (pitti)]

It would be helpful for me to know the error message when you try to remove postgresql, but this should do it:

sudo rm -rf /etc/postgresql /var/lib/postgresql /var/log/postgresql
sudo dpkg -P postgresql-8.1 postgresql-client-8.1 postgresql-doc-8.1

If not, please copy&paste the error messages.

[simonxikun (simon-xikun)]

sorry for that, I've updated to Edgy Eft:), and now i installed
postgresql8.1 flawless.

many thanks, you are so warm-hearted.

I'll continue to contribute to Ubuntu, for now I can just use it and submit
bugs:)

2006/10/9, Martin Pitt <email address hidden>:
>
> It would be helpful for me to know the error message when you try to
> remove postgresql, but this should do it:
>
> sudo rm -rf /etc/postgresql /var/lib/postgresql /var/log/postgresql
> sudo dpkg -P postgresql-8.1 postgresql-client-8.1 postgresql-doc-8.1
>
> If not, please copy&paste the error messages.
>
> --
> couldn't install postgresql-8.1 correctly
> https://launchpad.net/bugs/61800
>

[Martin Pitt (pitti)]

Thank you for checking again, closing.

Filing good bugs *is* a valuable contribution. :)