====== How to access the SOLIDserver database ======

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

<code>
# psql ness2
psql (9.1.14)
Type "help" for help.

</code>
or 
<code>
# psql ness2 root
psql (9.1.14)
Type "help" for help.

</code>

For example member (in the failover setup)

<code>
ness2=# select * from member;
...
</code>
  - little bit cleaner where member_typ is M (Master) and B (Backup).

<code>
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)
</code>

or DNS

<code>
ness2=# select * from dns;
</code>

or user

<code>
ness2=# select * from usr limit 2;
</code>

or to which group the user belongs

<code>
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;
...
</code>

Or any [[sysadmin:solidservertable|other table]]