You are here: Home Tech Notes General
General
PostgreSQL: Copy Database PDF Print E-mail
Tech Notes - General
Written by Rick   
Wednesday, 03 March 2010 00:00

It's not uncommon to run across a need to duplicate a database for testing purposes. PostgreSQL provides for the ability to duplicate the structure and data content with a single command;

 

CREATE DATABASE newdb WITH TEMPLATE originaldb;

 

With any luck it's obvious one needs to replace "newdb" with the new database name and "originaldb" with the name of the source database.

I've executed this command in phpPgAdmin (v4.2-beta-1) with success on a 657MB database. The process took approximately 10 minutes. I have no doubt the command can be executed from the pgsql prompt as well.

PostgreSQL DB Server version 8.1.11.

 
WinXP: Reset Administrator's Password PDF Print E-mail
Tech Notes - General
Written by Rick   
Friday, 12 February 2010 13:58

Here is one method used to replace or reset the Administrator's password in Window's XP;

  • Boot in Safe Mode.
  • Login as any valid user (other than Administrator).
  • Load a command prompt.
  • Reference: Typing 'net user' and pressing enter will generate the list of users.
  • Type 'net user Administrator *'.
  • Enter a new password and confirm when prompted.
  • You should now be able to login using the Administrator account.
Note: This may not work using a LIMITED account.
 
VirtualBox 1.6.2: Ubuntu 8.04 Host - WinXP Guest INFECTED PDF Print E-mail
Tech Notes - General
Written by Rick   
Wednesday, 16 July 2008 17:52
As an Ubuntu Linux user, I was under the impression that virtual machines were somehow not as exposed to viruses. Shame on whoever spewed that nonsense, shame on me for hoping it was true. I've got a configuration that's been infected - (K)Ubuntu 8.04 host with a WinXP guest. It's the guest files that are infected, the host is still clean.
Read more...
 
Speed Test: Drupal versus Joomla! PDF Print E-mail
User Rating: / 1
PoorBest 
Tech Notes - General
Written by Rick   
Sunday, 04 May 2008 00:00

As part of a research project, I needed to determine which content management system (CMS) has the best performance. The contestants were narrowed to the 2 most popular CMS's, Drupal and Joomla!. Versions 5.7 and 6.2 from Drupal as well as Joomla!'s 1.0.15 and 1.5.3 were selected for comparison. Unfortunately, Drupal's 5.7 version could not complete the installation on my web host as it could not lock the tables for exclusive use. As my objective was to determine performance, not ease of installation, Drupal 5.7 was omitted.

Testing out-of-the-box (stock) installations is problematic. Each version is configured differently and each project has it's own vision for what should be a basic stock installation. The purpose of this testing is to consider these factors to determine the speed/performance of the CMS basic installation. As such we'll consider not only raw delivery speed of the web index page but the size of the delivered page as well as the lines of code delivered.

Read more...
 
PostgreSQL Relocate Data Store PDF Print E-mail
User Rating: / 1
PoorBest 
Tech Notes - General
Written by Rick   
Monday, 10 December 2007 00:00

Installing a database server such as MySQL or PostgreSQL is not hard really. Being asked to move a database that already exists, on an OS you're not intimately familiar with, where it's in use on a high-traffic web site, and your knowledge of the database server is limited can be intimidating to say the least. I'm speaking of a PostgreSQL 8.1 running on a MAC OS X X-server in this case. After scrounging the web for several days I found information on the PostgreSQL database server to be less than I had hoped. There is plenty of documentation, user groups, and many hits on the web, but it just doesn't quite tell the whole story on what changes need to be made and it's been difficult to find the specific information needed to make the change. I've located 2 3 methods to accomplish the task of moving the data store (location of the database files). The Backup Method and the Move Method. Hopefully they are self explanatory, but here's a synopsis;

Read more...
 
Open Office: The Free Office Suite PDF Print E-mail
Tech Notes - General
Written by Rick   
Friday, 17 November 2006 10:27

This is a reprint of an article I did in 2006 that still applies today. The original article was posted at http://blog.coiusa.com. 


 

Open Office is an Open Source suite of applications that can be used as a replacement for Microsoft Office or Corel Office. The advantages and disadvantages follow;

Read more...
 
<< Start < Prev 1 2 Next > End >>

Page 1 of 2