postgresql – 在docker alpine linux容器中的Postgres

前端之家收集整理的这篇文章主要介绍了postgresql – 在docker alpine linux容器中的Postgres前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我试图让postgres 10.0在docker容器中工作.我有以下Dockerfile:

FROM postgres:10.0-alpine

RUN apk add openrc --no-cache

USER postgres

RUN /etc/init.d/postgresql start
RUN psql --command "IF NOT EXISTS (SELECT FROM pg_catalog.pg_user WHERE usename = 'user') THEN CREATE USER user WITH SUPERUSER ENCRYPTED PASSWORD 'password'; END IF;"
RUN createdb main

EXPOSE 5432

VOLUME  ["/etc/postgresql","/var/log/postgresql","/var/lib/postgresql"]

CMD ["/usr/lib/postgresql/10.0/bin/postgres","-D","/var/lib/postgresql/10.0/main","-c","config_file=/etc/postgresql/10.0/main/postgresql.conf"]

我收到以下错误

/bin/sh: /etc/init.d/postgresql: not found

似乎/etc/init.d/postgresql确实缺失了.我究竟做错了什么?

解决方法

我完成了这个Dockerfile:

FROM postgres:10.0-alpine

USER postgres

RUN chmod 0700 /var/lib/postgresql/data &&\
    initdb /var/lib/postgresql/data &&\
    echo "host all  all    0.0.0.0/0  md5" >> /var/lib/postgresql/data/pg_hba.conf &&\
    echo "listen_addresses='*'" >> /var/lib/postgresql/data/postgresql.conf &&\
    pg_ctl start &&\
    psql -U postgres -tc "SELECT 1 FROM pg_database WHERE datname = 'main'" | grep -q 1 || psql -U postgres -c "CREATE DATABASE main" &&\
    psql --command "ALTER USER postgres WITH ENCRYPTED PASSWORD 'mysecurepassword';"

EXPOSE 5432

此dockerfile创建数据库’main'(如果不存在),启动postgres并设置默认用户密码

猜你在找的Postgre SQL相关文章