Ever need to drop a postgresql database, but it would not let you because there are open connections to it (from a webapp or whatever)? Quite annoying. If on a production server, and other databases are being used, restarting postgresql is a last resort, because it generates downtime for your site (even if small). I [...]
Posts Tagged ‘PostgreSQL’
How to force-drop a postgresql database by killing off connection processes
Posted in Engineering, Linux, Open Source, Software, System Administration, Technique, tagged Drop Database, Kill Process, PostgreSQL, Process on November 3, 2010 | 4 Comments »
PostgreSQL Dump and Restore Notes
Posted in Open Source, Software, System Administration, Technique, tagged database backup, pg_dump, pg_restore, PostgreSQL on May 16, 2010 | Leave a Comment »
The pg_dump and pg_restore commands provide excellent flexibility in storing a compressed dump file, and selectively restoring any part of it. I’ve found that dropping and re-creating the target database is the cleanest way to restore a dumpfile — no stray relations left to cause trouble. Unless you own all of the objects being restored, [...]
A brief introduction to AppStruct
Posted in AppCove, AppStruct, Engineering, Open Source, Technique, tagged Apache, AppCove, AppStruct, mod_wsgi, Open Source, PostgreSQL, Python, Shank on November 21, 2009 | Leave a Comment »
Have been very busy at work lately. We made the decision about a month ago to switch (most|all) new projects over to use Python 3 with Apache, mod_wsgi, and AppStruct. You may know what the first 3 are, but the 4th?? Special thanks goes to Graham Dumpleton behind mod_wsgi, and James William Pye behind Python>>Postgresql. [...]
