ansible cannot execute SQL CREATE DATABASE CREATE DATABASE cannot run inside a transaction block
NickName:Anthony Petrillo Ask DateTime:2020-12-23T10:28:06

ansible cannot execute SQL CREATE DATABASE CREATE DATABASE cannot run inside a transaction block

There are several entries that CREATE DATABASE cannot run inside a transaction block which give the answer autocommit needs to be on. However, they do not reference ansible which is what I was looking for.

Copyright Notice：Content Author:「Anthony Petrillo」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/65418287/ansible-cannot-execute-sql-create-database-create-database-cannot-run-inside-a-t

Answers
Zeitounator 2020-12-23T09:45:47

There is a specific postgresql_db module that will take care of your db creation (or removal/dump/restoration) and will manage idempotency out of the box.\n- name: Create database if needed\n postgresql_db:\n name: "{{ dbname }}"\n state: present\n become: yes\n become_user: postgres\n",

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “ansible cannot execute SQL CREATE DATABASE CREATE DATABASE cannot run inside a transaction block” related questions
ansible cannot execute SQL CREATE DATABASE CREATE DATABASE cannot run inside a transaction block

There are several entries that CREATE DATABASE cannot run inside a transaction block which give the answer autocommit needs to be on. However, they do not reference ansible which is what I was look...

Show Detail
Error CREATE DATABASE cannot run inside a transaction block

I am trying to create a database from a Java application running in Micronaut framework using jOOQ. The code contextSupplier.get().createDatabaseIfNotExists(this.databaseName).execute(); with a

Show Detail
CREATE DATABASE cannot run inside a transaction block

I am working on AWS server + PostgreSQL. When I execute a query for creating the database I get an error: CREATE DATABASE cannot run inside a transaction block I am working on Linux Ubuntu 12.04 ...

Show Detail
CREATE DATABASE cannot run inside a transaction block in pgadmin 4

I am triing to run a script in pgAdmin 4, but I get this error: CREATE DATABASE cannot run inside a transaction block And this is the script: CREATE USER ky_auth WITH PASSWORD 'ky_auth'; COMMENT...

Show Detail
Liquibase: ERROR: CREATE DATABASE cannot run inside a transaction block

I am trying to create a db on PostgreSQL using liquibase. This is my dbchangelog file <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.

Show Detail
Error executing: CREATE DATABASE aNewDb . Cause: org.postgresql.util.PSQLException: ERROR: CREATE DATABASE cannot run inside a transaction block

Main class where the code is running : static final String JDBC_DRIVER = "org.postgresql.Driver"; static final String DB_URL = "jdbc:postgresql://localhost:5432/postgres"; // Database credentials

Show Detail
postgresql: cannot run inside a transaction block

I am trying to run these commands together in SQLbox of phppgadmin CREATE DATABASE "ir-staging"; CREATE USER django WITH ENCRYPTED PASSWORD 'django'; GRANT ALL PRIVILEGES ON DATABASE &quo...

Show Detail
ERROR: CREATE DATABASE cannot run inside a transaction block SQL state: 25001 - Using PostgresSQL and pgAdmin 4

Hi guys I'm stuck on a problem for my first database on Postgres and I cannot find a solution, I tried to see if it was a matter of setting autocommit on but apparently from postgres 9.x it's an

Show Detail
REINDEX DATABASE cannot run inside a transaction block

I am using an old version of sqlalchemy (0.8) and I need to execute "REINDEX DATABASE <dbname>" on PostgreSQLql 9.4 by using sqlalchemy api. Initially I tried with: conn = pg_db.connect() ...

Show Detail
CREATE DATABASE inside transaction

According to postgresql docs; CREATE DATABASE cannot be executed inside a transaction block. Is there a technical reason for this?

Show Detail