summaryrefslogtreecommitdiff
path: root/test/integration/targets/setup_postgresql_db
diff options
context:
space:
mode:
authorAnsible Core Team <info@ansible.com>2020-03-09 09:40:43 +0000
committerAnsible Core Team <info@ansible.com>2020-03-09 09:40:43 +0000
commit96125d46a395af50197839602febf451960ae824 (patch)
tree45bf37708a3857108f7003e274c8ca5b5df2b94f /test/integration/targets/setup_postgresql_db
parent4068eb7a4bc444ec6234e33e97569914125859be (diff)
downloadansible-96125d46a395af50197839602febf451960ae824.tar.gz
migration final cleanup
Diffstat (limited to 'test/integration/targets/setup_postgresql_db')
-rw-r--r--test/integration/targets/setup_postgresql_db/defaults/main.yml17
-rw-r--r--test/integration/targets/setup_postgresql_db/files/dummy--1.0.sql2
-rw-r--r--test/integration/targets/setup_postgresql_db/files/dummy--2.0.sql2
-rw-r--r--test/integration/targets/setup_postgresql_db/files/dummy--3.0.sql2
-rw-r--r--test/integration/targets/setup_postgresql_db/files/dummy.control3
-rw-r--r--test/integration/targets/setup_postgresql_db/files/pg_hba.conf10
-rw-r--r--test/integration/targets/setup_postgresql_db/tasks/main.yml215
-rw-r--r--test/integration/targets/setup_postgresql_db/tasks/ssl.yml81
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/Debian-8.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/FreeBSD-11-py3.yml12
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/FreeBSD-11.yml12
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0-py3.yml12
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0.yml12
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1-py3.yml12
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1.yml12
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/RedHat-py3.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/RedHat.yml7
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/Ubuntu-12.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/Ubuntu-14.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/Ubuntu-16-py3.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/Ubuntu-16.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/Ubuntu-18-py3.yml8
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/default-py3.yml6
-rw-r--r--test/integration/targets/setup_postgresql_db/vars/default.yml6
24 files changed, 0 insertions, 479 deletions
diff --git a/test/integration/targets/setup_postgresql_db/defaults/main.yml b/test/integration/targets/setup_postgresql_db/defaults/main.yml
deleted file mode 100644
index aea0244280..0000000000
--- a/test/integration/targets/setup_postgresql_db/defaults/main.yml
+++ /dev/null
@@ -1,17 +0,0 @@
-postgresql_service: postgresql
-
-postgresql_packages:
- - postgresql-server
- - python-psycopg2
-
-pg_user: postgres
-pg_group: root
-
-locale_latin_suffix:
-locale_utf8_suffix:
-
-# defaults for test SSL
-ssl_db: 'ssl_db'
-ssl_user: 'ssl_user'
-ssl_pass: 'ssl_pass'
-ssl_rootcert: '~{{ pg_user }}/root.crt'
diff --git a/test/integration/targets/setup_postgresql_db/files/dummy--1.0.sql b/test/integration/targets/setup_postgresql_db/files/dummy--1.0.sql
deleted file mode 100644
index 53c79666b4..0000000000
--- a/test/integration/targets/setup_postgresql_db/files/dummy--1.0.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-CREATE OR REPLACE FUNCTION dummy_display_ext_version()
-RETURNS text LANGUAGE SQL AS 'SELECT (''1.0'')::text';
diff --git a/test/integration/targets/setup_postgresql_db/files/dummy--2.0.sql b/test/integration/targets/setup_postgresql_db/files/dummy--2.0.sql
deleted file mode 100644
index 227ba1b4c4..0000000000
--- a/test/integration/targets/setup_postgresql_db/files/dummy--2.0.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-CREATE OR REPLACE FUNCTION dummy_display_ext_version()
-RETURNS text LANGUAGE SQL AS 'SELECT (''2.0'')::text';
diff --git a/test/integration/targets/setup_postgresql_db/files/dummy--3.0.sql b/test/integration/targets/setup_postgresql_db/files/dummy--3.0.sql
deleted file mode 100644
index 7d6a60e543..0000000000
--- a/test/integration/targets/setup_postgresql_db/files/dummy--3.0.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-CREATE OR REPLACE FUNCTION dummy_display_ext_version()
-RETURNS text LANGUAGE SQL AS 'SELECT (''3.0'')::text';
diff --git a/test/integration/targets/setup_postgresql_db/files/dummy.control b/test/integration/targets/setup_postgresql_db/files/dummy.control
deleted file mode 100644
index 4f8553c227..0000000000
--- a/test/integration/targets/setup_postgresql_db/files/dummy.control
+++ /dev/null
@@ -1,3 +0,0 @@
-comment = 'dummy extension used to test postgresql_ext Ansible module'
-default_version = '3.0'
-relocatable = true
diff --git a/test/integration/targets/setup_postgresql_db/files/pg_hba.conf b/test/integration/targets/setup_postgresql_db/files/pg_hba.conf
deleted file mode 100644
index 58de3607f9..0000000000
--- a/test/integration/targets/setup_postgresql_db/files/pg_hba.conf
+++ /dev/null
@@ -1,10 +0,0 @@
-# !!! This file managed by Ansible. Any local changes may be overwritten. !!!
-
-# Database administrative login by UNIX sockets
-# note: you may wish to restrict this further later
-local all {{ pg_user }} trust
-
-# TYPE DATABASE USER CIDR-ADDRESS METHOD
-local all all md5
-host all all 127.0.0.1/32 md5
-host all all ::1/128 md5
diff --git a/test/integration/targets/setup_postgresql_db/tasks/main.yml b/test/integration/targets/setup_postgresql_db/tasks/main.yml
deleted file mode 100644
index 651f6b3946..0000000000
--- a/test/integration/targets/setup_postgresql_db/tasks/main.yml
+++ /dev/null
@@ -1,215 +0,0 @@
-- name: python 2
- set_fact:
- python_suffix: ""
- when: ansible_python_version is version('3', '<')
-
-- name: python 3
- set_fact:
- python_suffix: "-py3"
- when: ansible_python_version is version('3', '>=')
-
-- name: Include distribution and Python version specific variables
- include_vars: "{{ lookup('first_found', params) }}"
- vars:
- params:
- files:
- - '{{ ansible_distribution }}-{{ ansible_distribution_major_version }}{{ python_suffix }}.yml'
- - '{{ ansible_distribution }}-{{ ansible_distribution_version }}{{ python_suffix }}.yml'
- - '{{ ansible_os_family }}{{ python_suffix }}.yml'
- - 'default{{ python_suffix }}.yml'
- paths:
- - "{{ role_path }}/vars"
-
-- name: make sure the dbus service is started under systemd
- systemd:
- name: dbus
- state: started
- when: ansible_service_mgr == 'systemd' and ansible_distribution == 'Fedora'
-
-# Make sure we start fresh
-- name: stop postgresql service
- service: name={{ postgresql_service }} state=stopped
- ignore_errors: True
-
-- name: remove old db (RedHat or Suse)
- file:
- path: "{{ pg_dir }}"
- state: absent
- ignore_errors: True
- when: ansible_os_family == "RedHat" or ansible_os_family == "Suse"
-
-- name: remove old db (FreeBSD)
- file:
- path: "{{ pg_dir }}"
- state: absent
- ignore_errors: True
- when: ansible_os_family == "FreeBSD"
-
-# Theoretically, pg_dropcluster should work but it doesn't so remove files
-- name: remove old db config and files (debian)
- file:
- path: '{{ loop_item }}'
- state: absent
- ignore_errors: True
- when: ansible_os_family == "Debian"
- loop:
- - /etc/postgresql
- - /var/lib/postgresql
- loop_control:
- loop_var: loop_item
-
-- name: install dependencies for postgresql test
- package:
- name: "{{ postgresql_package_item }}"
- state: present
- with_items: "{{ postgresql_packages }}"
- loop_control:
- loop_var: postgresql_package_item
-
-- name: initialize postgres (FreeBSD)
- command: /usr/local/etc/rc.d/postgresql oneinitdb
- when: ansible_os_family == "FreeBSD"
-
-- name: Initialize postgres (RedHat systemd)
- command: postgresql-setup initdb
- when: ansible_os_family == "RedHat" and ansible_service_mgr == "systemd"
-
-- name: Initialize postgres (RedHat sysv)
- command: /sbin/service postgresql initdb
- when: ansible_os_family == "RedHat" and ansible_service_mgr != "systemd"
-
-- name: Initialize postgres (Debian)
- shell: '. /usr/share/postgresql-common/maintscripts-functions && set_system_locale && /usr/bin/pg_createcluster -u postgres {{ pg_verĀ }} main'
- args:
- creates: "/etc/postgresql/{{ pg_ver }}/"
- when: ansible_os_family == 'Debian'
-
-- name: Initialize postgres (Suse)
- service: name=postgresql state=restarted
- when: ansible_os_family == 'Suse'
-
-- name: Copy pg_hba into place
- template:
- src: files/pg_hba.conf
- dest: "{{ pg_hba_location }}"
- owner: "{{ pg_user }}"
- group: "{{ pg_group }}"
- mode: "0644"
-
-- name: Generate locales (Debian)
- locale_gen:
- name: '{{ item }}'
- state: present
- with_items:
- - pt_BR
- - es_ES
- when: ansible_os_family == 'Debian'
-
-# Suse: locales are installed by default (glibc-locale package).
-# Fedora 23: locales are installed by default (glibc-common package)
-# CentOS: all locales are installed by default (glibc-common package) but some
-# RPM macros could prevent their installation (for example when using anaconda
-# instLangs parameter).
-
-- block:
- - name: Install langpacks (RHEL8)
- yum:
- name:
- - glibc-langpack-es
- - glibc-langpack-pt
- - glibc-all-langpacks
- state: present
- when: ansible_distribution_major_version is version('8', '>=')
-
- - name: Check if locales need to be generated (RedHat)
- shell: "localedef --list-archive | grep -a -q '^{{ locale }}$'"
- register: locale_present
- ignore_errors: True
- with_items:
- - es_ES
- - pt_BR
- loop_control:
- loop_var: locale
-
- - name: Reinstall internationalization files
- shell: 'yum -y reinstall glibc-common || yum -y install glibc-common'
- args:
- warn: no
- when: locale_present is failed
-
- - name: Generate locale (RedHat)
- command: 'localedef -f ISO-8859-1 -i {{ item.locale }} {{ item.locale }}'
- when: item is failed
- with_items: '{{ locale_present.results }}'
- when: ansible_os_family == 'RedHat' and ansible_distribution != 'Fedora'
-
-- name: Install glibc langpacks (Fedora >= 24)
- package:
- name: '{{ item }}'
- state: 'latest'
- with_items:
- - glibc-langpack-es
- - glibc-langpack-pt
- when: ansible_distribution == 'Fedora' and ansible_distribution_major_version is version('24', '>=')
-
-- name: enable postgresql service (FreeBSD)
- lineinfile:
- path: /etc/rc.conf
- line: 'postgresql_enable="YES"'
- when: ansible_os_family == "FreeBSD"
-
-- name: start postgresql service
- # work-around for issue on FreeBSD where service won't restart if currently stopped
- service: name={{ postgresql_service }} state=started
-
-- name: restart postgresql service
- service: name={{ postgresql_service }} state=restarted
-
-########################
-# Setup dummy extension:
-- name: copy control file for dummy ext
- copy:
- src: dummy.control
- dest: "/usr/share/postgresql/{{ pg_ver }}/extension/dummy.control"
- mode: 0444
- when: ansible_os_family == 'Debian'
-
-- name: copy version files for dummy ext
- copy:
- src: "{{ item }}"
- dest: "/usr/share/postgresql/{{ pg_ver }}/extension/{{ item }}"
- mode: 0444
- with_items:
- - dummy--1.0.sql
- - dummy--2.0.sql
- - dummy--3.0.sql
- when: ansible_os_family == 'Debian'
-
-- name: add update paths
- file:
- path: "/usr/share/postgresql/{{ pg_ver }}/extension/{{ item }}"
- mode: 0444
- state: touch
- with_items:
- - dummy--1.0--2.0.sql
- - dummy--2.0--3.0.sql
- when: ansible_os_family == 'Debian'
-
-- name: Get PostgreSQL version
- become_user: "{{ pg_user }}"
- become: yes
- shell: "echo 'SHOW SERVER_VERSION' | psql --tuples-only --no-align --dbname postgres"
- register: postgres_version_resp
-
-- name: Print PostgreSQL server version
- debug:
- msg: "{{ postgres_version_resp.stdout }}"
-
-# SSL configuration.
-# Restricted using Debian family because of there are errors on other distributions
-# that not related with PostgreSQL or psycopg2 SSL support.
-# The tests key point is to be sure that ssl options work in general
-- import_tasks: ssl.yml
- when:
- - ansible_os_family == 'Debian'
- - postgres_version_resp.stdout is version('9.4', '>=')
diff --git a/test/integration/targets/setup_postgresql_db/tasks/ssl.yml b/test/integration/targets/setup_postgresql_db/tasks/ssl.yml
deleted file mode 100644
index bc45ec6f4b..0000000000
--- a/test/integration/targets/setup_postgresql_db/tasks/ssl.yml
+++ /dev/null
@@ -1,81 +0,0 @@
-# Copyright: (c) 2019, Andrew Klychkov (@Andersson007) <aaklychkov@mail.ru>
-# GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt)
-
-# The aim of this test is to be sure that SSL options work in general
-# and preparing the environment for testing these options in
-# the following PostgreSQL modules (ssl_db, ssl_user, certs).
-# Configured by https://www.postgresql.org/docs/current/ssl-tcp.html
-
-####################
-# Prepare for tests:
-
-- name: postgresql SSL - create database
- become_user: "{{ pg_user }}"
- become: yes
- postgresql_db:
- name: "{{ ssl_db }}"
-
-- name: postgresql SSL - create role
- become_user: "{{ pg_user }}"
- become: yes
- postgresql_user:
- name: "{{ ssl_user }}"
- role_attr_flags: SUPERUSER
- password: "{{ ssl_pass }}"
-
-- name: postgresql SSL - install openssl
- become: yes
- package: name=openssl state=present
-
-- name: postgresql SSL - create certs 1
- become_user: root
- become: yes
- shell: 'openssl req -new -nodes -text -out ~{{ pg_user }}/root.csr \
- -keyout ~{{ pg_user }}/root.key -subj "/CN=localhost.local"'
-
-- name: postgresql SSL - create certs 2
- become_user: root
- become: yes
- shell: 'openssl x509 -req -in ~{{ pg_user }}/root.csr -text -days 3650 \
- -extensions v3_ca -signkey ~{{ pg_user }}/root.key -out ~{{ pg_user }}/root.crt'
-
-- name: postgresql SSL - create certs 3
- become_user: root
- become: yes
- shell: 'openssl req -new -nodes -text -out ~{{ pg_user }}/server.csr \
- -keyout ~{{ pg_user }}/server.key -subj "/CN=localhost.local"'
-
-- name: postgresql SSL - create certs 4
- become_user: root
- become: yes
- shell: 'openssl x509 -req -in ~{{ pg_user }}/server.csr -text -days 365 \
- -CA ~{{ pg_user }}/root.crt -CAkey ~{{ pg_user }}/root.key -CAcreateserial -out server.crt'
-
-- name: postgresql SSL - set right permissions to files
- become_user: root
- become: yes
- file:
- path: '{{ item }}'
- mode: 0600
- owner: '{{ pg_user }}'
- group: '{{ pg_user }}'
- with_items:
- - '~{{ pg_user }}/root.key'
- - '~{{ pg_user }}/server.key'
- - '~{{ pg_user }}/root.crt'
- - '~{{ pg_user }}/server.csr'
-
-- name: postgresql SSL - enable SSL
- become_user: "{{ pg_user }}"
- become: yes
- postgresql_set:
- login_user: "{{ pg_user }}"
- db: postgres
- name: ssl
- value: on
-
-- name: postgresql SSL - reload PostgreSQL to enable ssl on
- become: yes
- service:
- name: "{{ postgresql_service }}"
- state: reloaded
diff --git a/test/integration/targets/setup_postgresql_db/vars/Debian-8.yml b/test/integration/targets/setup_postgresql_db/vars/Debian-8.yml
deleted file mode 100644
index c5c6795eac..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/Debian-8.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql"
- - "postgresql-common"
- - "python-psycopg2"
-
-pg_hba_location: "/etc/postgresql/9.4/main/pg_hba.conf"
-pg_dir: "/var/lib/postgresql/9.4/main"
-pg_ver: 9.4
diff --git a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-11-py3.yml b/test/integration/targets/setup_postgresql_db/vars/FreeBSD-11-py3.yml
deleted file mode 100644
index 2f6b0d9846..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-11-py3.yml
+++ /dev/null
@@ -1,12 +0,0 @@
-postgresql_packages:
- - postgresql95-server
- - py36-psycopg2
-
-pg_dir: /usr/local/pgsql/data
-pg_hba_location: "{{ pg_dir }}/pg_hba.conf"
-pg_ver: 9.5
-pg_user: pgsql
-pg_group: pgsql
-
-locale_latin_suffix: .ISO8859-1
-locale_utf8_suffix: .UTF-8
diff --git a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-11.yml b/test/integration/targets/setup_postgresql_db/vars/FreeBSD-11.yml
deleted file mode 100644
index efb0603b5e..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-11.yml
+++ /dev/null
@@ -1,12 +0,0 @@
-postgresql_packages:
- - postgresql95-server
- - py27-psycopg2
-
-pg_dir: /usr/local/pgsql/data
-pg_hba_location: "{{ pg_dir }}/pg_hba.conf"
-pg_ver: 9.5
-pg_user: pgsql
-pg_group: pgsql
-
-locale_latin_suffix: .ISO8859-1
-locale_utf8_suffix: .UTF-8
diff --git a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0-py3.yml b/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0-py3.yml
deleted file mode 100644
index 2f6b0d9846..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0-py3.yml
+++ /dev/null
@@ -1,12 +0,0 @@
-postgresql_packages:
- - postgresql95-server
- - py36-psycopg2
-
-pg_dir: /usr/local/pgsql/data
-pg_hba_location: "{{ pg_dir }}/pg_hba.conf"
-pg_ver: 9.5
-pg_user: pgsql
-pg_group: pgsql
-
-locale_latin_suffix: .ISO8859-1
-locale_utf8_suffix: .UTF-8
diff --git a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0.yml b/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0.yml
deleted file mode 100644
index 1fe6678262..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.0.yml
+++ /dev/null
@@ -1,12 +0,0 @@
-postgresql_packages:
- - postgresql96-server
- - py27-psycopg2
-
-pg_dir: /usr/local/pgsql/data
-pg_hba_location: "{{ pg_dir }}/pg_hba.conf"
-pg_ver: 9.6
-pg_user: pgsql
-pg_group: pgsql
-
-locale_latin_suffix: .ISO8859-1
-locale_utf8_suffix: .UTF-8
diff --git a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1-py3.yml b/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1-py3.yml
deleted file mode 100644
index cd7c83a4c1..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1-py3.yml
+++ /dev/null
@@ -1,12 +0,0 @@
-postgresql_packages:
- - postgresql11-server
- - py36-psycopg2
-
-pg_dir: /var/db/postgres/data11
-pg_hba_location: "{{ pg_dir }}/pg_hba.conf"
-pg_ver: 11
-pg_user: postgres
-pg_group: postgres
-
-locale_latin_suffix: .ISO8859-1
-locale_utf8_suffix: .UTF-8
diff --git a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1.yml b/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1.yml
deleted file mode 100644
index 0b1ab5b26e..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/FreeBSD-12.1.yml
+++ /dev/null
@@ -1,12 +0,0 @@
-postgresql_packages:
- - postgresql11-server
- - py27-psycopg2
-
-pg_dir: /var/db/postgres/data11
-pg_hba_location: "{{ pg_dir }}/pg_hba.conf"
-pg_ver: 11
-pg_user: postgres
-pg_group: postgres
-
-locale_latin_suffix: .ISO8859-1
-locale_utf8_suffix: .UTF-8
diff --git a/test/integration/targets/setup_postgresql_db/vars/RedHat-py3.yml b/test/integration/targets/setup_postgresql_db/vars/RedHat-py3.yml
deleted file mode 100644
index ee08372226..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/RedHat-py3.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql-server"
- - "python3-psycopg2"
- - "bzip2"
- - "xz"
-
-pg_hba_location: "/var/lib/pgsql/data/pg_hba.conf"
-pg_dir: "/var/lib/pgsql/data"
diff --git a/test/integration/targets/setup_postgresql_db/vars/RedHat.yml b/test/integration/targets/setup_postgresql_db/vars/RedHat.yml
deleted file mode 100644
index 20c4b1f5b7..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/RedHat.yml
+++ /dev/null
@@ -1,7 +0,0 @@
-postgresql_packages:
- - "postgresql-server"
- - "python-psycopg2"
- - "bzip2"
-
-pg_hba_location: "/var/lib/pgsql/data/pg_hba.conf"
-pg_dir: "/var/lib/pgsql/data"
diff --git a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-12.yml b/test/integration/targets/setup_postgresql_db/vars/Ubuntu-12.yml
deleted file mode 100644
index 4b6e744b44..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-12.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql"
- - "postgresql-common"
- - "python-psycopg2"
-
-pg_hba_location: "/etc/postgresql/9.1/main/pg_hba.conf"
-pg_dir: "/var/lib/postgresql/9.1/main"
-pg_ver: 9.1
diff --git a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-14.yml b/test/integration/targets/setup_postgresql_db/vars/Ubuntu-14.yml
deleted file mode 100644
index ffcc8dd496..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-14.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql"
- - "postgresql-common"
- - "python-psycopg2"
-
-pg_hba_location: "/etc/postgresql/9.3/main/pg_hba.conf"
-pg_dir: "/var/lib/postgresql/9.3/main"
-pg_ver: 9.3
diff --git a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-16-py3.yml b/test/integration/targets/setup_postgresql_db/vars/Ubuntu-16-py3.yml
deleted file mode 100644
index b088c3105e..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-16-py3.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql"
- - "postgresql-common"
- - "python3-psycopg2"
-
-pg_hba_location: "/etc/postgresql/9.5/main/pg_hba.conf"
-pg_dir: "/var/lib/postgresql/9.5/main"
-pg_ver: 9.5
diff --git a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-16.yml b/test/integration/targets/setup_postgresql_db/vars/Ubuntu-16.yml
deleted file mode 100644
index 897efd2c76..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-16.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql"
- - "postgresql-common"
- - "python-psycopg2"
-
-pg_hba_location: "/etc/postgresql/9.5/main/pg_hba.conf"
-pg_dir: "/var/lib/postgresql/9.5/main"
-pg_ver: 9.5
diff --git a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-18-py3.yml b/test/integration/targets/setup_postgresql_db/vars/Ubuntu-18-py3.yml
deleted file mode 100644
index 10453bdf90..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/Ubuntu-18-py3.yml
+++ /dev/null
@@ -1,8 +0,0 @@
-postgresql_packages:
- - "postgresql"
- - "postgresql-common"
- - "python3-psycopg2"
-
-pg_hba_location: "/etc/postgresql/10/main/pg_hba.conf"
-pg_dir: "/var/lib/postgresql/10/main"
-pg_ver: 10
diff --git a/test/integration/targets/setup_postgresql_db/vars/default-py3.yml b/test/integration/targets/setup_postgresql_db/vars/default-py3.yml
deleted file mode 100644
index 19152a6435..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/default-py3.yml
+++ /dev/null
@@ -1,6 +0,0 @@
-postgresql_packages:
- - "postgresql-server"
- - "python3-psycopg2"
-
-pg_hba_location: "/var/lib/pgsql/data/pg_hba.conf"
-pg_dir: "/var/lib/pgsql/data"
diff --git a/test/integration/targets/setup_postgresql_db/vars/default.yml b/test/integration/targets/setup_postgresql_db/vars/default.yml
deleted file mode 100644
index ab36dd9f1d..0000000000
--- a/test/integration/targets/setup_postgresql_db/vars/default.yml
+++ /dev/null
@@ -1,6 +0,0 @@
-postgresql_packages:
- - "postgresql-server"
- - "python-psycopg2"
-
-pg_hba_location: "/var/lib/pgsql/data/pg_hba.conf"
-pg_dir: "/var/lib/pgsql/data"