| From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
|---|---|
| To: | "Naveen Dabas" <naveen(at)paymonk(dot)com> |
| Cc: | "Paul Carlucci" <paul(dot)carlucci(at)gmail(dot)com>,"Abhinav Mehta" <abhinav(at)metarain(dot)com>,"Ravi Krishna" <sravikrishna(at)aol(dot)com>,"Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>,pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_sample |
| Date: | 2018-08-29 12:23:26 |
| Message-ID: | 1b35610f-77b0-414f-b3c9-9dff188d7dc3@manitou-mail.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel J Peacock | 2018-08-29 12:34:00 | Re: Erroneous behavior of primary key |
| Previous Message | Daniel J Peacock | 2018-08-29 12:20:39 | Re: Erroneous behavior of primary key |