Kurinchi Blogger Scribbles …

Archive for the ‘Open Source’ Category

Jan 01

PostgreSQL: Create database, connect and list (command line)

Last updated: December 31st, 2013

Changing host configuration
$ vi /var/lib/pgsql/8.4/data/pg_hba.conf

Add postgresql to startup process
$ chkconfig postgresql-8.4 on

Start postgresql service
$ service postgresql-8.4 start

Access postgresql
$ su – postgresql
$ psql

Create database
postgres-# create database test

List databases
postgres-# \list

Exit postgresql
postgres-# \q (or \quit)

Connect to database
postgres-# \c test (\connect test)

Dec 31

How to install PostgreSQL on CentOS Linux?

Last updated: December 31st, 2013

First lets do an update before we start installing PostgreSQL

$ yum update

You can install PostgreSQL from CentOS Base repo or can do a search for the latest version and install it based on your needs. Method 1 describes manual setup and Method 2 indicates an install from CentOS base repo (more…)

May 20

MySQL GUI tool for Data Management

Last updated: May 20th, 2010

HeidiSQL – a comprehensive tool for MySQL management which is available for Free.

Manage data tables, export/import databases, synchronise tables between databases, integrity check, database backup service management, edit database content and many more features packaged as a solution for ALL your MySQL needs.

This runs on windows platforms – WinXP/XP7 and you can download HeidiSQL from Download link

Jan 01

CentOS Multimedia Flash MPlayer installation steps

Last updated: January 1st, 2010

One of the clean and easy installation steps can be found at http://www.sklav.com/?q=node/2

I have added this in the blog to help a newbie land in a page that is easy to follow. The steps cover

i) Adding rpmforge
ii) Adding adobe repo
iii) Installation command to install libraries, flash plugin and other streaming medias
iv) MPlayer codec installation

Dec 05

Virtual World: with VMWare Player

Last updated: December 4th, 2009

VMWare Player is a free software available from VMWare Inc. enabling the creation
of guest OS within an existing OS

Notes for a beginner …
* VMWare Player and VMWare Server are available for free
* A .vmdk file is the virtual hard drive for the guest OS
* A .nvram file stores the BIOS settings of the virtual machine
* A .vmx file stores the configuration settings for the virtual machine. All you
need is a text editor to edit the VMWare configuration settings.
* A .vmsd file stores information about VMWare snapshots.

Valid HTML 4.01 Strict  Valid HTML 4.01 Strict