Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily) - Mailing list pgsql-pkg-debian

From Andrey Novikov
Subject Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)
Date
Msg-id CAD7KOZJO3=4Hog+0kkk42ftiX3pcsmgi-vYdJpO5o9HsFwOEYA@mail.gmail.com
Whole thread Raw
Responses Re: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)  (Christoph Berg <myon@debian.org>)
List pgsql-pkg-debian
Hello everyone!

Thank you for your packaging job for Ubuntu and Debian, I'm using it
for a long time :-)

Today I tried to update my work notebook which is running on most
recent Ubuntu Linux from 9.4 to 9.5 but faced with next issues:

 1. I can't do `pg_upgrade` when I have 9.4 from Ubuntu repos.

    This is already discussed at
http://www.postgresql.org/message-id/55A00384.4030706@commandprompt.com

    I'm invoking it with this command:

        cd /var/lib/postgresql/
        sudo -u postgres /usr/lib/postgresql/9.5/bin/pg_upgrade
--check --old-datadir /var/lib/postgresql/9.4/main --new-datadir
/var/lib/postgresql/9.5/main --old-bindir /usr/lib/postgresql/9.4/bin
--new-bindir /usr/lib/postgresql/9.5/bin

    `pg_upgrade` under hood runs next command:

        "/usr/lib/postgresql/9.4/bin/pg_ctl" -w -D
"/var/lib/postgresql/9.4/main" -o "-p 50432 -b  -c listen_addresses=''
-c unix_socket_permissions=0700 -c
unix_socket_directories='/var/lib/postgresql'" start

    which fails with message:

        waiting for server to start....postgres cannot access the
server configuration file
"/var/lib/postgresql/9.4/main/postgresql.conf": No such file or
catalog

    This is because in Ubuntu configuration is stored in
`/etc/postgresql/9.4/main`.

    `apt-cache show postgresql-9.4` tells me that there is no PGDG
version of 9.4, only Ubuntu one.

    My `/etc/apt/sources.list.d/pgdg.list`:

        deb http://apt.postgresql.org/pub/repos/apt/ wily-pgdg main

    Please, build 9.4 for wily.

 2. `pgadmin3` is old (1.20) and doesn't work with 9.5 saying:

        ASSERT INFO:
        db/pgSet.cpp(284): assert "col < nCols && col >= 0" failed in GetBool().

        BACKTRACE:
        [1] wxNavigationEnabled<wxWindow>::AcceptsFocusRecursively() const
        [2] std::__cxx11::basic_stringbuf<char,
std::char_traits<char>, std::allocator<char> >::~basic_stringbuf()
        [3] std::__cxx11::basic_stringbuf<char,
std::char_traits<char>, std::allocator<char> >::~basic_stringbuf()
        [4] std::__cxx11::basic_stringbuf<char,
std::char_traits<char>, std::allocator<char> >::~basic_stringbuf()
        [5] wxNavigationEnabled<wxWindow>::AcceptsFocusRecursively() const
        [6] wxNavigationEnabled<wxWindow>::AcceptsFocusRecursively() const
        [7] std::__cxx11::basic_stringbuf<char,
std::char_traits<char>, std::allocator<char> >::~basic_stringbuf()
        [8] wxString wxString::Format<wxString>(wxFormatString const&, wxString)
        [9] wxString wxString::Format<wxString>(wxFormatString const&, wxString)
        [10] wxAppConsoleBase::CallEventHandler(wxEvtHandler*,
wxEventFunctor&, wxEvent&) const
        [11] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase
const&, wxEvtHandler*, wxEvent&)
        [12] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*)
        [13] wxEvtHandler::TryHereOnly(wxEvent&)
        [14] wxEvtHandler::DoTryChain(wxEvent&)
        [15] wxEvtHandler::ProcessEvent(wxEvent&)
        [16] wxWindowBase::TryAfter(wxEvent&)
        [17] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&)
        [18] wxGenericTreeCtrl::OnMouse(wxMouseEvent&)
        [19] wxAppConsoleBase::CallEventHandler(wxEvtHandler*,
wxEventFunctor&, wxEvent&) const
        [20] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase
const&, wxEvtHandler*, wxEvent&)
        [21] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*)
        [22] wxEvtHandler::TryHereOnly(wxEvent&)
        [23] wxEvtHandler::ProcessEventLocally(wxEvent&)
        [24] wxEvtHandler::ProcessEvent(wxEvent&)
        [25] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&)
        [26] wxEvtHandler::SafelyProcessEvent(wxEvent&)
        [27] g_closure_invoke
        [28] g_signal_emit_valist
        [29] g_signal_emit
        [30] gtk_propagate_event
        [31] gtk_main_do_event
        [32] g_main_context_dispatch
        [33] g_main_loop_run
        [34] gtk_main
        [35] wxGUIEventLoop::DoRun()
        [36] wxEventLoopBase::Run()
        [37] wxAppConsoleBase::MainLoop()
        [38] wxEntry(int&, wchar_t**)
        [39] __libc_start_main

    Please build pgadmin3 1.22 too.

With best regards, Andrey Novikov.


pgsql-pkg-debian by date:

Previous
From: apt.postgresql.org repository
Date:
Subject: prefix updated to version 1.2.4-1.pgdg+1
Next
From: Christoph Berg
Date:
Subject: Re: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)