On 23/09/13 17:50, Felipe Sateler wrote: > On Mon, Sep 23, 2013 at 12:16 PM, Daniel Pocock <[email protected]> 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 >>> (42703) >>> >>> procpid was renamed to pid in 9.2 and is not coming back[1]. >>> >>> 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 wheezy 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 -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
