Test - PostgreSQL - Mixed

Tester of the PostgreSQL ability of ingesting and querying time series data at the same time.

Repository Structure

• build/, containing the generated .class files after compiling the java code;
• data/, containing the printers parsed logs files in the format of CSV files;
• logs/, containing the log information of all the tests done;
• resources/, containing the postgresql driver, the database credentials file and the logger properties;
• src/, containing the java source files;
• standalone/, containing the JAR standalone version of this repository.

Requirements

• PostgreSQL JDBC Driver (42.2.14)

Installation and running the project

• Create the folder data;
  • Inside the folder, copy-paste the printers parsed log files;
• Inside the folder resources,
  • Create a file called server_postgresql_credentials.txt, containing the username (first line) and the password (second line) to access the server PostgreSQL database;
  • Copy-paste the indicated PostgreSQL driver (called postgresql-42.2.14.jar);
• Execute bash compile_and_run.bash [l/s] [table_name]

Preparing the standalone version on the server

• Connect to the unibz VPN through Cisco AnyConnect;
• Open a terminal:
  • Execute ssh -t [email protected] "cd /data/sfracalossi ; bash";
  • Execute mkdir postgresql;
  • Execute mkdir postgresql/standalone_mixed;
  • Execute mkdir postgresql/standalone_mixed/resources;
  • Execute mkdir postgresql/standalone_mixed/data;
• Send the JAR and the help files from another terminal (not connected through SSH):
  • Execute scp standalone/NDataIngestionTest.jar [email protected]:/data/sfracalossi/postgresql/standalone_mixed/standalone;
  • Execute scp standalone/IndexChanger.jar [email protected]:/data/sfracalossi/postgresql/standalone_mixed/standalone;
  • Execute scp standalone/IngestionMixed.jar [email protected]:/data/sfracalossi/postgresql/standalone_mixed/standalone;
  • Execute scp standalone/QueryingMixed.jar [email protected]:/data/sfracalossi/postgresql/standalone_mixed/standalone;
  • Execute scp resources/server_postgresql_credentials.txt [email protected]:/data/sfracalossi/postgresql/standalone_mixed/resources;
  • Execute scp resources/logging.properties [email protected]:/data/sfracalossi/postgresql/standalone_mixed/resources;
• Send the data file:
  • Execute scp data/TEMPERATURE_HalfGB.csv [email protected]:/data/sfracalossi/postgresql/standalone_mixed/data;
  • Execute scp data/TEMPERATURE_1GB.csv [email protected]:/data/sfracalossi/postgresql/standalone_mixed/data;
• Sending the scripts:
  • Execute scp compile_and_run.bash [email protected]:/data/sfracalossi/postgresql/standalone_mixed;
  • Execute scp script.bash [email protected]:/data/sfracalossi/postgresql/standalone_mixed;
• Execute the JAR file (use the terminal connected through SSH):
  • Execute cd postgresql/standalone_mixed;
  • Execute nohup bash compile_and_run.bash [l/s] [table_name] > logs/out.txt &