Overview
pgAdmin 4 login page
The pgAdmin 4 web interface login page served by Apache httpd, accessible at the instance IP address with no manual setup.
pgAdmin 4 login page
pgAdmin 4 object browser
PostgreSQL service status
This is a repackaged open source software product wherein additional charges apply for cloudimg support services.
Overview PostgreSQL is the world's most advanced open source relational database. This image pairs the database server with pgAdmin 4, the leading browser-based administration interface, so a fully managed PostgreSQL environment is running within minutes of launch. No manual setup or configuration is required.
Database Stack PostgreSQL installed from the official PGDG repository, with the contrib extensions package included. The data directory lives on a dedicated, independently resizable EBS volume so the database tier can be grown without touching the OS disk. pg_hba.conf is pre-configured with scram-sha-256 authentication for local connections.
pgAdmin 4 Web Interface pgAdmin 4 is served by Apache httpd at the /pgadmin4/ path. Visiting the instance IP address in a browser takes you directly to the pgAdmin login page. From there you can manage databases, run SQL queries, inspect schemas, view execution plans and monitor server activity, all without a command line.
Secure First Boot On the first boot of every instance a one-shot service generates a fresh PostgreSQL superuser password and a fresh pgAdmin administrator password, unique to that instance. The pgAdmin database is recreated from scratch so no build-time credentials persist. Both passwords are written to /root/postgresql-credentials.txt (readable only by root) and displayed at SSH login via MOTD.
Ready To Use The PostgreSQL service, data directory, httpd configuration and pgAdmin account are all prepared. Connect to the instance IP in your browser, retrieve the generated password, and sign in to pgAdmin. The local PostgreSQL server is pre-registered in pgAdmin as a named connection so you can start creating databases and running queries immediately.
cloudimg Support 24/7 technical support from cloudimg for PostgreSQL deployment, upgrades, performance tuning, replication configuration, backup strategy, pgAdmin configuration and database administration.
Use Cases Relational data stores for web and mobile applications. Analytics and reporting databases. Development and staging environments. Data warehousing with extensions such as pg_stat_statements and pg_trgm. JSONB document storage. Full-text search with tsvector. Geographic data with PostGIS.
All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
Highlights
- PostgreSQL and pgAdmin 4 preinstalled with no manual setup, with the pgAdmin web interface served by Apache httpd at /pgadmin4/ and the local PostgreSQL server pre-registered for immediate use
- Secure first boot generates a fresh PostgreSQL superuser password and pgAdmin admin password for every instance, stored in a root-only file, with no shared or default credentials in the image
- 24/7 technical support from cloudimg for PostgreSQL deployment, replication, backup, performance tuning and pgAdmin administration
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
- ...
Dimension | Description | Cost/hour |
|---|---|---|
m5.large Recommended | m5.large | $0.08 |
t2.micro | t2.micro instance type | $0.04 |
t3.micro | t3.micro instance type | $0.04 |
c6i.32xlarge | c6i.32xlarge instance type | $0.24 |
r8idn.8xlarge | r8idn.8xlarge instance type | $0.24 |
g6f.xlarge | g6f.xlarge instance type | $0.12 |
m5d.16xlarge | m5d.16xlarge instance type | $0.24 |
r7iz.32xlarge | r7iz.32xlarge instance type | $0.24 |
c7a.8xlarge | c7a.8xlarge instance type | $0.24 |
r5d.metal | r5d.metal instance type | $0.24 |
Vendor refund policy
Refunds available on request.
How can we make this page better?
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
Initial release of PostgreSQL with pgAdmin 4.
Additional details
Usage instructions
Connect via SSH on port 22 as the default login user for your operating system variant (the user guide lists it per variant). Retrieve your generated credentials with: sudo cat /root/postgresql-credentials.txt. Browse to http://<instance-public-ip>/pgadmin4/ and sign in with the pgadmin.admin.email and pgadmin.admin.password from the credentials file. The local PostgreSQL server is pre-registered in pgAdmin. To connect from psql: PGPASSWORD=<postgresql.superuser.password> psql -U postgres -h 127.0.0.1. Restrict port 5432 to trusted networks for production deployments. To enable HTTPS, follow the reverse proxy section of the user guide.
Resources
Vendor resources
Support
Vendor support
cloudimg provides 24/7 technical support for this product by email and live chat. Our engineers help with deployment, configuration, updates, performance tuning and troubleshooting; critical issues receive a one hour average response. Contact support@cloudimg.co.uk .
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.