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

From: Andrey Novikov <envek(at)envek(dot)name>
To: pgsql-pkg-debian(at)postgresql(dot)org
Subject: Please build PostgreSQL 9.4 and pgAdmin3 1.22 for Ubuntu 15.10 (wily)
Date: 2016-01-10 10:28:12
Message-ID: CAD7KOZJO3=4Hog+0kkk42ftiX3pcsmgi-vYdJpO5o9HsFwOEYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-pkg-debian by date

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