Useful comparison of MySQL and PostgreSQL open source database software.
MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with propriety database software.
A student at UC Davis has created some stunning visualizations of open source software contributions, including Eclipse, Python, Apache httpd and Postgres.
PostgreSQL 8.3 has been released and available for download. PostgreSQL considered as the world’s most advanced open source database. From the announcement page: This release includes a record number of new and improved features which will greatly enhance PostgreSQL for application designers, database administrators, and users, with more than 280 patches by dozens of PostgreSQL [...]
PostgreSQL is an object-relational database management system. This site has published excellent Postgresql 8.3 commands cheat sheet. => Download / View at Postgres onLine journal [ postgresonline.com ]
By default, PostgreSQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home computer or from web server. Step # 1: Login over ssh if server is outside your IDC Login over ssh to remote PostgreSQL database server: $ ssh email@example.com Step [...]
Using UNIX pipe concept one can dump database to another server securely using ssh protocol. All you need remote execution rights for the ‘dd’ command, over SSH. This allows you to run database dumps across an encrypted channel. Dump Postgres Database using ssh Use pg_dump command command: pg_dump -U USERNAME YOUR-DATABASE-NAME | ssh firstname.lastname@example.org “dd [...]