postgresql - Postgresql - 无法连接到数据库：无法连接到服务器：没有这样的文件或目录

Question

所以我试图用 Ansible 在我的远程服务器上创建一个 Postgres 数据库，不幸的是我收到了这个错误消息

TASK [postgresql : Create database with name sola] *****************************************************************************************
An exception occurred during task execution. To see the full traceback, use -vvv. The error was:    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
fatal: [some-remote-server]: FAILED! => {
    "changed": false
}

MSG:

unable to connect to database: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

这将是我的剧本

- name: enable the PostgreSQL package repository
  copy:
    src: pgdg-96-redhat.repo
    dest: /etc/yum.repos.d/pgdg-96-redhat.repo

- name: install additional packages
  yum:
    name: "{{ item }}"
    state: present
  with_items:
  - "{{ packages }}"

- name: Ensure bash and OpenSSL are the  latest version
  yum:
    name: "{{ item }}"
    update_cache: true
    state: latest
  with_items:
    - bash
    - openssl
  tags: packages

- name: install system packages
  yum:
    name: "{{ item }}"
    state: installed
  with_items:
    - "{{ packages }}"
  become: yes

- name: Install PostgreSQL
  yum:
    name: "{{ item }}"
    update_cache: true
    state: installed
  with_items:
    - postgresql
    - postgresql-contrib
    - python-psycopg2
  tags: packages
  become: yes

- name: enabling postgresql services
  service:
    name: postgresql
    state: started
    enabled: yes

- name: Create database with name sola
  postgresql_db:
    name: sola
    encoding: 'UTF-8'
    lc_collate: 'en_US.UTF-8'
    lc_ctype: 'en_US.UTF-8'
    template: 'template0'

- name: Ensure database is created
  sudo_user: postgres
  postgresql_db:
    name: dbname
    encoding: 'UTF-8'
    lc_collate: 'en_US.UTF-8'
    lc_ctype: 'en_US.UTF-8'
    template: 'template0'
    state: present

我的怀疑是，安装过程出现问题，以至于 postgres 甚至没有正确安装在远程服务器上，或者我没有正确启用和启动 postgres 服务。任何帮助表示赞赏！

标签： postgresqlansible