Tag Archives: postgres

PHP and PostgreSQL on Windows

PostgreSQL is now easy to install on Windows using its installer. However, integrating it with PHP in Windows usually has problems. No matter how you configure PHP and the DLL for postgres extension, it will not work out of the … Continue reading

Posted in PostgreSQL | Tagged , , , , , , , | 3 Comments

Setting PostgreSQL Authentication Method to MD5

Once again, we acquired another rental server with pre-installed postgreSQL. I have created a superuser immediately by invoking these commands: However, our supervisor has created a password for some reason to postgres username. After several tries, I can’t login to … Continue reading

Posted in Linux | Tagged , , , , , , | Leave a comment

Messing Around with PostgreSQL

Out client was using PostgreSQL for their database we often have a hard time moving our project repository from one server to another. The problem was that we need to manage username and passwords. When we are rushed to setup … Continue reading

Posted in Linux | Tagged , , , , , , | Leave a comment

Installing Postgres on CentOS via SSH

We got stuck here when we are trying to run a Postgres server in our rental server.  After getting the login information of the SSH connection and the root password, I immediately downloads the Postgres 8.3.5 for linux (the source) … Continue reading

Posted in Linux | Tagged , , , , | Leave a comment