In this tutorial I want to share to you on how to install PostgreSQL v8.4.3 on FreeBSD/PC-BSD. This tutorial should be applicable on other BSD families (NetBSD, OpenBSD) and Linux distros (Slackware, Centos, Ubuntu, Redhat, Debian, etc) because we will install PostgreSQL from source distribution file.
[...]
For the x64 platform you need to modify some settings in the /etc/sysctl.conf file and also the memory swap space.
I have 2GB RAM and set the swap memory to 2GB also, but in the installation stage the expected swap space is 3GB
[...]
Sometime you want to backup a table and all its contents in MySQL Database and then you might want to restore or copy the table to different MySQL database
[...]
In some cases you might want to change or reset MySQL root password. To do this there are two ways, using mysqladmin command or using UPDATE sql command
[...]