Removing `xcatdb` from PostgreSQL¶

To remove xcatdb completely from the PostgreSQL database:

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. Note: If you are using xCAT Hierarchy (service nodes) and removing xcatdb from postgres, hierarchy will no longer work. You will need to configure another database which supports remote database access to continue using the hierarchy feature.
```
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 *
```
Move, or remove, the /etc/xcat/cfglog file as it points xCAT to PostgreSQL. (without this file, xCAT defaults to SQLite):
```
mv /etc/xcat/cfgloc /etc/xcat/cfglog.postgres
```

Restore the PostgreSQL database into SQLite:

XCATBYPASS=1 restorexCATdb -p ~/xcat-dbback

Removing xcatdb from PostgreSQL¶