April 2009

Blackberry Bold PhoneA while back we discussed about 12 powerful PuTTY add-ons. When you are working on production support or on a critical project that require 24×7 support, it is essential that you connect to the remote Linux server from anywhere. I found having a SSH client on my phone is very convenient for a quick status check and troubleshooting.

MidpSSH is a SSH and Telnet client for mobile device.

This is a step-by-step guide on how to connect to a Linux server from blackberry phone using MidpSSH software.

(more…)

{ 58 comments }

Vi and Vim Editor: 12 Powerful Find and Replace Examples

by SathiyaMoorthy on April 27, 2009

Vim Editor Search and Replace Syntax
Photo Courtesy: B Zedan

This article is part of the on-going Vi / Vim Tips and Tricks series. Vim is commonly mentioned as text editor, not text creator. Why ? Because we spend lot of time editing an existing text than creating new text.  In the text editing, text/pattern substitutions becomes a vital part.

In this article, let us review how to perform both basic and advanced text and pattern substitution features in Vi and Vim Editor. These features are explained using 12 very practical and powerful text substitution examples.
(more…)

{ 79 comments }

Code C Program using Vim Editor
Photo Courtesy: mint imperial

This article is part of the on-going Vi / Vim Tips and Tricks series. As a programmer or system administrator, you will be constantly browsing source codes and shell scripts.

Following are some typical activities that you may perform while browsing a source code file:

  1. Navigating to the function definition by specifying the function name.
  2. Navigating to the function definition from ‘function call’.
  3. Returning back again to function call from the definition.
  4. Viewing the prototype/signature of functions or variables.
  5. Viewing the number of functions in a file, etc.,

(more…)

{ 24 comments }

15 Practical PostgreSQL Database Administration Commands

by Ramesh Natarajan on April 16, 2009

PostgreSQL DBA Commands
Earlier we discussed about how to install PostgreSQL database on Linux from source.

In this article, let us review top 15 practical postgreSQL DBA command examples.

If you are a mySQL administrator, check-out our 15 examples of mysqladmin command article that we discussed a while back.


(more…)

{ 9 comments }

Less is More - The Ultimate Power of Linux Less Command
Photo courtesy of gfpeck

Earlier we discussed 15 practical examples of find command and grep command. Now, it is time to turn our attention to something less.
 
In this article, let us review how Linux less command can be used to open and view the following 10 different file types:

  1. PDF File – *.pdf
  2. Word Document- *.doc
  3. Image Files – *.gif, *.jpg, *.jpeg, *.png
  4. TAR Files – *.tar
  5. TAR Files with gzip – *.tar.gz
  6. Zip Files – *.zip
  7. Gzip and Gzip2 Files – *.gz and *.bz2
  8. ISO Files
  9. Debian Files – *.deb
  10. RPM Files – *.rpm

(more…)

{ 12 comments }

PostgreSQL Installation and Configuration Steps
Similar to mySQL, postgreSQL is very famous and feature packed free and open source database.

Earlier we’ve discussed several installations including LAMP stack installation, Apache2 installation from source, PHP5 installation from source and mySQL installation.

In this article, let us review how to install postgreSQL database on Linux from source code.

(more…)

{ 15 comments }

Compress, Encrypt, Split and Transport Big Files Safely

by Ramesh Natarajan on April 6, 2009

Encrypt and Attach Big Files to Email AttachmentsEmail administrators may set a limit on the maximum attachment size that can be attached to an email. You can follow the steps mentioned below to transfer big files that cannot be attached to the email because of the attachment size restriction.

This technique can be used in general whenever you need to split huge files, encrypt and transfer it.
(more…)

{ 8 comments }