-
Sponsored Links
-
Recent Posts
- How to add ICMP Echo Request to AWS Security Group from the CLI
- How to fix STOP: 0x0000007B blue screen when moving virtualbox machine to another computer
- pip is broken with AttributeError: ‘module’ object has no attribute ‘SSL_ST_INIT’
- Generate a certificate request but keep your old key with openssl
- OSError: [Errno 1] Operation not permitted: Extras/lib/python/six-1.4.1-py2.7.egg-info’
Categories
- AWS (1)
- cli (1)
- CSS (1)
- django (4)
- DNS (1)
- DRBD (1)
- Exchange (1)
- FAX (1)
- FTP (1)
- git (2)
- Glusterfs (1)
- IIS (1)
- Kemp (1)
- Linux (38)
- lxc (3)
- Mac OS X (11)
- Malware (2)
- Microsoft (7)
- Multipoint Server 2012 (1)
- mysql (3)
- nagios (2)
- nginx (3)
- Office 365 (1)
- PHP (1)
- postgres (9)
- python (9)
- QNAP (1)
- raspberry pi (1)
- Samba (2)
- Security (1)
- SSL (10)
- Tomcat (1)
- Ubuntu (2)
- Uncategorized (4)
- Virtualbox (1)
- vmware (2)
- Web Programming (2)
- windows (12)
Archives
- September 2018 (3)
- August 2018 (1)
- October 2017 (1)
- November 2016 (1)
- October 2016 (2)
- September 2016 (1)
- May 2016 (1)
- December 2015 (1)
- November 2015 (1)
- October 2015 (2)
- September 2015 (1)
- August 2015 (2)
- July 2015 (1)
- June 2015 (1)
- March 2015 (3)
- January 2015 (3)
- November 2014 (1)
- October 2014 (1)
- September 2014 (1)
- August 2014 (2)
- April 2014 (1)
- February 2014 (3)
- January 2014 (1)
- November 2013 (3)
- October 2013 (3)
- September 2013 (1)
- August 2013 (3)
- July 2013 (1)
- June 2013 (1)
- May 2013 (1)
- April 2013 (3)
- March 2013 (5)
- February 2013 (3)
- January 2013 (1)
- December 2012 (5)
- November 2012 (3)
- October 2012 (1)
- September 2012 (1)
- August 2012 (2)
- July 2012 (4)
- April 2012 (1)
- March 2012 (2)
- February 2012 (1)
- January 2012 (4)
- December 2011 (1)
Monthly Archives: November 2013
QNAP USB external 3tb drive does not work
This is because you must use parted instead of fdisk to format the drive. parted /dev/sdta (parted) mklabel gpt mklabel gpt Warning: The existing disk label on /dev/sdta will be destroyed and all data on this disk will be lost. … Continue reading
Posted in Linux
Comments Off on QNAP USB external 3tb drive does not work
How to fix postgres sequences that are causing integrity errors.
Save this to a sql file: SELECT ‘SELECT SETVAL(‘ ||quote_literal(quote_ident(S.relname))|| ‘, MAX(‘ ||quote_ident(C.attname)|| ‘)+1) FROM ‘ ||quote_ident(T.relname)|| ‘;’ FROM pg_class AS S, pg_depend AS D, pg_class AS T, pg_attribute AS C WHERE S.relkind = ‘S’ AND S.oid = D.objid AND … Continue reading
Posted in postgres
Comments Off on How to fix postgres sequences that are causing integrity errors.
How to see currently executing queries in postgres 9.2
SELECT query,xact_start,query_start FROM pg_stat_activity;
Posted in postgres
Comments Off on How to see currently executing queries in postgres 9.2