could not bind IPv4 socket: Cannot assign requested address エラー by PostgreSQL

Ayumi

11 years ago

VagrantのUbuntuにPostgreSQLをインストールして、立ち上げようとすると下記のようなエラーがでたので、メモしておきます。

エラー内容

$ apt-get update
$ apt-get install postgresql
$ psql --version
psql (PostgreSQL) 9.1.9
$ service postgresql start
* Restarting PostgreSQL 9.1 database server                                                                                                                                
* The PostgreSQL server failed to start. Please check the log output:
2013-08-05 22:19:14 UTC LOG:  could not bind IPv4 socket: Cannot assign requested address
2013-08-05 22:19:14 UTC HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2013-08-05 22:19:14 UTC WARNING:  could not create listen socket for "localhost"
2013-08-05 22:19:14 UTC FATAL:  could not create any TCP/IP sockets

$ apt-get update

$ apt-get install postgresql

$ psql --version

psql (PostgreSQL) 9.1.9

$ service postgresql start

* Restarting PostgreSQL 9.1 database server

* The PostgreSQL server failed to start. Please check the log output:

2013-08-05 22:19:14 UTC LOG: could not bind IPv4 socket: Cannot assign requested address

2013-08-05 22:19:14 UTC HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.

2013-08-05 22:19:14 UTC WARNING: could not create listen socket for "localhost"

2013-08-05 22:19:14 UTC FATAL: could not create any TCP/IP sockets

解決方法

コネクション指定の問題なので、下記のように変更しました。

$ vi /etc/postgresql/9.1/main/postgresql.conf
#listen_addresses = 'localhost'
&#12288;&darr;
listen_addresses = '*'

$ vi /etc/postgresql/9.1/main/postgresql.conf

#listen_addresses = 'localhost'

　↓

listen_addresses = '*'