Novell PLATESPIN ORCHESTRATE 2.0.2, Руководство по установке и настройке, Страница: 38 / 132

38 PlateSpin Orchestrate 2.0 Installation and Configuration Guide
no
vd
ocx
(e
n)
13
Ma
y 20
09
host all all 0.0.0.0/0 trust
NOTE: After initial configuration, you can replace the
0.0.0.0/0
with a more restrictive mask. In
a high availability server configuration, make sure that each host in the high availability cluster is
enabled as a remote host.
After you make the change to the
pg_hba.conf
file, you need to specify the following command so
that you do not receive an error when remote hosts try to connect:
pg_ctl reload
If
pg_hba.conf
is not configured when attempting to connect, an error similar to the following is
displayed:
psql: FATAL: no pg_hba.conf entry for host "164.99.15.64", user "postgres",
database "postgres", SSL off
Depending on the environment, you might have to perform some additional configuration for remote
database setup. Editing the
listen_addresses
section of the
postgresql.conf
file enables the
database server to listen for incoming connections on the specified IP addresses. The following is
excerpt from that section of the file:
listen_addresses = 'localhost'
# what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
After you modify the
listen_addresses
entry in
postgresql.conf
, use the following command
to restart the PostgreSQL server (recommended in the PostgreSQL documentation):
pg_ctl restart
Logging in Locally to the PostgreSQL Database
When you have installed the database, the next step is to check that you can connect to the database
on the database host. The default admin username is
postgres
. Use the following commands to set
up a password for the postgres user on the database host machine:
psql
NOTE: Remember the password. You need it to log in later to log in to the database.
Running this command results in a screen like this:
Welcome to psql 8.1.11, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# alter user postgres password 'pass';
ALTER ROLE
postgres=#