DSI provides a PostgreSQL database server to all users that are already registered in the Fénix system.
The use of PostgreSQL’s service requires the knowledge to access this database. For more information, refer to PostgreSQL’s documentation page.
Activation
To activate the PostgreSQL service, please refer to the following procedure:
- You should activate the shell service in DSI’s self-service page, in case you don’t have already done it. This step allows the access to the sigma cluster.
- Now, login (via ssh) to sigma using the username and password from DSI’s centralized authentication system (the same credentials used to access the Fénix system). To do so, execute the following command:
- ~$ ssh sigma.ist.utl.pt -l [username] , where [username] corresponds to your Técnico ID, for example istxxxxx.
- Now execute the following command:
- istxxxxxx@sigmayy: ~$ psql_reset
This command creates a database with an identical name to the username and a password, which is shown in the screen. Save that password, since it will be needed every time you want to access the database.
Note: In case you have forgotten your password, the psql_reset command can be executed again. In this case, a new password will be generated, but the database and its content, if they exist, will not suffer any changes.
Access
The database server is running in db.tecnico.ulisboa.pt
You can access the PostgreSQL database directly via sigma or via any other computer with an internet connection. To do so, you need to have the MariaDB client installed in your computer and specify db.tecnico.ulisboa.pt as server:
- ~$ psql -U istxxxxxx -h db.tecnico.ulisboa.pt
- Password for user istxxxxxx: (password generated with the mysql_reset command)
For more information on how to access the sigma cluster, please refer to access to the sigma cluster page.