Re: pg_sample - Mailing list pgsql-general

From Daniel Verite
Subject Re: pg_sample
Date
Msg-id 1b35610f-77b0-414f-b3c9-9dff188d7dc3@manitou-mail.org
Whole thread Raw
In response to Re: pg_sample  (Naveen Dabas <naveen@paymonk.com>)
List pgsql-general
    Naveen Dabas wrote:

> Creating sample schema sampledb1
> DBD::Pg::db do failed: ERROR:  cannot execute CREATE SCHEMA in a read-only
> transaction at ./pg_sample line 296.

Maybe you ran this on a hot standby? It can't work because
this program needs to write data into the database,
which is not allowed outside of the primary node.

Or you may have default_transaction_read_only set to true
for the particular db/user of the connection.
https://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-DEFAULT-TRANSACTION-READ-ONLY

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite


pgsql-general by date:

Previous
From: Daniel J Peacock
Date:
Subject: Re: Erroneous behavior of primary key
Next
From: Daniel J Peacock
Date:
Subject: Re: Erroneous behavior of primary key