anvil=# SELECT a.host_name, b.scan_drbd_resource_name AS name, b.scan_drbd_resource_up AS up, c.scan_drbd_volume_number AS volume, c.scan_drbd_volume_device_path AS dev_path, c.scan_drbd_volume_device_minor AS minor, c.scan_drbd_volume_size AS size, d.scan_drbd_peer_host_name, d.scan_drbd_peer_connection_state AS c_state, d.scan_drbd_peer_local_disk_state AS local_d_state, d.scan_drbd_peer_disk_state AS peer_d_state, d.scan_drbd_peer_local_role AS local_role, d.scan_drbd_peer_role AS peer_role, d.scan_drbd_peer_out_of_sync_size AS oos_size, d.scan_drbd_peer_replication_speed AS sync_speed, d.scan_drbd_peer_estimated_time_to_sync AS eta_to_sync, d.scan_drbd_peer_ip_address AS peer_ip, d.scan_drbd_peer_tcp_port AS port, d.scan_drbd_peer_protocol AS protocol, d.scan_drbd_peer_fencing AS fencing FROM hosts a, scan_drbd_resources b, scan_drbd_volumes c, scan_drbd_peers d WHERE a.host_uuid = b.scan_drbd_resource_host_uuid AND b.scan_drbd_resource_uuid = c.scan_drbd_volume_scan_drbd_resource_uuid AND c.scan_drbd_volume_uuid = d.scan_drbd_peer_scan_drbd_volume_uuid ORDER BY b.scan_drbd_resource_name ASC, a.host_name ASC;

       host_name        |    name    | up | volume |        dev_path        | minor |    size     | scan_drbd_peer_host_name |   c_state   | local_d_state | peer_d_state | local_role | peer_role | oos_size | sync_speed | eta_to_sync |  peer_ip   | port | protocol |       fencing

------------------------+------------+----+--------+------------------------+-------+-------------+--------------------------+-------------+---------------+--------------+------------+-----------+----------+------------+-------------+------------+------+----------+----------------------

 an-a01dr01.alteeve.com | srv01-psql | t  |      0 | /dev/drbd_srv01-psql_0 |     0 | 85894066176 | an-a01n01                | established | uptodate      | uptodate     | secondary  | primary   |        0 |          0 |           0 | 10.101.4.1 | 7788 | A        | dont-care

 an-a01dr01.alteeve.com | srv01-psql | t  |      0 | /dev/drbd_srv01-psql_0 |     0 | 85894066176 | an-a01n02                | established | uptodate      | uptodate     | secondary  | secondary |        0 |          0 |           0 | 10.101.4.2 | 7788 | A        | dont-care

 an-a01n01.alteeve.com  | srv01-psql | t  |      0 | /dev/drbd_srv01-psql_0 |     0 | 85896687616 | an-a01n02                | established | uptodate      | uptodate     | secondary  | secondary |        0 |          0 |           0 | 10.101.4.2 | 7788 | C        | resource-and-stonith

 an-a01n02.alteeve.com  | srv01-psql | t  |      0 | /dev/drbd_srv01-psql_0 |     0 | 85896687616 | an-a01n01                | established | uptodate      | uptodate     | secondary  | secondary |        0 |          0 |           0 | 10.101.4.1 | 7788 | C        | resource-and-stonith

(4 rows)