[chef] Re: issues with postgres 9.2 with postgresql cookbook

[Jeffrey Jones < >]

I had a similar issue on CentOS.

The logic for determining service names etc was a little iffy. Not sure 
about Ubuntu but you might want to have a look.

Here is the pull request I had to make for CentOS: 
https://github.com/rurounijones/postgresql/commit/3e7b1b798648c3b8d524704377b9ebeca49cfe59

It may give you a clue.


On 25/05/13 13:46, Toby Hede wrote:
> Having some issues with the postgresql cookbook.
>
> Using:
> postgresql-cookbook 3.0.0
> ubuntu 12.04 on vagrant (but I can replicate this behaviour on a 12.04
> VM in teh cloud)
>
> The install attempts to restart the pg server nmd is suddenly very
> confused about the version
>
> Error executing action `restart` on resource 'service[postgresql]'
>
> ---- Begin output of /etc/init.d/postgresql restart ----
> STDOUT: * Restarting PostgreSQL 9.2 database server
> [2013-05-24T11:05:41+00:00] FATAL:
> Chef::Exceptions::EnclosingDirectoryDoesNotExist:
> template[/etc/postgresql/9.1/main/postgresql.conf] (postgresql::server
> line 60) had an error:
> Chef::Exceptions::EnclosingDirectoryDoesNotExist: Parent directory
> /etc/postgresql/9.1/main does not exist.
>
>
> My recipe is basically:
> ------------------------------------------------------------
> node.set['postgresql']['version'] = "9.2"
> node.set['postgresql']['enable_pgdg_apt'] = true
>
> include_recipe "postgresql::apt_pgdg_postgresql"
> include_recipe "postgresql::server"
> ------------------------------------------------------------
>
>
> Any help would be appreciated.
>
> Cheers,
> Toby