How to Reset a PostgreSQL Password

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. Here is an instruction to tell you how to reset PostgreSQL password to keep its security.

 

1. Click “Start” and type “cmd.exe” in the Search bar to open a new command terminal on the server running PostgreSQL.

1

2

2. Type “psql -h localhost” without quotes into the command window so that you could access the PostgreSQL database from the root account of the computer running the server.

3. Run the command “ALTER USER <name> WITH PASSWORD ‘password’;.” Replace name and password with the new one you want. Now you’ve successfully reset the PostgreSQL password.

How to fix the error message “Video not available, cannot find MJPG decompressor” occurred in IrfanView?

IrfanView is a fast and compact image viewer/converter. The interface of IrfanView is clear and intuitive, which makes it easy with use for beginners and powerful for professionals. However how do we solve the error occurred during the running processes? Here is the instruction to tell you how to fix the error message “Video not available, cannot find MJPG decompressor” when you play some AVIs.

 

1. Click on the “Options” tab on the top menu, select on “Properties/ Settings”.

1

2. Go to ‘Video/ Sound’ and activate the option: ‘Use DirectShow for playing(use Pause/ Arrow keys as controls)’.

2

3. Click “OK” to confirm.

4. If this method doesn’t work, you could install the MJPG (Motion JPEG) video codec.

How to Use SpeedFan

As we all know, temperature is a key factor to computer hardware, the cooler the better. So monitoring hardware’s condition is very important to us. SpeedFan is a program that monitors voltages, fan speeds and temperatures in computers with hardware monitor chips. SpeedFan can even access S.M.A.R.T. info and show hard disk temperatures. Here is the instruction to tell you how to use SpeedFan easily.

1

 

1. Download and install SpeedFan from here:

http://www.filepuma.com/download/speedfan_4.51-8191/

2. Run SpeedFan.

3. Look at the temperatures listed of internal temperatures gathered from the internal temperature sensors in your system. You can choose the temperatures you want to monitor. You could also click “Configure” button to change temperatures.

2

4. Different icons have different meanings. Green check marks mean that the component is running at a safe temperature. A blue down arrow means that the component is running cooler than normal or is decreasing in temperature. A red up arrow means that the temperature of that component is rising. A flame icon means that the component is running above normal temperatures.

3

5. You need to compare the temperature readings to the safe temperatures standard for your hardware to keep it safe.

6. Click Charts tab , select the component you want to chart to compare temperatures over a length of time.

4