Capistrano postgresql error when running cap deploy:update

....
Can't find the 'libpq-fe.h header
....

Fix:

yum install postgresql-devel # or apt-get install ....

Nginx startup scripts

Create nginx startup script in /etc/init.d/nginx

cd /opt
wget -O init-rpm.sh http://library.linode.com/assets/603-init-rpm.sh
mv /opt/init-rpm.sh /etc/rc.d/init.d/nginx
chmod +x /etc/rc.d/init.d/nginx
chkconfig --add nginx
chkconfig nginx on

via: linode

Mac os mysql localhost / 127.0.0.1 problem

Mac os fix localhost / 127.0.0.1 problem: Add to php.ini:

pdo_mysql.default_socket=/tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

restart apache server:

sudo apachectl restart

Postgres rails socket problem

Postgres problem in rails

could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

Resolve:

mkdir /var/pgsql_socket/ 
ln -s /private/tmp/.s.PGSQL.5432 /var/pgsql_socket/

via: http://jaygoldman.com/2012/11/fixing-postgres-connection-errors-on-mountain-lion/