One of the differences between Oracle and PostgreSQL is the default behaviour of identifiers when they are not quoted. In Oracle it folds to uppercase (SQL Standard) while in PostgreSQL it folds to lowercase. So when you migrate from Oracle to PostgreSQL with AWS DMS, the DMS wraps the DDL with quotes and makes the…
Category: AWS
AWS S3 Object ACL and 403 Error
Recently I fell into the trap of S3 object ACL’s and the issue of an object having a different owner to the bucket. So when I tried to do something simple like the following I got a forbidden error.
|
1 2 3 |
aws s3 cp s3://mybucket-name-unique/foo.txt /tmp A client error (403) occurred when calling the HeadObject operation: Forbidden Completed 1 part(s) with ... file(s) remaining |
This stumped me for a while as I couldn’t understand why an admin user connecting…
AWS Database Migration Service
Amongst the many services being offered by AWS, one of the most anticipated from a database perspective is the Database Migration Service – DMS. It is now readily available across all regions after being in preview for while. What better reason to give it a trial run. The AWS Blog has a nice article on…
Oracle RDS with SSL
Amazon just recently announced support for SSL connections with Oracle RDS. What better reason to try and test it out. To use SSL with Oracle you’ll need: Option Group with SSL enabled VPC Security Group allowing port 2484 With that in mind I’ve created a cloudformation template to automate the build. You can run the…
Authorizing AWS Inbound Traffic For Your IP Using CLI
One of the security measures you may want to implement in your AWS setup is to have a bastion host or limit ssh access from the whole world and only use your private network. If you have your own account and your instances are exposed to the public you should at least limit ssh access…
Simple PostgreSQL RDS CloudFormation Template
I’ve been working with the Amazon RDS offerings lately and used a few of the services and tools. Here’s a simple cloudformation sample to create a PostgreSQL RDS. The template creates a security group allowing access on port 5432 to subnet 10.0.0.0/16. It also creates a database parameter group with the pg_stat_statements module as coming…
Working with Oracle on Amazon RDS
Putting databases and everything else into the cloud has become quite popular over the last few years and it looks like there is nothing that can stop this movement. The biggest player in the field is Amazon so if you are looking at using their managed service RDS then here’s some of the common tasks…