Tuesday, January 24, 2012

Screenshots on the Mac

I keep forgetting the key combinations. Now I have them forever marked.

How to get screenshots on the Mac via MacRumors

Wednesday, January 18, 2012

Remote Management OS X command line

Via: http://support.apple.com/kb/HT2370#

To enable Remote Managment:

/System/Library/CoreServices/RemoteManagement/ARDAgent.app/Contents/Resources/kickstart -activate

To disable Remote Management:

/System/Library/CoreServices/RemoteManagement/ARDAgent.app/Contents/Resources/kickstart - deactivate

Friday, January 6, 2012

Alter resource queue in Greenplum

The documentation is a little off. To alter a resource queue in Greenplum run the following:

ALTER RESOURCE QUEUE queue_name COST THRESHOLD your_new_threshold;

The documentation states that you use WITH:

ALTER RESOURCE QUEUE myqueue WITH (MAX_COST=3e+10);

That, however, never worked for me. If you run \h ALTER RESOURCE QUEUE from a psql prompt, it gives you the proper syntax.