问题原文
原帖链接 · Dimitrios Desyllas · CC BY-SA 3.0
On an docker image's entrypoint shell script I want to determine if a postgresql container can listen to connections. For mysql I used the following snippet:
while ! mysqladmin ping -h"$MOODLE_DB_HOST" -P $MOODLE_DB_PORT --silent; do
echo "Connecting to ${MOODLE_DB_HOST} Failed"
sleep 1
done
How can I achieve a similar using postgresql?
已采纳解答
原帖链接 · Dimitrios Desyllas · CC BY-SA 4.0
On the dockerfile add:
RUN apt-get update && apt-get install -f -y postgresql-client
Then on the entrypoint script use:
while ! pg_isready -h ${MOODLE_DB_HOST} -p ${MOODLE_DB_PORT} > /dev/null 2> /dev/null; do
echo "Connecting to ${MOODLE_DB_HOST} Failed"
sleep 1
done
Another approach
An another approach is by using netcat:
for count in {1..100}; do
echo "Pinging mysql database attempt "${count}
if $(nc -z ${DB_HOST} ${DB_PORT}) ; then
echo "Can connect into database"
break
fi
sleep 5
done
Where variable ${DB_HOST} contains the database host whilst ${DB_PORT} contains the database port. Thas works on most databases (except if you want to detect its type as well where a custom script is needed).
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
