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
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? |