PostgreSQL Archives

Change PostgreSQL Locale

wrote by Rafael Marangoni, from Suporte Linux team. This article explains how to change the default PostgreSQL Locale. Be careful, because we're considering that you do not have data on postgresql instance. First, we need to stop the postgres service (if was not already stopped): /etc/init.d/postgresql stop Then we need to remove all data files ... Read more

Configure PostgreSQL to accept connections from network

by rafael

wrote by Rafael Marangoni, from Consultoria Linux team. By default, on some distros, PostgreSQL will only accept connections from localhost. When you have only access from localhost (from localhost Apache, by example) everything is ok, but when you need that postgresql accepts connections for other hosts, you need to make some configs. First of all, ... Read more