Postgresql using lxd faild to find address

From: Scottix <scottix(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql using lxd faild to find address
Date: 2016-10-10 15:25:05
Message-ID: CANKFHZ_SAUVW0MAC6FoO4tV=gpdJUeodG-Y1d5=6OaXOw+EbfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi I am using postgresql 9.5 in lxd container on Ubuntu. Using the stock
64bit 16.04 ubuntu image. Postgres is working just fine within the
container, but when I try to assign the ip address associated to the
container it fails to recognize it at boot. When I restart postgresql it
recognizes it just fine. So it seems like it is not getting the ip address,
maybe it is a little bit slower. Anyway to delay the boot time?

Steps to reproduce:
1. Setup lxd container
2. Install postgresql-9.5
3. Configure ip address in the config
4. restart container

Symptoms:
1. postgresql running fine
2. No ip address assigned to postgresql

Logs:
2016-10-10 14:40:33 UTC [143-1] LOG: could not bind IPv4 socket: Cannot
assign requested address
2016-10-10 14:40:33 UTC [143-2] HINT: Is another postmaster already
running on port 5432? If not, wait a few seconds and retry.
2016-10-10 14:40:33 UTC [143-3] WARNING: could not create listen socket
for "10.0.3.51"
2016-10-10 14:40:33 UTC [144-1] LOG: database system was shut down at
2016-10-07 23:05:34 UTC
2016-10-10 14:40:33 UTC [144-2] LOG: MultiXact member wraparound
protections are now enabled
2016-10-10 14:40:33 UTC [143-4] LOG: database system is ready to accept
connections
2016-10-10 14:40:33 UTC [148-1] LOG: autovacuum launcher started

#systemctl restart postgresql

2016-10-10 15:17:33 UTC [2353-1] LOG: database system was shut down at
2016-10-10 15:17:32 UTC
2016-10-10 15:17:33 UTC [2353-2] LOG: MultiXact member wraparound
protections are now enabled
2016-10-10 15:17:33 UTC [2352-1] LOG: database system is ready to accept
connections
2016-10-10 15:17:33 UTC [2357-1] LOG: autovacuum launcher started

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Periko Support 2016-10-10 16:24:48 psql 9.3 automatic recovery in progress
Previous Message Periko Support 2016-10-10 15:20:25 Re: HA Cluster Solution?