Timescale with replication advice

I was wondering if any list members have experience setting up TimeScale with streaming replication. http://www.timescale.com/ I plan to use a collection of 2-5 EC2 instances in AWS and want to set up 1 master -> N slaves to allow read-only connection pooling on the

Re: Enforce primary key on every table during dev?

I found this thread very interesting. A pivot table is a perfectly valid use case where a compound unique key on two or more columns performs the same function as a primary key without one. I’m not nearly as familiar with Postgres as I am with MySQL (which is why I recently joined this list).

Re: Creating complex track changes database - challenge!

t; this one. > > what about setting up trigger to metadata (structural table) to find if > column was added for example? > > Best, > Jacek > > 2018-02-26 16:43 GMT+01:00 geoff hoffman <mailto:ge...@rxmg.com>>: > > > There’s https://flywaydb.org/

Re: Creating complex track changes database - challenge!

There’s https://flywaydb.org/ and http://www.liquibase.org/ More: https://dbmstools.com/version-control-tools Also, if you know PHP, Laravel database migrations have worked great for us! https://

Re: Any hope for more specific error message for "value too long..."?

Dang. +1 for that. Not that you hadn’t thought of it, and not that it’s actually a viable solution in a jiffy, but switch that mess to JSONB and your problems are over.

Re: postgres not starting

Restore a backup or reinstall Postgres. The default Postgres data tables need to be there and owned by the user Postgres runs as. > On Feb 15, 2018, at 5:21 PM, Azimuddin Mohammed wrote: > > Hello, > I am unable to start postgres on one of the server > I am getting below error "HINT: is anot

Re: Ensure extension exists

On Feb 2, 2018, at 12:38 PM, Peter Eisentraut wrote: > > On 2/1/18 19:47, Geoffrey Hoffman wrote: >> I want to use the pgcrypto extension with a particular database. Does it >> exist permanently and survive a server reboot? Or if not, how do you ensure >> it runs when the server restarts? > >

Working with JSONB data having node lists

JSONB fields are very attractive for our current use, particularly as straight key-value pairs in the JSONB data; but we are having trouble finding documentation on how to query lists (of scalars or objects) in nodes of the JSONB data. ~~~ I have the table as follows: CREATE TABLE public.cont