Need Support ?

About

Intuz PostgreSQLis a pre-configured, ready to run image for running PostgreSQL on Amazon EC2. Intuz PostgreSQL has apache2, php, adminer, PostgreSQL and scripts which make it easy for you to use PostgreSQL. We have integrated adminer and scripts for password, backup and update management.

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows.
Read More

Adminer is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB

Intuz creates and distributes AMI for the use of developers or any other person who likes to focus on managing their Application

Admin Account for PostgreSQL

PostgreSQL Terminal Login
psql -U "username" -W

Username ubuntu

Password "instance-id"

Admin Account for Adminer

URL
http://instance-public-ip/adminer.php

Username ubuntu

Password "instance-id"

Instance Login

Shell/terminal
1. sudo chmod 400 "yourpemkeyname.pem"
2. ssh -i "yourpemkeyname.pem"ubuntu@yourinstanceip

PostgreSQL Password Management

For PostgreSQL Password Management we have created the script which lets you change the password for application user admin in case you have forgotton, You can run this script and you can enable it by logging into the terminal or shell with the Instance login method by typing the below command.
sudo bash /var/www/html/iscripts/password.sh
For details steps please click here

Snapshot Management

You need to enter your AWS IAM user credentials by typing aws configure in the terminal with user ubuntu and root. For Snapshot Management we have created the script which lets you set the retention period for the snapshots, this script will create a cron for automatic backup at 2:00 AM UTC. Also, you can install aws-cli just by typing sudo apt-get install awscli -y. By default, we are not running this script, you can enable it by logging into the terminal or shell with the Instance login method and then type the below command.
sudo bash /var/www/html/iscripts/rp.sh
For details steps please click here

Update Management

For Update Management we have created the script which lets you update and upgrade the AMI, this script will create a cron for automatic Update and Upgrade at 1:00 AM UTC. By default, we are not running this script, you can enable it by logging into the terminal or shell with the Instance login method and then type the below command.
sudo bash /var/www/html/iscripts/update.sh
For details steps please click here

How to find my instance id and public ip?

Click here to read more

How to Create Snapshot?

Click here to read more

How to increase EBS Volume manually?

Click here to read more

Highlights

  • PostgreSQL has all the components installed to run it smoothly.
  • PostgreSQL is integrated with adminer for database UI.
  • PostgreSQL has Password recovery, Snapshot and Update Management scripts.

Application Installed


Newsletter Sign UP

 

Looking Forward to Have More Insights into Our Expertise?

CONTACT US