PostgreSQL is used for various things in a dCache system: The SRM, the pin manager, the space manager, the replica manager, the pnfs companion, the billing cell, and the pnfs server might make use of one or more databases in a single or several separate PostgreSQL servers.

The SRM, the pin manager, the space manager, the replica manager, and the pnfs companion will use the PostgreSQL database as configured at cell start-up in the corresponding batch files. The billing cell will only write the accounting information into a database if it is configured with the option -useSQL. The pnfs server will use a PostgreSQL server if the pnfs-posgresql version is used. It will use several databases in the PostgreSQL server, just as the gdbm version of the pnfs server uses serveral database files. How to convert the gdbm files of an existing pnfs server into PostgreSQL databases is described in Chapter 19, Moving the pnfs Data from GDBM to PostgreSQL.

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

      psql -U postgres template1 -c "CREATE USER johndoe with CREATEDB"

      dropuser pnfsserver

      createuser --no-adduser --createdb --pwprompt pnfsserver


PostgreSQL in dCache:

component  |    Database Host               | Database Name | Database User / Pw
--------------------------------------------------------------------------------
SRM        | ${srmDatabaseHost}             | dcache        | srmdcache
           |   or if not set: ${srmDbHost}  |               | srmdcache
           |     or if not set: localhost   |               |
--------------------------------------------------------------------------------
pin manag. | ${pinManagerDatabaseHost}      | dcache        | srmdcache
           |   or if not set: ${srmDbHost}  |               | srmdcache
           |     or if not set: localhost   |               |
--------------------------------------------------------------------------------
space man. | ${spaceManagerDatabaseHost}    | dcache        | srmdcache
           |   or if not set: ${srmDbHost}  |               | srmdcache
           |     or if not set: localhost   |               |
--------------------------------------------------------------------------------
companion  | ${companionDatabaseHost}       | companion     | srmdcache
           |   or if not set: localhost     |               | srmdcache
--------------------------------------------------------------------------------
replica m. | ${replicaManagerDatabaseHost}  | replicas      | srmdcache
           |   or if not set: localhost     |               | srmdcache
--------------------------------------------------------------------------------
pnfs server| localhost                      | admin, data1, | pnfsserver
           |                                | exp0, ...     | --free--
--------------------------------------------------------------------------------
billing    | ${billingDatabaseHost}         | billing       | srmdcache
           |   or if not set: localhost     |               | srmdcache