[chef] Re: PostgreSQL cookbook questions / issues

[Jeff Blaine < >]

> 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.

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.