[chef] Re: Re: Chef and Postgresql

[Seth Falcon < >]

 writes:

> I had left some comments in
> https://tickets.opscode.com/browse/CHEF-4823 regarding this, since I'd
> looked into it as well.
>
> Basically, it won't work, because the cookbooks (at present) all
> assume the PostgreSQL server is on the localhost.

Makes sense.

> On Wed, Dec 4, 2013 at 12:39 AM,  
> <
 >
>  wrote:
>> Hi Seth,
>> I'm trying to setup an independent postgresql databse with my open source
>> chef-server. According to my research we can achieve the same by using
>> chef-server.rb, and specifying required attribute details for postgresql in
>> there. I mention the following in the file:
>> postgresql['data_dir'] = '/var/lib/pgsql/data'
>> postgresql['dir'] = '/var/lib/pgsql'
>> postgresql['log_directory'] = '/var/lib/pgsql/data/pg_log'
>> postgresql['home'] = '/var/lib/pgsql'
>> postgresql['listen_address'] = 'ip-address-of-the-postgresql server'
>> postgresql['port'] = "5433"
>> postgresql['vip'] = "ip-address-of-the-postgresql server"
>> postgresql['trust_auth_cidr_addresses'] = '0.0.0.0/0'
>>  But i'm getting error in creating the user "opscode-pgsql" itself. Can you
>> point out where i'm going wrong.
>> Any insights in the matter will be appreciated.

If you want hack on the cookbooks to allow chef-server-ctl reconfigure
to be able to handle an externally located postgres server, you'll want
to start here:

https://github.com/opscode/omnibus-chef-server/blob/master/files/chef-server-cookbooks/chef-server/recipes/postgresql.rb

If you want to build a one-off, you could set everything up with the
local postgres, dump and load into your postgres, and then reconfigure
just the VIP and I think you might get pretty close.

If your goal is to decompose the Chef Server into its separate services
for scale, you should instead install Chef Server on the db node and
disable all services except for postgres.

Note that we only test Chef Server installed via the self-contained
omnibus. So you are going off the groomed runs into unpatrolled
territory if you start wiring in components that didn't come with the
package. It's easy to imagine that this will cause difficulty when
dealing with future upgrades.

+ seth



-- 
Seth Falcon | Development Lead | Opscode | @sfalcon