Removing `xcatdb` from PostgreSQL and restoring data into SQLite

To remove xcatdb completely from the PostgreSQL database and restore xCAT data into SQLite:

Run a backup of the database to save any information that is needed:
```
mkdir -p ~/xcat-dbback
dumpxCATdb -p ~/xcat-dbback
```
Stop the xcatd daemon on the management node.

service xcatd stop
Remove the xatdb from PostgreSQL:
```
su - postgres
```
drop the xcatdb:
```
dropdb xcatdb
```
remove the xcatadm database owner :
```
dropuser xcatadm
```
clean up the postgresql files (necessary if you want to re-create the database):
```
cd /var/lib/pgsql/data
rm -rf *
exit
```
Move, or remove, the /etc/xcat/cfgloc file as it points xCAT to PostgreSQL. (without this file, xCAT defaults to SQLite):
```
mv /etc/xcat/cfgloc /etc/xcat/cfgloc.postgres
```

Restore the PostgreSQL database into SQLite:

XCATBYPASS=1 restorexCATdb -p ~/xcat-dbback

Removing xcatdb from PostgreSQL and restoring data into SQLite