release notes | Book: 1.9.5, 1.9.12 (opt, FHS), 2.7 (FHS), 2.8 (FHS), 2.9 (FHS), 2.10 (FHS), 2.11 (FHS), 2.12 (FHS), 2.13 (FHS), | Wiki | Q&A black_bg
Web: Multi-page, Single page | PDF: A4-size, Letter-size | eBook: epub black_bg

Performance of the PostgreSQL Server

On small systems it should never be a problem to use one single PostgreSQL server for all the functions listed above. In the standard installation, the ReplicaManager is not activated by default. The billing will only write to a file by default.

Whenever the PostgreSQL server is going to be used for another functionality, the impact on performance should be checked carefully. To improve the performance, the functionality should be installed on a separate host. Generally, a PostgreSQL server for a specific funcionality should be on the same host as the dCache cell accessing that PostgreSQL server, and the PostgreSQL server containing the databases for Chimera should run on the same host as Chimera and the PnfsManager cell of the dCache system accessing it.

It is especially useful to use a separate PostgreSQL server for the billing cell.

Note

The following is work-in-progress.

Create PostgreSQL user with the name you will be using to run pnfs server. Make sure it has CREATEDB privilege.

[user] $ psql -U postgres template1 -c "CREATE USER johndoe with CREATEDB"
[user] $ dropuser pnfsserver
[user] $ createuser --no-adduser --createdb --pwprompt pnfsserver

Table 23.1. Protocol Overview

Component Database Host Database Name Database User Database Password
SRMsrm.db.hostor if not set: srmDbHost or if not set: localhostdcachesrmdcachesrmdcache
pin managpinManagerDatabaseHost or if not set: srmDbHost or if not set: localhostdcachesrmdcachesrmdcache
ReplicaManagerreplica.db.host or if not set: localhostreplicassrmdcachesrmdcache
pnfs serverlocalhostadmin, data1, exp0, ...pnfsserver--free--
billingbillingDatabaseHost or if not set: localhostbillingsrmdcachesrmdcache