postgresql – 在docker alpine linux容器中的Postgres
发布时间:2020-12-13 15:59:12 所属栏目:百科 来源:网络整理
导读:我试图让postgres 10.0在docker容器中工作.我有以下Dockerfile: FROM postgres:10.0-alpineRUN apk add openrc --no-cacheUSER postgresRUN /etc/init.d/postgresql startRUN psql --command "IF NOT EXISTS (SELECT FROM pg_catalog.pg_user WHERE usename
我试图让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并设置默认用户密码 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |