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.
