Re: Environment Variable for --data-checksum during initdb

2019-09-07 Thread Ray Cote
On Thu, Sep 5, 2019 at 3:25 PM Ray Cote wrote: > > I'm trying to remember what environment variable can be set --data-checksum before running postgresql-setup initdb. I know I've seen it but it escapes my recall at the moment. > > The PostgreSQL documentation has a ni

Environment Variable for --data-checksum during initdb

2019-09-05 Thread Ray Cote
I'm trying to remember what environment variable can be set --data-checksum before running postgresql-setup initdb. I know I've seen it but it escapes my recall at the moment. The PostgreSQL documentation has a nice page of environment variables for when PostgreSQL is running, but I'm not finding

Re: Debugging Failed Startup

2019-05-02 Thread Ray Cote
On Thu, May 2, 2019 at 4:12 PM Alvaro Herrera wrote: > On 2019-May-02, Ray Cote wrote: > > > Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 > is > > not starting on CentOS 7? > > Was running fine for several weeks then fails to come up

Re: Debugging Failed Startup

2019-05-02 Thread Ray Cote
Spoke too soon, Not coming back after a boot. Seems I can install, run, but not reboot! On Thu, May 2, 2019 at 3:18 PM Ray Cote wrote: > > > On Thu, May 2, 2019 at 2:57 PM Adrian Klaver > wrote: > >> On 5/2/19 11:22 AM, Ray Cote wrote: >> > Does anyone have a hint

Re: Debugging Failed Startup

2019-05-02 Thread Ray Cote
On Thu, May 2, 2019 at 2:57 PM Adrian Klaver wrote: > On 5/2/19 11:22 AM, Ray Cote wrote: > > Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 > > is not starting on CentOS 7? > > Was running fine for several weeks then fails to come up after a re

Debugging Failed Startup

2019-05-02 Thread Ray Cote
Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 is not starting on CentOS 7? Was running fine for several weeks then fails to come up after a reboot. I did change the name of the CentOS7 server, but I don't expect that to have any effect on the database. I'm running debug5

Re: Rationale for aversion to the central database?

2018-04-09 Thread Ray Cote
Maintaining your database logic in version control and versioning the deployed code can be a bit problematic. Conversely, providing a standardized pgsql module through which data is updated and retrieved can help standardize access logic across multiple languages and libraries. And I concur that