Installing PostgreSQL 9.2 with Chef postgresql

Here's what finally fixed it for me:

1. run update-alternatives --remove postmaster.1.gz /usr/share/postgresql/9.1/man/man1/postmaster.1.gz

2. Use the conf below.

Snip:

postgresql: {    enable_pgdg_apt: true,    dir: "/etc/postgresql/9.2/main",    config: {        data_directory: "/var/lib/postgresql/9.2/main",        hba_file: "/etc/postgresql/9.2/main/pg_hba.conf",        ident_file: "/etc/postgresql/9.2/main/pg_ident.conf",        external_pid_file: "/var/run/postgresql/9.2-main.pid",        ssl_key_file: "/etc/ssl/private/ssl-cert-snakeoil.key",        ssl_cert_file: "/etc/ssl/certs/ssl-cert-snakeoil.pem",    },    client: {        packages: ["postgresql-client-9.2",],    },    server: {        packages: ["postgresql-9.2", "postgresql-server-dev-9.2"],    },    contrib: {        packages: ["postgresql-contrib-9.2"],    },    password: {      postgres: 'postgres'    },    pg_hba: [      {type: 'local', db: 'all', user: 'all', addr: nil, method: 'trust'},      {type: 'host', db: 'all', user: 'all', addr: '127.0.0.1/32', method: 'trust'},      {type: 'host', db: 'all', user: 'all', addr: '::1/128', method: 'trust'}    ],    version: "9.2",},

I was able to fix this by setting the directory:

node.set['postgresql']['dir'] = "/var/lib/postgresql/9.2/main"

Looks like this is the same issue: http://tickets.opscode.com/browse/COOK-2113