logical replication on 9.6: replica configuration

2019-05-12 Thread Paul Costello
I need to create a read-only replica in AWS environment. I can't use AWS/RDS built-in read replica functionaility due to security concerns, so I'm tied to using logical replication, on postgres 9.6. How do I configure a replica db to receive the contents of the replication slot on master? I was

Re: Jira database won't start after disk filled up

2018-03-02 Thread Paul Costello
2, 2018 at 4:32 PM, Paul Costello wrote: > >> I have a database that wouldn't start due to the disk filling up back on >> 1/10, unbeknownst to us until 2/27. This is jira, so it's critical data. >> It appears jira was running in memory that entire time. >>

Jira database won't start after disk filled up

2018-03-02 Thread Paul Costello
I have a database that wouldn't start due to the disk filling up back on 1/10, unbeknownst to us until 2/27. This is jira, so it's critical data. It appears jira was running in memory that entire time. I needed to run pg_resetxlog -f in order to start the database. It started, but upon logging i