upgrade error

  * service[postgresql] action nothing (up to date)
  * execute[/opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef] action run
================================================================================
Error executing action `run` on resource 'execute[/opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef]'
================================================================================


Mixlib::ShellOut::ShellCommandFailed
------------------------------------
Expected process to exit with [0], but received '1'
---- Begin output of /opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef ----
STDOUT: 
STDERR: createdb: could not connect to database postgres: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
---- End output of /opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef ----
Ran /opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef returned 1


Resource Declaration:
---------------------
# In /opt/opscode/embedded/cookbooks/private-chef/recipes/postgresql.rb

161: execute "/opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef" do
162:   user node['private_chef']['postgresql']['username']
163:   not_if database_exists
164:   retries 30
165:   notifies :run, "execute[migrate_database]", :immediately
166: end
167: 



Compiled Resource:
------------------
# Declared in /opt/opscode/embedded/cookbooks/private-chef/recipes/postgresql.rb:161:in `from_file'

execute("/opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef") do
  action "run"
  retries 0
  retry_delay 2
  command "/opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef"
  backup 5
  returns 0
  user "opscode-pgsql"
  cookbook_name :"private-chef"
  recipe_name "postgresql"
  not_if "/opt/opscode/embedded/bin/chpst -u opscode-pgsql /opt/opscode/embedded/bin/psql -d 'template1' -c 'select datname from pg_database' -x|grep opscode_chef"
end



[2013-02-26T13:12:09-07:00] ERROR: Running exception handlers
[2013-02-26T13:12:09-07:00] ERROR: Exception handlers complete
Chef Client failed. 2 resources updated
[2013-02-26T13:12:09-07:00] FATAL: Stacktrace dumped to /opt/opscode/embedded/cookbooks/cache/chef-stacktrace.out
[2013-02-26T13:12:09-07:00] FATAL: Mixlib::ShellOut::ShellCommandFailed: execute[/opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef] (private-chef::postgresql line 161) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of /opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef ----
STDOUT: 
STDERR: createdb: could not connect to database postgres: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
---- End output of /opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef ----
Ran /opt/opscode/embedded/bin/createdb -T template0 -E UTF-8 opscode_chef returned 1
[root@opc-be02 ~]# "/opt/opscode/embedded/bin/chpst -u opscode-pgsql /opt/opscode/embedded/bin/psql -d 'template1' -c 'select datname from pg_database' -x|grep opscode_chef"
-bash: /opt/opscode/embedded/bin/chpst -u opscode-pgsql /opt/opscode/embedded/bin/psql -d 'template1' -c 'select datname from pg_database' -x|grep opscode_chef: No such file or directory
[root@opc-be02 ~]# /opt/opscode/embedded/bin/ch
chef-apply   chef-client  chef-shell   chef-solo    chpst        
[root@opc-be02 ~]# /opt/opscode/embedded/bin/ch
chef-apply   chef-client  chef-shell   chef-solo    chpst        
[root@opc-be02 ~]# /opt/opscode/embedded/bin/chpst -u opscode-pgsql /opt/opscode/embedded/bin/psql -d 'template1' -c 'select datname from pg_databse' -x
could not change directory to "/root"
psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[root@opc-be02 ~]# /opt/opscode/embedded/bin/chpst -u opscode-pgsql /opt/opscode/embedded/bin/psql -d 'template1' -c 'select datname from pg_databse' -x |grep opscode_chef
could not change directory to "/root"
psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?