Если при старте PostgreSQL 9.1 (или любого другого) вы ловите что-то похожее:
# service postgresql start
Starting PostgreSQL2011-10-11 14:12:19 EEST LOG: could not bind IPv6 socket: Cannot assign requested address
2011-10-11 14:12:19 EEST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2011-10-11 14:12:19 EEST WARNING: could not create listen socket for "localhost"
2011-10-11 14:12:19 EEST FATAL: could not create any TCP/IP sockets
pg_ctl: could not start server
Examine the log output.
то решение проблемы - очень тривиально: просто поправить listen_addresses
директиву в конфигурационном файле postgresql.conf
(он может распологаться в /var/lib/pgsql/data
или /Library/PostgreSQL/9.1/data
) c:
# - Connection Settings -
#listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
на:
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
и перезапустить PostgreSQL.