Postgresql using lxd faild to find address - Mailing list pgsql-general

From Scottix
Subject Postgresql using lxd faild to find address
Date
Msg-id CANKFHZ_SAUVW0MAC6FoO4tV=gpdJUeodG-Y1d5=6OaXOw+EbfA@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql using lxd faild to find address  (Scott Mead <scottm@openscg.com>)
List 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



pgsql-general by date:

Previous
From: "Natan Abolafya"
Date:
Subject: BDR: changing dsn on a running node
Next
From: Manuel Gómez
Date:
Subject: Re: forcing a table (parent in inheritance) tor emain empty