[chef] Re: Re: PostgreSQL cookbook questions / issues

[Jeffrey Jones < >]

On 17/05/13 10:02, Jeff Blaine wrote:
> > After much trial and tribulation I have managed to get PostgreSQL
> > installed BUT I have had to modify various recipes in the PostgreSQL
> > cookbook which seems...strange since I cannot believe I am the first
> > person who has tried the above.
>
> It's not that hard to believe. The number of people like yourself
> who would have flailed like you've been dealing with, unfortunately,
> and then come for advice with a pull request in hand... is very
> small.
>
> > 3) No libpqxx-devel
> >
> > On all CentOS systems I have ever set-up with ruby and the pg gem I have
> > needed to install the libpqxx-devel library. However I can see no
> > mention of this package in any of the PostgreSQL chef scripts, I am
> > therefore puzzled how this has worked up until now, in my copy of the
> > cookbook I added this to the client packages.
>
> It's 'postgresql-devel' and is installed by the postgresql::client
> recipe which is called from the postgresql::server recipe.
Well bugger me with a fishfork. I could have sworn that I had to install 
libpqxx-devel in the past and that not having it this time around was 
causing trouble but I have just removed it from the package list, 
re-created the VM (God I love Vagrant) and it all worked (as long as I 
had the PATH variable set to include the path to pg_config as I 
mentioned in point 4).

Thank you for that, consider number 3 answered!

> In attributes/default.rb:
>
> when "redhat", "centos", "scientific", "oracle"
>   if node['platform_version'].to_f >= 6.0
>     default['postgresql']['client']['packages'] = %w{postgresql-devel}
> #...
>   else
>     default['postgresql']['client']['packages'] = 
> ["postgresql#{node['postgresql']['version'].split('.').join}-devel"]
> #...
>   end
> #...
> end
>
> The postgresql-devel package has its own dependency on the postgres
> package (the clienty binaries, etc).
>
> Sorry that that is all I can assist with.