Items tagged: postgresql

Creating Users: an illustration of the differences between PostgreSQL and MySQL

Thursday, 19 November 2009

Like many starting out in websites and databases my first experience was with MySQL. I had no choice since the hosting service I used only offered MySQL. This is still the case for a lot of hosting - you get the standard LAMP stack and nothing more. I had read on the web that everyone is using MySQL, so how bad could it be? I was forgetting the maxim that quality and popularity are inversely proportional. BTW: it’s not really popularity in this case - it’s the most users - think Windoze.

read more

postgresql config file permissions on Gentoo

Thursday, 20 September 2007

Note to self: on Gentoo postgresql configuration files (pg_hba.conf and postgresql.conf found in /var/lib/postgresql/data) need to be owned by the postgres user. So if you edit them as root, reset the owner:group before restarting postgresql.

read more