PFA directory structure

The easiest way to present the PFA structure is to lay it out in a table. Below the table, several explanations are provided to explain this structure.

In this document we consider the fact that PFA is a "Flexible" architecture. Therefore we provide instructions but only advices and best practices each one is free to respect of not. Also the level of details until which PFA should be implemented can be defined by the customer according to its requirements.

Unix – Windows directory structure

Mount Point	Directory	Owner	Description
/u01 Unix
Drive: Win.		root	The /u01 mount point contains the PostgreSQL administration files (software, configuration and log files, scripts)
	/app [ UNIX/Linux only ]	root	Application directory
(i.e oracle, mysql, Sybase, postgres)
	[/app]/postgres	postgres	PGBASE, basis for all Oracle components

PostgreSQL - Binary structure

Mount Point	Directory	Owner	Description
/u01	[/app]/postgres/product	postgres	Directory containing the PostgreSQL software installations
	[/app]/postgres/product/94	postgres	Product directory for 9.4 releases
	[/app]/postgres/product/94/db_0
[/app]/postgres/product/94/db_5
[/app]/postgres/product/95/db_1
[/app]/postgres/product/95/db_2	postgres	RDBMS installation 9.4.0
RDBMS installation 9.4.5
RDBMS installation 9.5.1
RDBMS installation 9.5.2

Administration structure

DMK

Mount Point	Directory	Owner	Description
/u01	[/app]/postgres/local/dmk	postgres	Database Management Kit – DMK
Database Creation scripts
Database Backup scripts
Database Sql scripts

Instance configuration and log files

Mount Point	Directory	Owner	Description
/u01	[/app]/postgres/admin/DB1/pg_log	postgres	The location of the PostgreSQLs server log file
/u01	[/app]/postgres/admin/DB1/conf	postgres	The location of the PostgreSQLs server configuration and host based authentication file

Database file directories

Datafiles

Mount Point	Directory	Owner	Description
/u02-/u09
Drive: Win.	/pgdata	postgres
	/pgdata/DB1
/pgdata/DB2	postgres	Data directory for DB1
Data directory for DB2

Backup

Mount Point	Directory	Owner	Description
/u98
Drive: Win.	[/pgdata]/backup/DB1/	postgres	Physical location of the backup directory for DB1.

Archived WALs

Mount Point	Directory	Owner	Description
/u98
Drive: Win.	[/pgdata]/arch/DB1/	postgres	Physical location of the archive directory