I currently working my AWS RDS MySQL through R notebook. I have a table like this: With a trigger like this I could create table and trigger without problems; however, when I insert something like this The insertion was successful but I would get an instance of fruit with ‘C’, instead of ‘A&…
Tag: amazon-rds
Unable to grant all privileges to new user on Postgres
I’m creating a new user in a Postgres database (AWS RDS) and trying to grant all privileges on all tables in public schema of an existing database to that user. It is failing with below error. I even tried after logging in as the rds_superuser (postgres) and got the same error. psql (13.3, server 10.15)…
SQL Server – Add a linked server to AWS RDS instance
From this AWS link it explains how to add a linked server: https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/ Specifically these commands The main problem is it seems to be a mix of ‘, `, and ” I get syntax errors, and I assume that’s why…
How to run a SQL query in Cloud Formation template to enable Delayed_Durability in AWS RDS
I have a Cloud Formation template to create a SQL DB in the RDS and want to enable Delayed_Durability feature by default in it by running this query: ALTER DATABASE dbname SET DELAYED_DURABILITY = FORCED; Is there a way to run this query right after db instance is created through CF template? My CF template l…
Enabling CDC in SQL Server 2005 won’t work?
I am trying to use AWS replicate following this tutorial – https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.CDC.Publication . Using this code on a 2005 Microsoft SQL table Results in Could not find stored procedure ‘msdb.dbo.rds_cdc_enable_db’…
psycopg2: cursor.execute storing only table structure, no data
I am trying to store some tables I create in my code in an RDS instance using psycopg2. The script runs without issue and I can see the table being stored correctly in the DB. However, if I try to retrieve the query, I only see the columns, but no data: This script runs without issues and, printing out file_c…
Amazon RDS – Postgres not using index for SELECT queries
I have a feeling I am doing something terribly wrong but I can’t seem to figure it out. I have the following query which I am trying to execute: Also, I have an index on day, month, year which I had set up using the following command Now I figured the setting to set sequential scan on/off and tried play…