Using PostgreSQL

Refer to http://www.postgresql.org/ for the latest documentation.

Using psql, connect to the xcat database:

su - postgres
psql -h <hostname> -U xcatadm -d xcatdb  (default pw: cluster)

list the xCAT tables:

xcatdb=> \dt

show the entries in the nodelist table:

xcatdb=> select * from nodelist;

quit postgres:

xcatdb=> \q

Useful Commands

Show the SQL create statement for a table:

/usr/bin/pg_dump_xcatdb -U xcatadm -t <table_name>

# example, for prescripts table:
/usr/bin/pg_dump xcatdb -U xcatadm -t prescripts

List all databases in postgres:

su - postgres
psql -l