I would like to install only the postgresql client on Amazon Linux and connect to Aurora for use.Aurora is postgresql.
psql-host-database-U username
You can also connect and select from the .However, when I try to insert, I get the following error:
ERROR:cannot execute INSERT in a read-only transaction
We have verified that the destination DB can be written separately from the Windows GUI client.
Do I need to set any settings for psql?
What I want to do is to insert the data by loading the file with psql in batches.
The message "ERROR: cannot execute INSERT in a read-only transaction" means
"SET TRANSACTION READ ONLY…" and other settings are set to make the transaction read-only.
Insert writes (add) data, so it is clear that it is not a read.
I don't think it's possible to do that in a transaction that's set to read-only.
585 PHP ssh2_scp_send fails to send files as intended
626 Uncaught (inpromise) Error on Electron: An object could not be cloned
574 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
925 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
© 2024 OneMinuteCode. All rights reserved.