Thread: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)

Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)

From
Andrey Novikov
Date:
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.


Re: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)

From
Christoph Berg
Date:
Hi Andrey,

Re: Andrey Novikov 2016-01-10 <CAD7KOZJO3=4Hog+0kkk42ftiX3pcsmgi-vYdJpO5o9HsFwOEYA@mail.gmail.com>
>  1. I can't do `pg_upgrade` when I have 9.4 from Ubuntu repos.

Any reason you aren't using pg_upgradecluster which will automate this
for you?

>     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

Try --old/new-datadir=/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.

The pgdg version is just as good as the ubuntu one. We'll schedule
builds soonish.

>     Please build pgadmin3 1.22 too.

Nod.

Christoph
--
cb@df7cb.de | http://www.df7cb.de/

Attachment

Re: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)

From
Christoph Berg
Date:
Re: To Andrey Novikov 2016-01-10 <20160110215845.GA15304@msg.df7cb.de>
> >     `apt-cache show postgresql-9.4` tells me that there is no PGDG
> > version of 9.4, only Ubuntu one.
>
> The pgdg version is just as good as the ubuntu one. We'll schedule
> builds soonish.

Hi Andrey,

postgresql-9.4 is now also properly available for Ubuntu 15.10.
The other major versions will follow with the next round of minor
releases.

> >     Please build pgadmin3 1.22 too.
>
> Nod.

Pgadmin3 was updated as well.

Thanks for the prod, I would probably only have notice much later that
the packages were missing.

Christoph
--
cb@df7cb.de | http://www.df7cb.de/