Просмотр документа hui.txt

############################################################ 
# 
# docker build --rm -t local/c7-9-pg . 
# 
# docker run -p 5432:5432 -d local/c7-9-pg 
# 
# docker run --name pgadmin -p 5051:80 \ 
# -e "PGADMIN_DEFAULT_EMAIL=user@pgadmin.com" \ 
# -e "PGADMIN_DEFAULT_PASSWORD=pgadmin" -d dpage/pgadmin4 
############################################################ 
FROM centos:7.9.2009 
COPY ./startUpScript.sh / 
COPY ./postgresql.conf / 
RUN yum install -y epel-release wget \ 
&& yum clean all \ 
&& yum install -y 
https://download.postgresql.org/pub/repos/yum/reporpms/EL-7
x86_64/pgdg-redhat-repo-latest.noarch.rpm \ 
&& yum install -y postgresql12-server postgresql12-contrib \ 
&& chown root /startUpScript.sh \ 
&& chgrp root /startUpScript.sh \ 
&& chmod 777 /startUpScript.sh 
 
EXPOSE 5432 
 
CMD ["/bin/bash","-c","/startUpScript.sh && tail -f /dev/null"]

postgresql.conf 
listen_addresses = '*' 
port = 5432 
logging_collector = on 
log_filename = 'postgresql-%a.log' 
log_truncate_on_rotation = on 
log_rotation_age = 1d 
log_rotation_size = 0


startUpScript.sh 

#!/bin/bash 
su -l postgres -c /usr/pgsql-12/bin/initdb 
ПАО Ростелеком   
Методические рекомендации по проведению итоговой аттестации DevOps-инженер с нуля (v1.0.4) Страница 55 из 79 
 
echo "host    all             all             0.0.0.0/0               
trust" >> /var/lib/pgsql/12/data/pg_hba.conf 
cp ./postgresql.conf /var/lib/pgsql/12/data/postgresql.conf 
su -l postgres -c "/usr/pgsql-12/bin/pg_ctl -D /var/lib/pgsql/12/data -l /tmp/pg_logfile start"  
 
set -e 
 
psql -v ON_ERROR_STOP=1 --username "postgres" --dbname "postgres" <<
EOSQL 
 CREATE USER tester; 
 CREATE DATABASE "tempdb-15"; 
 GRANT ALL PRIVILEGES ON DATABASE "tempdb-15" TO tester; 
    CREATE TABLE snowboarder ( equip_id serial PRIMARY KEY, title 
varchar (50) NOT NULL,company varchar (25) NOT NULL, size varchar (25) 
check (size in ('XS', 'S', 'M', 'L', 'XL', 'XXL'))); 
    INSERT INTO snowboarder (title, company, size) VALUES 
('snowboard', 'burton', 'XL'); 
    INSERT INTO snowboarder (title, company, size) VALUES ('binding', 
'burton', 'XL'); 
    INSERT INTO snowboarder (title, company, size) VALUES ('boots', 
'burton', 'XL'); 
EOSQL