Re: [Gnumed-devel] removing test data

[Jim Busser]

On 8-Aug-09, at 12:02 AM, Karsten Hilbert wrote:

postgres=# alter role postgres with password '123';

Don't do that. It will prevent Debian from doing database

maintenance.

I don't understand. How can the password be required to be anything other than something of the human sysadmin's choosing?

http://www.stuartellis.eu/articles/postgresql-setup/#config-server

Configuring the PostgreSQL Server

First, set a strong password for the postgres role. This role automatically has unrestricted access to the cluster and everything held within those databases, so set a password for this role. To avoid potential risk, do this as soon as you have installed PostgreSQL, even if you do not currently intend to enable remote access, and are sure that no other users can login on the local system.

As the configuration defaults to ident authentication for local access, we must use the system account postgres to login with the postgres role. Enter this command at the server:

sudo postgres psql

Once logged in to the SQL interface, set a password for the postgres role:

ALTER ROLE postgres WITH ENCRYPTED PASSWORD 'mypassword';

You need this password to connect to the PostgreSQL server remotely with the postgres role, as described below.