PostgreSQL is an open source RDBMS (Relational DataBase Management System) that is not only feature rich, fast and light but also easy to use. Its documentation available at its website is a superb way of learning as well. Browsing the documentation and you will find that its way of explaining is no “bullshit” approach, short [...]
Category Archives: PostgreSQL
PostgreSQL – pg_ctl: invalid data in PID file
One fine day, when restarting PostgreSQL :
/usr/local/etc/rc.d/postgresql restart
it complained that
pg_ctl: invalid data in PID file “/postgres/directory/postmaster.pid”
postmaster.pid was the process ID file for PostgreSQL, which indicate PostgreSQL process. If the file exists, it would mean that PostgreSQL is alive and running. If it doesn’t, it would (of cause) mean PostgreSQL have been terminated, either on [...]
Postgres SQL – passwordless login within bash script
Most of the time, we need to write a script to update multiple fields in a database table, pull values from database to fill up other tables or even grab from database and pass it to programs to process. The most annoying thing is every time it tries to connect to the database server, it [...]
