Enable pgsql logging

Some days back I came to situation to find when the table rows are inserted and deleted by an unknown thread!.

Got an idea from one of my colleague and enabled the pgsql logging. It worked great :)

To enable logging

# Edit the pgsql configuration file
/var/lib/pgsql/data/postgresql.conf

# Under section # ERROR REPORTING AND LOGGING
# Edit the logging options and set your preferrence!.


...
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_line_prefix = '%u %h %t'
log_statement = 'all'
log_hostname = on
...


# Go to pgsql logging dir and tail for the logfile.
cd /var/lib/pgsql/data/pg_log/

To Alter MAC address in windows, linux

I heard that we can't use some internet broad band connectivity expect the specific system as it's bounded to that specific MAC address.

Hmmm, the above raised a question? how to use that in other laptop etc...

Got a suggestion, Why can't you change your machine or laptop's MAC address matching the original bounded MAC address.

To Change MAC address in windows!

Go to,

Settings > Network Connections > local area connection > General Tab > configure > Advanced > Locally Administered Address > value.

Give the value , MAC address of bounded machine.

To Change MAC address in linux!

ifconfig eth0 down

ifconfig eth0 hw ether 00:00:00:AB:AC:AA

ifconfig eth0 up

This will use the mac address temporally to browse!.