/circulation-purge-script

SQL script helping to resolve the OPDS purging issue currently present in Circulation Manager

circulation-purge-script

SQL script helping to resolve the OPDS purging issue currently present in Circulation Manager.

How to use the script:

  1. Clone the repository:
git clone https://github.com/vbessonov/circulation-purge-script.git
  1. Open the script in your favourite editor:
vi circulation-purge-script/circulation-purge-script.sql
  1. Replace v_data_source_name with the name of the data source you want to purge.
  2. Create a dump of the database:
pg_dump dbname > outfile
  1. Run the script:
psql -f circulation-purge-script/circulation-purge-script.sql

NOTE: You might want to use --single-transaction option to wrap all the commands in transaction:

psql --single-transaction -f circulation-purge-script/circulation-purge-script.sql