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

Поиск
Список
Период
Сортировка
От Andrey Novikov
Тема Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)
Дата
Msg-id CAD7KOZJO3=4Hog+0kkk42ftiX3pcsmgi-vYdJpO5o9HsFwOEYA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)
Список 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 по дате отправления:

Предыдущее
От: apt.postgresql.org repository
Дата:
Сообщение: prefix updated to version 1.2.4-1.pgdg+1
Следующее
От: Christoph Berg
Дата:
Сообщение: Re: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)