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

Aug 6, 2013

AD:

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 = '*'

AD:

Cloud Nine

No Comments, Comment or Ping

Reply to “could not bind IPv4 socket: Cannot assign requested address エラー by PostgreSQL”

Warning: Undefined variable $user_ID in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/themes/grid_focus_public_mizo/comments.php on line 66

You must be logged in to post a comment.