ansible and postgresql - is there a way to run a .sql file against postgresql database using ansible?

Question

This is literally day one for me in evaluating ansible. I have been asked by the team to show how ansible can be used to solve a specific problem like update 300 databases on 300 different servers... remove 2 rows of data and add 3 new ones.

I found some posts on stackoverflow showing how you can import a file using mysql and ansible... but I'm wondering if the same thing can be done with postgres. i'm looking at the documentation for the ansible postgresql module and it doesn't have import state like mysql.

http://docs.ansible.com/ansible/postgresql_db_module.html

vs.

http://docs.ansible.com/ansible/mysql_db_module.html

Any suggestions?

Thanks.

Petro026 · Accepted Answer · 2016-02-25 20:50:07Z

3

It's not supported by the postgres module but there's nothing stopping you from writing a playbook to move over a dump file and import it into the database. You could even break up your dump file and template it out.

- hosts: db_hosts
  become_user: postgres
  tasks: 
  - copy: src=file.dmp dest=/home/postgres/file.dmp
  - shell: psql dbname < file.dmp

I have performed a bulk of my oracle db configuration in this manner

answered Feb 25, 2016 at 20:50

Petro026

1,3198 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Happydevdays Over a year ago

sweet! I'll give it a try

Collectives™ on Stack Overflow

ansible and postgresql - is there a way to run a .sql file against postgresql database using ansible?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related