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.
To deploy the PostgreSQL server to lttle.cloud, run:
lttle deploy postgresql.lttle.yamlThis 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 -WWhere -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=#