PostgresDriver.enableExtensions is runned on slave connection

[madeindjs]

Issue Description

PostgresDriver.enableExtensions is runned on slave connection.

Expected Behavior

I expected that CREATE EXTENSION always run on a master connection.

Actual Behavior

This produces the following error:

ERROR: cannot execute CREATE EXTENSION in a read-only transaction"

Steps to Reproduce

I created a dedicated repository to reproduce error using Docker to mount a master/slave environment

git clone https://github.com/madeindjs/typeorm_bug
cd typeorm_bug
docker-compose up

You'll see and output like this

postgres-slave_1  | 2021-05-28 10:20:57.944 UTC [31] ERROR:  cannot execute CREATE EXTENSION in a read-only transaction
postgres-slave_1  | 2021-05-28 10:20:57.944 UTC [31] STATEMENT:  CREATE EXTENSION IF NOT EXISTS "uuid-ossp"

This is caused by this entity

@Entity()
class User {
  @PrimaryGeneratedColumn()
  id: number | undefined;

  @Column({type: "text"})
  name: string | undefined;

  // require uuid extension
  @Generated("uuid")
  @Column({type: "uuid"})
  uuid: string | undefined;
}

You can see the complete file here:

My Environment

Dependency	Version
Operating System	Linux
Node.js version	v14.15.4
Typescript version	v0.2.32
TypeORM version	v4.3.2

Additional Context

Relevant Database Driver(s)

• aurora-data-api
• aurora-data-api-pg
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time, and I know how to start.
• Yes, I have the time, but I don't know how to start. I would need guidance.
• No, I don't have the time, although I believe I could do it if I had the time...
• No, I don't have the time and I wouldn't even know how to start.