Skip to content

Latest commit

 

History

History
38 lines (25 loc) · 1.01 KB

File metadata and controls

38 lines (25 loc) · 1.01 KB

PostgreSQL Database Server Sample | lttle.cloud

This is a sample app demonstrating how to deploy a PostgreSQL database server on lttle.cloud.

The sample is deployed using Manual Flash Mode on lttle.cloud.

Deploy

To deploy the PostgreSQL server to lttle.cloud, run:

lttle deploy postgresql.lttle.yaml

This will pull the special flash-mode ready Docker image and deploy it.

After that you can connect to your PostgreSQL server via psql like so:

lttle machine exec --ns samples postgresql -i -t psql -d db -U user -W

Where -d db is the database name, -U user is the username and -W will prompt for the password.

Once connected you can run SQL commands like SELECT CURRENT_TIME; to verify that everything is working as expected:

psql (17.5 (Debian 17.5-1.pgdg120+1))
Type "help" for help.

db=# select CURRENT_TIME;
    current_time
--------------------
 19:28:34.886504+00
(1 row)

db=#