Overview
PostgreSQL Server + pgAdmin Web GUI on Ubuntu Server 20.04
PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying. So, you want NoSQL, Riak, REACT, Redis, Mongo, etc.? PostgreSQL does all that.
PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community. PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.
Included in this solution also comes pgAdmin. pgAdmin is the most popular and feature rich Open Source administration and development platform for Postgre SQL. pgAdmin is a web-based management tool for PostgreSQL allowing your manage PostgreSQL via your browser.
Postgre SQL Server Features: Compatible with Data Integrity Support multiple features of SQL Compatible with multiple data types Concurrency, Performance Internationalisation, Text Search Highly extensible Secure Highly Reliable pgAdmin - Web based management tool. Supports geospatial databases for geographic information systems (GIS) Robust database in the LAPP stack Many languages supported: Python, Java, C#, C/C+, Ruby, JavaScript (Node.js), Perl, Go, Tcl
Highlights
- PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying. Included in this solution also comes pgAdmin, web-based management tool for PostgreSQL.
- PostgreSQL can run dynamic websites and web apps as a LAMP stack option. PostgreSQL's write-ahead logging makes it a highly fault-tolerant database.
- PostgreSQL works well with BI applications. Works well for Data Warehousing and data analysis applications which need fast read-write speeds.
Details
Typical total price
$0.076/hour
Pricing
- ...
Instance type | Product cost/hour | EC2 cost/hour | Total/hour |
|---|---|---|---|
t2.nano | $0.03 | $0.006 | $0.036 |
t2.micro AWS Free Tier | $0.03 | $0.012 | $0.042 |
t2.small | $0.03 | $0.023 | $0.053 |
t2.medium Recommended | $0.03 | $0.046 | $0.076 |
t2.large | $0.03 | $0.093 | $0.123 |
t2.xlarge | $0.03 | $0.186 | $0.216 |
t2.2xlarge | $0.03 | $0.371 | $0.401 |
t3.nano | $0.03 | $0.005 | $0.035 |
t3.micro AWS Free Tier | $0.03 | $0.01 | $0.04 |
t3.small | $0.03 | $0.021 | $0.051 |
Additional AWS infrastructure costs
Type | Cost |
|---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
We do not currently support refunds, but you can cancel at any time.
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Latest OS patches have been installed. Simply run 'sudo apt-get update' to install the latest OS patches.
Additional details
Usage instructions
Scroll down to 'Getting Started' on the following URL: https://cloudinfrastructureservices.co.uk/how-to-setup-install-postgresql-server-on-azure-aws-gcp
Resources
Vendor resources
Support
Vendor support
Email support, contact us through our website or leave a comment on our getting started guide
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
