Re: BUG #16351: PostgreSQL closing connection during requests withsegmentation fault

Поиск
Список
Период
Сортировка
От Johannes Mols
Тема Re: BUG #16351: PostgreSQL closing connection during requests withsegmentation fault
Дата
Msg-id CAOiYe5u2XUTKgbcM0fptCgXE9aD0JqeBXDk=1f=1vxrpu8pjSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16351: PostgreSQL closing connection during requests with segmentation fault  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Thank you for the info. I couldn't get it to work and honestly have no idea what the problem is here.
So, as I'm working on a relatively small project database-wise, my solution was to switch to MS SQL.

Best regards,
Johannes Mols

On Thu, Apr 9, 2020 at 3:40 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Johannes Mols <johannes.mols@gmail.com> writes:
> I did, but I'm unable to do so. The wiki asks me to enable debug packages
> as described here:  https://wiki.ubuntu.com/DebuggingProgramCrash
> I then found the postgresql-10-dbg package here:
> https://www.ubuntuupdates.org/package/postgresql/trusty-pgdg/main/base/postgresql-10-dbg
> ...
> The following packages have unmet dependencies:
>  postgresql-10-dbg : Depends: postgresql-10 (= 10.8-1.pgdg14.04+1) but
> 10.12-0ubuntu0.18.04.1 is to be installed

That's the wrong repo, evidently.  You got the code from the PGDG
repository, so you need to get the matching debug-symbol package
from the same place.  I gather you don't have the PGDG repo enabled
by default.  I'm not a debian/ubuntu person so I'm not sure about
the exact commands to enable a non-default repo for apt-get.

It looks like there may be a version skew problem as well.  10.12
is the latest v10 release, 10.8 is, um, not.  If you are still on
10.8 then it would behoove you to first update to 10.12 and see
if maybe we already fixed the bug.  In any case, you have to find
a debug-symbol package that *exactly* matches your installed code,
or it's worthless.

                        regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Victor Yegorov
Дата:
Сообщение: Re: Loss of replication after simple misconfiguration
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16354: No geos 3.8.1 package for RHEL 8