Carlos Mennens <carlos.mennens@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
