Re: Post Install / Secure PostgreSQL

Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> writes:
> I am brand new to PostgreSQL and coming from MySQL. My question is
> does anyone know after I install PostgreSQL on my Linux server, is
> there a script that secures the database like MySQL offers in most
> Linux distributions? I think the script for MySQL is
> "/usr/bin/mysql_secure_installation". I checked and there doesn't
> appear to be on located there specifically for PostgreSQL. This script
> is nice because it lets people who are new to databases set root
> password, disable anonymous accounts, remove anonymous accounts,
> remove test databases, disable remote root logins to databases.

The reason mysql has such a script is that their installations are
insecure by default. Postgres installations aren't, unless you
tell initdb to use "trust" mode, which isn't usual in prepackaged
distributions.

regards, tom lane