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 PTC Arbortext Content Delivery Installer section in the PTC Arbortext Content Delivery Deployment Guide.