This AMI is a a LEPP Web Server with phpMyAdmin installed on Ubuntu 20.04. Package include Linux, Nginx, phpMyAdmin, and PostgreSQL.
This AMI supports following versions.
- PHP 8.1
- Nginx 1.22
- PostgreSQL 14
Web Server
We prepared SSL/TLS so you can access to top page using http:// or https://.
DB Server Password
We recommend using minimum machine type e2-standard-8 for this LAMP server. For more machine types please refer to GCP General purpose machines documentation.
External IP address
Note the external IP from VM instance console
PostgreSQL is set to no password by default. The default Postgres user is postgres.
Follow this official documentation to change password if desired.
You can also SSH into your instance and find the login credential using the following command.
[ec2-user@ip-172-31-77-125 ~]$ cat credentials
////////////////////credentials info////////////////////
--- PostgreSQL
----- User : postgres
----- Password : aVpwwo9pdiK1lewp
////////////////////////////////////////////////////////
Login PostgreSQL SHELL
$ sudo -i -u postgres psql -U postgres
psql (14.3)
Type "help" for help.
postgres=#
postgres=# SHOW data_directory;
data_directory
---------------------
/var/lib/pgsql/data
(1 row)
or
$ psql -h localhost -U postgres
Password for user postgres:
psql (14.3)
Type "help" for help.
postgres=# SELECT version();
version
-----------------------------------------------------------------------------------------------------------
PostgreSQL 14.3 on x86_64-koji-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-15), 64-bit
(1 row)
Option pgAdmin 4
You can access to PostgreSQL using pgAdmin 4 with ssh tunnel.
Dashboard
Click Add New Server
General
Type Your DB Server Name
SSH Tunnel
Click SSH Tunnel Tab
- Use SSH tunneling: On
- Tunnel host: your server ip address
- Tunnel port: 22
- Authentication: Identity file
- Identity file: *****.pem
Connection
Click Connection Tab
- Host name/address: localhost
- Port: 5432
- Maintenance database: postgres
- Username: postgres
- Password: *******
Click Save
Let’s use pgAdmin
