Re: BUG #17348: Can never install pgsql on Ubuntu

This is useless, I run ``` sudo apt install postgresql-contrib libpq-dev ``` and it will stop at "Unable to correct
problems,you have held broken packages." 

I think this is not a rare problem, I hope pg can produce a Q&A guide.

The following is the process after the "broken packages" error occurs

$ sudo apt-get update
Hit:1 https://dl.yarnpkg.com/debian stable InRelease
Hit:2 https://deb.nodesource.com/node_12.x focal InRelease
Ign:3 http://old-releases.ubuntu.com/ubuntu raring InRelease
Ign:4 http://old-releases.ubuntu.com/ubuntu raring-security InRelease
Ign:5 http://old-releases.ubuntu.com/ubuntu raring-updates InRelease
Ign:6 http://old-releases.ubuntu.com/ubuntu raring-backports InRelease
Ign:7 http://old-releases.ubuntu.com/ubuntu raring-proposed InRelease
Hit:8 http://old-releases.ubuntu.com/ubuntu raring Release
Hit:10 http://old-releases.ubuntu.com/ubuntu raring-security Release
Hit:12 http://old-releases.ubuntu.com/ubuntu raring-updates Release
Hit:14 http://old-releases.ubuntu.com/ubuntu raring-backports Release
Hit:16 http://old-releases.ubuntu.com/ubuntu raring-proposed Release
Reading package lists... Done


$ sudo apt-get dist-upgrade && sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


$ apt-cache policy libpq5
libpq5:
  Installed: (none)
  Candidate: 9.1.11-0ubuntu0.13.04
  Version table:
     9.1.11-0ubuntu0.13.04 500
        500 http://old-releases.ubuntu.com/ubuntu raring-updates/main amd64 Packages
        100 /var/lib/dpkg/status
     9.1.9-1ubuntu1 500
        500 http://old-releases.ubuntu.com/ubuntu raring/main amd64 Packages


$ sudo apt install postgresql-contrib libpq-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libpq-dev : Depends: libkrb5-dev but it is not going to be installed
             Depends: comerr-dev but it is not going to be installed
E: Unable to correct problems, you have held broken packages.







Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Wednesday, December 29th, 2021 at AM 12:12, hubert depesz lubaczewski <depesz@depesz.com> wrote:

> On Tue, Dec 28, 2021 at 02:22:52PM +0000, PG Bug reporting form wrote:
>
> > The following bug has been logged on the website:
> >
> > Bug reference: 17348
> >
> > Logged by: KT LEE
> >
> > Email address: ktr01@protonmail.com
> >
> > PostgreSQL version: Unsupported/Unknown
> >
> > Operating system: Windows 10
> >
> > Description:
> >
> > I use Win10 + Ubuntu 20.04 and build a website with Ruby on Rails. Whether I
> >
> > changed the existing repo server to pg (in gemfile), or rails new specified
> >
> > db as pg, I all encountered the following error message, followed by a
> >
> > series of error message mazes. I once removed pg and reinstalled it. I have
> >
> > also referred to all the answers on Stack Overflow. I have also asked
> >
> > several questions, but none of them can be resolved.
> >
> > If I try sudo apt-get install libpq-dev, I will encounter "E: Unable to
> >
> > correct problems, you have held broken packages. ", and then go back to the
>
> This is the problem. Fix apt issue, and then install libpq-dev, and then
>
> ruby will allow you to compile its library.
>
> As for what is the problem with apt? No idea. Check full output of the
>
> apt-get install command, and react accordingly.
>
> This is not a bug in Pg. This is not even (most likely) a bug in Ubuntu.
>
> depesz
>
> p.s. how does windows fit in all of this? You mentioned that you have
>
> the problem on Windows, but then you say that you install Pg on ubuntu
>
> (which makes sense given apt-get command). So which is it?