|
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.
|
|
|
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.
|
|
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...
|
|
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...
|
|
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...
|
|
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 |