The setup of the infrastructure with one CAS application server (Backend) and one separated dedicated DB server(DB) with PostgreSQL.
We asssume that PostgreSQL has been already installed on machine DB. Let's assume also that the IP address of the Backend is 195.208.a.b and the IP address of the DB is 212.192.x.y
After that we need to setup the connection between the Backend and BD.
host cas cas_user 195.208.a.b/32 md5
listen_addresses = '212.192.x.y' port = 5432
postgres@xxx:~$ createuser -P cas_user Enter password for new role: Enter it again: Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n CREATE ROLE
postgres@xxxx:~$ createdb cas CREATE DATABASE postgres@xxxx:~$ psql cas cas=# grant CREATE on database cas to cas_user; GRANT
killall -SIGHUP postmaster
math@aaaa: psql -h 212.192.x.y -U cas_user cas Password: Welcome to psql 8.1devel, the PostgreSQL interactive terminal. ....
The IP of the DB (212.192.x.y), the name of database "cas"", the name of the user "cas_user" and the password which we entered here will be used in setting up the JNDI connection source for Tomcat (that information will be in the context.xml of Axis)