As the collectd PostgreSQL module needs to log in to a database within the cluster to gather its statistics, we should create a user specifically for this purpose. Execute this SQL query with an appropriate password:
CREATE USER perf_mon WITH PASSWORD 'testpw';
In addition, follow the instructions in the Installing and configuring collectd recipe so that there is a fully-functional collectd client and server.