Migrating CUPS and PyKota to new hardware

From Wiki

Jump to: navigation, search

On the existing server

  • Take a backup of the existing database as follows: 
# pg_dump -f pykota.sql -U pykotaadmin -W pykota
  • After entering a password, a file named 'pykota.sql' will be created
  • Copy the newly created file to the new hardware using scp: 
# scp ./pykota.sql username@newServer:./
  • Copy the printer definitions to your new server: 
# scp /etc/cups/printers.conf user@newServer:/etc/cups/
# scp /etc/cups/ppd/* user@newServer:/etc/cups/ppd

On the new server

  • Follow the guide to install CUPS & PyKota as normal. See CUPS and PyKota
  • Delete the database by running the following commands: 
# su postgres
# dropdb pykota
# createdb pykota
# psql -d pykota < pykota.sql
  • A number of SQL statements will scroll past; when these finish simply run a pykota command to check that the data is available, e.g.: 
# pkusers -L
  • After testing, simply point the clients at the new server
Retrieved from "http://www.edugeek.net/wiki/index.php?title=Migrating_CUPS_and_PyKota_to_new_hardware"