/RoundCross_Server

Primary LanguageRust

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)