Implementing Custom Query for Drupal View

http://drupal.org/node/409808

Implementing Custom Query for Drupal View

http://drupal.org/node/409808

Slow deleting behavior in Windows Xp

I have windows up machine at work. Everything runs fine except I noticed it is hard for me to delete files from the hard disk no matter how big the file.  Sometimes, the operating system is paused waiting for the delete task to complete. I have checked the hard disk problem and defrag the hard disk. But they are not helping.

After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!

Slow deleting behavior in Windows Xp

I have windows up machine at work. Everything runs fine except I noticed it is hard for me to delete files from the hard disk no matter how big the file.  Sometimes, the operating system is paused waiting for the delete task to complete. I have checked the hard disk problem and defrag the hard disk. But they are not helping.

After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!

Clear Firfox Address Bar History

To definitely clear your firefox address bar histories, you can follow these steps:

1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.

Does this work for you?

Clear Firfox Address Bar History

To definitely clear your firefox address bar histories, you can follow these steps:

1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.

Does this work for you?

Backup and Restore Postgresql Database

create database:
[sourcecode language="bash"]
#create database from bash shell
su - postgres
bash-3.2$ createdb db_name;
bash-3.2$ dropdb db_name;
[/sourcecode]


Or you can go into database:
[sourcecode language="bash"]
#frm psql
#Connect as postgres to the postgres database
psql -d postgres postgres;
postgres=# create database new_db_name;
postgres=# drop database new_db_name;
[/sourcecode]


To backup a Postgresql Database:
[sourcecode language="bash"]
#bash shell
pg_dump -U db_user_name database_name -f backup_file_name.sql
[/sourcecode]


This command is to backup the database_name to file backup_file_name.sql.
To backup a specific schema of the database, use -n parameter
[sourcecode language="bash"]
#bash shell
pg_dump -U htang tripal_dev -n chado -f ~/DBBackups/tripal_dev__chado_only_20110901.sql
[/sourcecode]


To restore a backup from file use the follwing command:
[sourcecode language="bash"]
#bash shell
psql -f backup_file_path_and_name DATABASE_name;
#or you can
psql -d database_name < backup_file_path_and_name;
[/sourcecode]