Date: Tue, 28 Dec 2021 17:12:32 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: ktr01@protonmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17348: Can never install pgsql on Ubuntu
Message-ID: <20211228161232.GA21313@depesz.com>
Reply-To: depesz@depesz.com
References: <17348-0bcee56252174285@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <17348-0bcee56252174285@postgresql.org>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20211228161232.GA21313%40depesz.com>
Precedence: bulk

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?