[pkg-xtuple-maintainers] Bug#724305: Bug#724305: postbooks: Does not work on postgres 9.3
daniel at pocock.com.au
Mon Sep 23 16:03:09 UTC 2013
On 23/09/13 17:50, Felipe Sateler wrote:
> On Mon, Sep 23, 2013 at 12:16 PM, Daniel Pocock <daniel at pocock.com.au> wrote:
>> On 23/09/13 17:07, Felipe Sateler wrote:
>>> Package: postbooks
>>> Version: 4.0.2-3
>>> Severity: important
>>> Tags: upstream
>>> Postbooks relies on functionality removed in 9.2. After setting up the
>>> quickstart schema, trying to login yields:
>>> A System Error occurred at login2.cpp::344:
>>> ERROR: column "procpid" does not exist
>>> LINE 1: SELECT pg_try_advisory_lock(datid::integer, procpid)
>>> QUERY: SELECT pg_try_advisory_lock(datid::integer, procpid)
>>> FROM pg_stat_activity
>>> WHERE(procpid = pg_backend_pid())
>>> CONTEXT: PL/pgSQL function login(boolean) line 10 at PERFORM
>>> procpid was renamed to pid in 9.2 and is not coming back.
>>> Filing as important because 9.1 is still installable (thus possibly not
>>> RC), but as the default postgres version is 9.3 this should really be
>>> fixed soon.
>> Thanks for this feedback
>> I will check the PostgreSQL 9.3 plans from upstream. They also have a
>> new version (4.2) in beta, that could go on a branch in the Debian
>> postbooks VCS (and maybe experimental) for testing with PostgreSQL 9.3.
>> Did you do any further testing with 9.3 to see if further problems exist?
> No, I was trying to give postbook a test-drive based on your recent
> blog post. I've stopped after this problem.
Ok, thanks for the feedback. I've been using it with PostgreSQL 9.1 in
I'll update you when a newer package is ready or when there is other
feedback from upstream
> BTW, the instructions appear to create a superuser called admin, is it
> really necessary?
PostBooks GUI has a user management feature that allows you to manage
users in PostgreSQL and give them access to some or all PostBooks features
I suspect they are using the PostgreSQL superuser rights to enable that
all-in-one management GUI
More information about the pkg-xtuple-maintainers