Author Archives: ronaldpringadi

Storage Speed Benchmark Using CrystalDiskMark

Posted on August 27, 2011 by ronaldpringadi

I have always been an enthusiast in computer hardware benchmark. Lately I been trying to increase my overall PC performance (both laptop and desktop). A speedy and responsive system does not only take a fast processor, but also enough RAM … Continue reading →

Posted in Benchmark, Hardware | Comments Off on Storage Speed Benchmark Using CrystalDiskMark

Vacuum the Whole Database in Postgres

Posted on August 26, 2011 by ronaldpringadi

Postgres comes with a functionality called vacuum. Vacuum is intended to cleanup dead tuples or rows. This is how you cleanup the entire DB in PostgreSQL 1/usr/pg9/bin/vacuumdb –full –port=5433 –username=YOUR_USERNAME –password DB_NAME

Posted in Database, PostgreSQL | Comments Off on Vacuum the Whole Database in Postgres

Finding a String Inside Multiple Files in Linux

Posted on August 25, 2011 by ronaldpringadi

This is how you can find a text/string Proudly inside folder /var/www. The -H parameter is to show the filename and -R is to make grep look recursively. 1grep -H -R "Proudly" /var/www

Posted in Linux | Comments Off on Finding a String Inside Multiple Files in Linux

Fix Microsoft Mouse in Linux Ubuntu

Posted on August 24, 2011 by ronaldpringadi

123456789101112nano /etc/X11/xorg.conf Section "InputDevice" Identifier "Configured Mouse" Driver "mouse" Option "CorePointer" # Option "Device" "/dev/input/mice" Option "Protocol" "ExplorerPS/2" Option "Emulate3Buttons" "false" Option "ZAxisMapping" "4 5" Option "ButtonMapping" "1 2 3 6 7" EndSection

Posted in Linux, Operating System, Ubuntu | Comments Off on Fix Microsoft Mouse in Linux Ubuntu

Colorize Linux Shell Menu

Posted on August 24, 2011 by ronaldpringadi

Do you ever feel like you’re going blind because the prompt text color and the result text color are the same? Here’s how to colorize your shell prompt. Open your favorite text editor (vim or nano), edit your ~/.bashrc, and … Continue reading →

Posted in Linux, Operating System, Ubuntu | Comments Off on Colorize Linux Shell Menu

Edit default Gnome-Terminal

Posted on August 24, 2011 by ronaldpringadi

Every time I open a shell terminal in my Ubuntu, I always think that the window size is too small. I always ended up resizing the shell window manually using the mouse. If you’re having this problem here is how … Continue reading →

Posted in Linux, Ubuntu | Comments Off on Edit default Gnome-Terminal

Add an Existing User to an Existing Group on Linux

Posted on August 24, 2011 by ronaldpringadi

1usermod -a -G GROUPNAME USERNAME

Posted in Linux | Comments Off on Add an Existing User to an Existing Group on Linux

Backup and Restore Postgres Using pg_dump and psql

Posted on August 24, 2011 by ronaldpringadi

This is how you backup your Postgres Database To Backup 1pg_dump –host=localhost –port=5432 –username=postgres –file=YOUR_FILENAME.sql YOUR_DB_NAME There are other options such as if you’re interested only on the structure then you can add: 1pg_dump –host=localhost –port=5432 –username=postgres –schema-only –format=p –create … Continue reading →

Posted in Database, PostgreSQL | Comments Off on Backup and Restore Postgres Using pg_dump and psql

Setting Session Authorization and Search Path

Posted on August 24, 2011 by ronaldpringadi

SET SESSION AUTHORIZATION jane; SET search_path = schema1,schema2, schema3; SELECT * FROM any_table_in_schema_1_2_or_3;

Posted in Database, PostgreSQL | Comments Off on Setting Session Authorization and Search Path

Implicit Casting in PostgreSQL

Posted on August 24, 2011 by ronaldpringadi

12CREATE CAST(integer AS character varying) WITH INOUT AS IMPLICIT; CREATE CAST (character varying AS integer) WITH INOUT AS IMPLICIT;

Posted in Database, PostgreSQL | Comments Off on Implicit Casting in PostgreSQL