PostgreSQL update timestamp when row is updated

ByUnknown

PostgreSQL update timestamp when row is updated

In PostgreSQL, if you want to set current timestamp as default value, you can simply keep a column's default expression as 'now()'. However, by default there is no function defined to update the timestamp when a particular row (or multiple rows) are updated. In such...Read More

Accessing PostgreSQL server through a SSH Tunnel

ByUnknown

Accessing PostgreSQL server through a SSH Tunnel

Step 1: Check the SSH connectivity with the server, verify username and password. Step 2: Create the tunnel in your local system by executing the following command (It will prompt for password): $ ssh -fNg -L 5555:localhost:5432 <user>@<server> Step 3: Now, open your...Read More

Fixing the VNC's blank/grey screen with three checkboxes problem (~/.vnc/xstartup in Ubuntu)

ByUnknown

Fixing the VNC's blank/grey screen with three checkboxes problem (~/.vnc/xstartup in Ubuntu)

After installing VNC server on Ubuntu (usually occurs on servers), sometimes one may face a problem in which after logging in by a VNC client/viewer, it shows just a blank screen with three checkboxes. (See the image at the end of post) To...Read More