Creating PostgreSQL Database
To create a PostgreSQL database for PTC Arbortext Content Delivery see the following:
Database Installation
For database installation, perform the following steps:
 |
Ensure that you have an empty database with appropriate permissions.
|
1. Install PostgreSQL using the following instructions:
sudo su –
yum install postgresql
yum install postgresql
2. Login to postgreSQL with system account as follows. Here, postgres is used as an example, where postgres is your respective DB administrator user.psql --host=postgree.ptc.com --port=5432 --username=postgres --password --dbname=postgres
3. Create four users for the four accounts as follows:
CREATE USER ptc_cmi WITH password 'ptc_cmi';
CREATE USER ptc_e3c WITH password 'ptc_e3c';
CREATE USER ptc_titan WITH password 'ptc_titan';
CREATE USER ptc_titan2 WITH password 'ptc_titan2';
CREATE USER ptc_e3c WITH password 'ptc_e3c';
CREATE USER ptc_titan WITH password 'ptc_titan';
CREATE USER ptc_titan2 WITH password 'ptc_titan2';
4. Grant permissions to the users as follows:
grant ptc_cmi to postgres;
grant ptc_e3c to postgres;
grant ptc_titan to postgres;
grant ptc_titan2 to postgres;
grant ptc_e3c to postgres;
grant ptc_titan to postgres;
grant ptc_titan2 to postgres;
5. Create the following schemas:
CREATE SCHEMA ptc_cmi AUTHORIZATION ptc_cmi;
CREATE SCHEMA ptc_e3c AUTHORIZATION ptc_e3c;
CREATE SCHEMA ptc_titan AUTHORIZATION ptc_titan;
CREATE SCHEMA ptc_titan2 AUTHORIZATION ptc_titan2;
CREATE SCHEMA ptc_e3c AUTHORIZATION ptc_e3c;
CREATE SCHEMA ptc_titan AUTHORIZATION ptc_titan;
CREATE SCHEMA ptc_titan2 AUTHORIZATION ptc_titan2;
6. Test connections as follows:
psql --host=postgree.ptc.com --port=5432 --username=ptc_e3c --password --dbname=ptc_e3c
psql --host=postgree.ptc.com --port=5432 --username=ptc_cmi --password --dbname=ptc_cmi
psql --host=postgree.ptc.com --port=5432 --username=ptc_titan --password --dbname=ptc_titan
psql --host=postgree.ptc.com --port=5432 --username=ptc_titan2 --password --dbname=ptc_titan2
psql --host=postgree.ptc.com --port=5432 --username=ptc_cmi --password --dbname=ptc_cmi
psql --host=postgree.ptc.com --port=5432 --username=ptc_titan --password --dbname=ptc_titan
psql --host=postgree.ptc.com --port=5432 --username=ptc_titan2 --password --dbname=ptc_titan2
PTC Arbortext Content Delivery Installation
For the PTC Arbortext Content Delivery installation instructions, see the Using the Installer section.