|
From: | Jim Busser |
Subject: | Re: [Gnumed-devel] removing test data |
Date: | Sat, 08 Aug 2009 08:57:07 -0700 |
On 8-Aug-09, at 12:02 AM, Karsten Hilbert wrote:
I don't understand. How can the password be required to be anything other than something of the human sysadmin's choosing? 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. |
[Prev in Thread] | Current Thread | [Next in Thread] |