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…
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…
Restore & Clone PostgreSQL from Snapshot Backup
If you are using snapshots as your backup strategy then there may be times where you want to clone the snapshot and restore it on another server. I’ll go through that scenario. My environment is Redhat 6.1, PostgreSQL 9.2 and Netapp Snapshots. It’ll be a similar process with other snapshot technologies but the cloning and…
CentOS 7 Teamed Interface on Virtual Box
I wanted to have a look at the NetworkManager utilities in CentOS 7 so I thought I’d test out a teamed (aka bonded) interface. So here’s my setup. Virtual Box Version 5.0.14 r105127 CentOS Linux release 7.2.1511 (Core) Network 1 – NAT Network 2 & 3 – Host Only Setup looks like the following. So…
Extracting IP’s From Oracle Listener Log
There may be times when you want to extract all the client and host IP’s from the listener log to see who’s connecting to a particular database or service. I was interested in a particular service so the following will extract all IP’s connecting in to that service. Please not that our listener logs are…
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…
Change of Direction
I created this blog a few years ago to get a head start on Oracle 12c as I didn’t think the uptake in business would match my curiosity. Technology changes very quickly and there have been lots of other things to keep me busy and interested since that time. I’ve found myself slowly drifting away…
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…