How to access the SOLIDserver database

SOLIDserver uses a postgresql database. You can access this database via CLI. The database is named ness2

# psql ness2
psql (9.1.14)
Type "help" for help.

or

# psql ness2 root
psql (9.1.14)
Type "help" for help.

For example member (in the failover setup)

ness2=# select * from member;
...

1. little bit cleaner where member_typ is M (Master) and B (Backup).

ness2=# select oid,member_type,member_name from member;
 oid | member_type |       member_name
-----+-------------+--------------------------
  - | M           | ddi-a.mgmt.corp.net
  - | B           | ddi-b.mgmt.corp.net
(2 rows)

or DNS

ness2=# select * from dns;

or user

ness2=# select * from usr limit 2;

or to which group the user belongs

select * from usr limit 2;
select * from usr where oid=2;
select * from link_grp_usr where usr_id=2;
select * from grp where oid=1;
select * from link_grp_service where grp_id=1;
...

Or any other table