Postgresql migration: usage report

Print Friendly, PDF & Email

I’ve checked the logs for postgresql usage on sabre to see if we are all set to decommission the server on Friday. As expected we are not quite yet. The following connections are being made, (numbers are collected for authenticated connections today):

  1. 230 user=ebm database=eels
  2. 135 user=visitpark database=visitpark
  3. 70 user=wwwilrt database=wwwilrt
  4. 59 user=heag database=heag
  5. 32 user=authoraid database=authoraid
  6. 18 user=ebm database=vts2009
  7. 7 user=sconul database=sconul
  8. 5 user=cros database=cros
  9. 3 user=lfzope database=lf
  10. 3 user=ilrtzope database=wwwilrt
  11. 2 user=athena database=athena
  12. 1 user=law database=law

Also, the database held in the standalone “public” postgresql instance is still in use.