Amazon cloud based services have officially announced that they
will be upgrading their support to include PostGreSQL in their list of
supported database architecture. This will provide users with the flexibility
of cloud services while working with systems that utilize PostgreSQL. Such
increased flexibility enables users to easily create, manage, scale and
optimize their PostGre setups.
Looking back at the traditional process involved, PostGreSQL
database creation and management used to be a complex and cumbersome process
that involved a lot of effort and technical know-how. Amazon aims to simplify
this process by utilizing its SaaS, PaaS and IaaS capabilities. With a powerful
and efficient management console provided by Amazon, users will now be able to
easily create and manage PostGre instances. The console provides autoconfigured
instances with prefilled parameters that help users to set up instances with
just a few mouse clicks.
The main advantage of Amazon RDS is that the user will be able
to use all the tools and services that are currently available with database
engines. PostGre has become the leading trend in web and mobile application
development and this drift will increase with support from Amazon.
The current integration from Amazon includes a few key
functional and feature specifications which makes it truly user friendly and
efficient. Specifications are explained below:
* Amazon RDS provides the option to select preconfigured
parameters and settings. This allows quick creation, deployment and management
of PostGreSQL instances.
* Analytics feature has been optimized to allow real time
monitoring and tracking of usage statistics and information.
* Another amazing feature is the automated status/activity
update. This feature updates the user by sending an SMS or email notification
to the registered email address/mobile number.
* Version control and patch management are handled by the
system. This process is automated and allows the system to patch the database
and maintain proper versioning.
* Amazon has optimized speed and performance figures. This
has been done by modifying the IOPS range and provisioning it to more than
25,000 PostGreSQL.
* Scaling of database is a piece of cake in Amazon RDS. As
always, easy scalability is an advantage of PostGreSQL instances in Amazon.
* Apart from this, Amazon also provides enhanced security
and backup/restoration mechanisms.
Main
Features:
Location-based services – Amazon supports location-based
geolocation services with PostGre. This is termed as PostGIS service and
extends the relational schema to a geospatial data architecture.
Multiple language support – The support for multiple code level
languages has been included. There are three language extensions to support
Perl, pgSQL and Tcl.
Enhanced search – Amazon ensures a perfected search mechanism
that allows users to perform text-based searches.
JSON support – The system supports JSON communication for data
manipulation and Hstore function.
Apart from these, the system includes all core features of
PostGreSQL database.