Description
Portfolio backup sizes don't decrease after I delete catalogs.
Solution
In the current version of Portfolio, deleting a catalog does not delete its data from Portfolio's PostgreSQL database. If you want to remove the deleted catalog data from the PostgreSQL database to reclaim disk space and decrease backup size, you can use the following steps:
- Log into Portfolio Administration
- Stop the Portfolio Server
- On Mac OS X:
- Open Terminal
- Type in the following and hit Return:/Library/Extensis/Portfolio/pgsql/bin/psql -h localhost -p 25432 -W -c ‘vacuum full’ portfolio portfolio
- The command will prompt for a password. Type in esp and hit Return
- On Windows:
- Open the Command prompt
- Type in the following and hit Enter:"C:\Program Files (x86\)Extensis\Portfolio Server\applications\pgsql\bin\psql" -h localhost -p 25432 -W -c ‘vacuum full’ portfolio portfolio
- The command will prompt for a password. Type in esp and hit Return
If you need assistance with this, feel free to contact technical support for assistance.