Technology Errors

createdb: database creation failed: ERROR: source database “template1” is being accessed by other users

When attempting to create a new database on a PostgreSQL server running walmgr, which is part of SkyTools by Skype Developers, for real time failover I received an error. Initially I was a bit baffled by the error however I remembered after racking my brain for a little bit that you must stop walmgr’s syncdaemon when adding a new database. Below are more details about the error as well as how to stop walmgr’s syncdaemon and then create the new database.

Technology Insights

How To Install SCP and SSH On Windows 7 Using Cygwin

I use Cygwin on Windows to make my Windows only computers as comfortable as possible to me. This comfort is provided by the Linux command line utilities that allow me to work. Cygwin provides a way for me to run these utilities from a Windows 7 command prompt. Two utilities that are really useful that are not installed with Cygwin by default are SCP (Secure Copy) and SSH (Secure Shell). Both of these utilities allow secure communication with remote computers. Below I describe adding them to an existing Cygwin Windows 7 installation.