Round Cross Server
It uses rust as the server language and postrgreSQL to store the data
Start the Postgres DB
Start the database
docker compose up -d
If you want to check if the database is up and running do a docker ps
and then display the container's logs by a docker logs 3290f9616b1b
$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
3290f9616b1b postgres:latest "docker-entrypoint.s…" 8 seconds ago Up 6 seconds 0.0.0.0:5432->5432/tcp postgres_db
$ docker logs 3290f9616b1b
2021-12-23 10:00:52.062 UTC [1] LOG: starting PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2021-12-23 10:00:52.062 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2021-12-23 10:00:52.062 UTC [1] LOG: listening on IPv6 address "::", port 5432
2021-12-23 10:00:52.069 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-12-23 10:00:52.118 UTC [1] LOG: database system is ready to accept connections
Check DB
If you want to connect to the db you can run this command to join the docker command line and then enter the psql cli as root with the password provided on the docker-compose
docker exec -it postgres_db bash
psql -h postgres_db -d demo -U root ;
Once you are inside, you can run the \l
command and you'll be shown a list of databases
demo=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+------------+------------+-------------------
demo | root | UTF8 | en_US.utf8 | en_US.utf8 |
postgres | root | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | root | UTF8 | en_US.utf8 | en_US.utf8 | =c/root +
| | | | | root=CTc/root
template1 | root | UTF8 | en_US.utf8 | en_US.utf8 | =c/root +
| | | | | root=CTc/root
(4 rows)
The table we created is the demo, so we'll connect to that db by running \c demo
, which will allow us to list the relations inside that db with another \d
.
demo=# \d
List of relations
Schema | Name | Type | Owner
--------+----------------------------+-------+-------
public | __diesel_schema_migrations | table | root
public | articles | table | root
(2 rows)