Using PostgreSQL as Kill Bill database

[daniel.lan...@gmail.com]

Hi,

we want to use PostgreSQL as default database for Kill Bill.

Do Kill Bill supports the PostgreSQL by default?
So is it possible to integrate PostgreSQL by setting the JDBC config properties? Is it that easy?

Thanks for your help!
Daniel

[Pierre-Alexandre Meyer]

Hello Daniel,

PostgreSQL isn't supported yet, see: https://github.com/killbill/killbill/issues/273

If you want to help getting it implemented, let us know and we can coordinate the efforts.

Cheers,

--
You received this message because you are subscribed to the Google Groups "Kill Bill users mailing-list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to killbilling-us...@googlegroups.com.
To post to this group, send email to killbill...@googlegroups.com.
Visit this group at http://groups.google.com/group/killbilling-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/killbilling-users/f533ab02-5291-41ce-a402-f55a9084ef05%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Pierre

[daniel.lan...@gmail.com]

Thanks for the quick reply.

I'll track your issue.

Best regards
Daniel

[raphael...@gmail.com]

Hi guys,

I saw the issue is resolved and killbill supports killbill now

How tested is the postgres support? Is anyone using it in production? Is there any limitations? adapters etc?

Thanks

[Pierre-Alexandre Meyer]

Hi Raphael,

On Tue, Nov 22, 2016 at 7:56 AM, <raphael...@gmail.com> wrote:

I saw the issue is resolved and killbill supports killbill now

How tested is the postgres support? Is anyone using it in production? Is there any limitations? adapters etc?

We know of at least one Kill Bill user on PostgreSQL in production. To get started, make sure to install the DDL bridge, before installing the regular DDL.

While we do have automated regression tests on PostgreSQL, the core team doesn't have first hand experience of running Kill Bill on PostgreSQL in production. We want a first class integration though, so please report if you find any issue.

--

Pierre

[raphael...@gmail.com]

Thanks Pierre, I did install it (a year later).

Seems to be working fine so far. I put the commands together in a bash script that i uploaded on pastebin. Hope it can help other people get started.

The script installs java, postgres and killbill and should run on centos 7

You can download it here https://pastebin.com/raw/67ARPQrU


It needs to run as root and the passwords are insecure so definitely dont use this for production but it should be a good starting point for people who wanna get going with killbill and postgres

I do get an error when preparing database for postgres:

psql:/opt/killbill/ddl-postgresql.sql:11: ERROR: must be owner of language plpgsql

I didnt look much into it, some people suggest to get around it by giving the db user superuser privileges of the database but i would like to figure out a "real" solution. Any idea ?

[Pierre-Alexandre Meyer]

On Fri, Apr 27, 2018 at 9:01 PM, <raphael...@gmail.com> wrote:

I do get an error when preparing database for postgres:

psql:/opt/killbill/ddl-postgresql.sql:11: ERROR:  must be owner of language plpgsql

I didnt look much into it, some people suggest to get around it by giving the db user superuser privileges of the database but i would like to figure out a "real" solution. Any idea ?

Superuser privileges should only be needed when you install the PostgreSQL bridge (to install the compatibility functions). You shouldn't need such privileges to run (or even upgrade) Kill Bill.

--

Pierre