Parallelizing PostGIS on FASRC

• Launching multiple instances of PostGIS

  • Go to the app launch page
  • Change the location of the database storage area to a new folder:

    /n/holyscratch01/enos_lab/$USER/$SLURM_JOB_ID
    

  • Check box: Initialize the Database store
  • Check box: Create DB (as we will restore the database from dumps) name for the database:usvotersdb

• Copy the dumps to your user directory

cp /n/holyscratch01/enos_lab/dkakkar/partisan /n/holyscratch01/enos_lab/$USER/partisan

• Load the partisan database from the dumps

screen

time pg_restore -j 8 -h localhost -p $port -d usvotersdb /n/holyscratch01/enos_lab/$USER/partisan/usvotersdbcompressed.pgsql

• You can create multiple postgis instances running in parallel in this way which are restored from the same db dump file