Thanks for your answer, I need some special operations like I need to create separate database , suah as my DB ioccx, and create some tables for this database etc. My real intention is not to initialize empty PGDATA directory 在2022年3月26日星期六 UTC+8 02:08:15<[email protected]> 写道：
> 正光，你好！ > > > I want to init postgresql in k8s, try use the code as below to do: > > I would say this happens when the container image is run, latest with an > entrypoint script. > If you study the official docker postgres repository I think this happens > starting from line 63 in the docker-entrypoint.sh > <https://github.com/docker-library/postgres/blob/master/14/bullseye/docker-entrypoint.sh> > > that said ... there wouldn‘t be a need really to try doing this with > Ansible, unless you are doing something very unique > > > > > On 25.03.22 16:44, 曾正光 wrote: > > Hi all, > I want to init postgresql in k8s, try use the code as below to do: > > - name: Get the password for postgresql > kubernetes.core.k8s_info: > kind: secret > name: postgresql-ha-postgresql > namespace: pgdb > register: pgsql_info > - name: > set_fact: > pg_pwd: "{{ pgsql_info |json_query(item) | b64decode }}" > with_items: 'resources[*].data."postgresql-password"' > - name: > debug: msg={{ pg_pwd }} > - name: Install psycopg2 for ansible to be able to create postgresql users > pip: > name: psycopg2-binary > - name: start k8s port forward > shell: nohup kubectl port-forward $(kubectl get pod -l > app.kubernetes.io/component=pgpool -n pgdb -o name|cut -d/ -f2) 5432 -n > pgdb & > - name: Check if database is available > community.postgresql.postgresql_ping: > db: postgres > login_host: 127.0.0.1 > login_port: 5432 > login_user: postgres > login_password: "{{ pg_pwd }}" > register: ping_database > failed_when: ping_database.warnings is defined > - name: Check the DB of ioccx > community.postgresql.postgresql_query: > db: postgres > login_host: 127.0.0.1 > port: 5432 > login_user: postgres > login_password: "{{ pg_pwd }}" > query: | > SELECT datname FROM pg_database where datname = 'ioccx' > encoding: UTF-8 > positional_args: 1 > register: db_ioccx > when: ping_database.is_available > # - name: restore dump to DB of ioccx > # postgresql_db: > # login_host: 127.0.0.1 > # login_user: postgres > # login_password: "{{ pg_pwd }}" > # name: ioccx > # state: restore > # target: 20180626.dump.tar.gz > # target_opts: "--create --clean" > # when: db_ioccx.query_result | length == 0 > - name: "CREATE ROLE ioccadmin" > register: result > retries: 100 > until: result is success > when: db_ioccx.query_result | length == 0 > postgresql_user: > login_host: 127.0.0.1 > login_user: postgres > login_password: "{{ pg_pwd }}" > port: 5432 > state: present > name: ioccadmin > password: "zaq12wsx" > encrypted: true > role_attr_flags: SUPERUSER > - name: "CREATE DATABASE ioccx" > when: db_ioccx.query_result | length == 0 > register: create_database > postgresql_db: > login_host: 127.0.0.1 > login_user: postgres > login_password: "{{ pg_pwd }}" > port: 5432 > state: present > name: ioccx > owner: ioccadmin > encoding: "UTF-8" > lc_collate: "en_EN.UTF-8" > lc_ctype: "en_EN.UTF-8" > template: "template0" > - name: "GRANT ALL PRIVILEGES ON ioccx TO ioccadmin" > when: db_ioccx.query_result | length == 0 > postgresql_privs: > login_host: 127.0.0.1 > login_user: postgres > login_password: "{{ pg_pwd }}" > port: 5432 > state: present > db: ioccx > privs: "ALL" > type: "database" > obj: ioccx > role: ioccadmin > but can't connect the postgresql, presumably the problem is that > for-forward is not running continuously in the background > Do you have any more elegant way to initialize PostgreSQL in k8s？By the > way, would you pls tell me how to keep shell commands running in the > background？ > > -- > You received this message because you are subscribed to the Google Groups > "Ansible Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/5323f9d9-af40-4f4d-abd7-e943a7741bd3n%40googlegroups.com > > <https://groups.google.com/d/msgid/ansible-project/5323f9d9-af40-4f4d-abd7-e943a7741bd3n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/92b1b216-e3f3-4959-b988-b111da969b42n%40googlegroups.com.
