Upstart PostgreSQL

postgresql.conf

start on runlevel [2345]
stop on runlevel [016]
respawn

script
exec su -c "/etc/postgresql/bin/postgres -D /usr/local/pgsql/data" postgres
end script

# note
# change the path ( /etc/postgresql/bin/postgres ) to the directory
# you installed postgresql if it different from this directory.

Why are you using the script stanza here? Just use exec.

Thanks for pointing that out. Didn't know you could omit it.