Re: What is the accepted practice to automate initdb (PostgreSQL 9.6) to a non-default directory?

From: Mike Lonergan <mikethecanuck(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: What is the accepted practice to automate initdb (PostgreSQL 9.6) to a non-default directory?
Date: 2018-03-04 17:25:41
Message-ID: CAEzHCEOvAWgyz_kLF6xrL0Wd7iYvMRDw+B8kQYzm4HnXutrMPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

For reference by any future novices who might stumble across this thread
(and for the morbid curiosity of anyone on the list), here's the shell
script I've generated to solve this challenge in an AWS EC2 environment:
https://github.com/hackoregon/civic-devops/blob/master/bin/create-database-development.sh

On 2 March 2018 at 16:18, Mike Lonergan <mikethecanuck(at)gmail(dot)com> wrote:

> David, thank you as well - that article is fantastic. I'll give this a
> whirl, but on its face it looks like exactly the solution we're after.
> That approach to embedded the env var for the service is new to me -
> addresses a complete blank in my knowledge.
>
> Thanks!
> Mike
>
> On 2 March 2018 at 16:13, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
>> On Fri, Mar 2, 2018 at 5:03 PM, Mike Lonergan <mikethecanuck(at)gmail(dot)com>
>> wrote:
>>
>>>
>>> I'll definitely look into the launch script, see what I can do there.
>>> Any other thoughts folks have would be more than welcome.
>>>
>>
>> ​This recent Planet PostgreSQL link​ seems worth a read.
>>
>> ​https://pgstef.github.io/2018/02/28/custom_pgdata_with_systemd.html​
>>
>> David J.
>>
>>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2018-03-04 22:29:44 Re: Reliable WAL file shipping over unreliable network
Previous Message Stephen Frost 2018-03-04 15:06:40 Re: Reliable WAL file shipping over unreliable network