postgresql_db for Windows?

Archives Ansible Project
1

Is there an equivalent Windows module for postgresql_db in Windows that I can use to dump/restore a PostgreSQL DB?

Thanks,
Chris

2

No. But the commands on linux should be able to reach out to a remote host. Can you delegate locally and reach out to remote windows host?
https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_db_module.html#ansible-collections-community-postgresql-postgresql-db-moduleThere is an proc there to specify a login host. That’s the host running the database.

3

I Should say option

4

Thanks. I’ve seen that link before, but the page does not provide an example that uses “login_host”? Is just the hostname, or IP address, or the host running the DB? What about the PostgreSQL cred and connection URL? I don’t see them in the module?

Thanks,
Chris

5

Googling around I found this example:

Ansible Loves PostgreSQL - 2ndQuadrant | PostgreSQL

looks like name is what you are looking for

- postgresql_db: name=module_test
                 state=present
                 login_host=[db.example.com](http://db.example.com)
                 port=5432
                 login_user=postgres
6

Thanks again. I’ll try it later and post here.

Chris