994 reputation
723
bio website xenoterracide.com
location Austin, TX
age 30
visits member for 3 years, 11 months
seen Dec 19 at 23:03

Desktop

  • Gentoo Linux 2003 - 2009
    • First experience with Linux 4Q 2003
    • Long term functioning, dual boot, Linux install 4Q 2004
    • Stopped using Windows on a regular basis, approximately 2006
  • Arch Linux 2009 - present

Server ( well professionally, as I constantly run servers daemons on my desktop )

  • CentOS 2006 - 2007, 2010 - Present
    • BusinessGrade - Systems Administration Intern
    • Liquid Web - Linux System Administrator

Student, Web Developer, Systems Administrator See more on my blog.

Extended Contact info: xenoterracide@gmail.com: email, msn, gtalk; xenterracide: yahoo,aim,freenode;---


Oct
27
awarded  Notable Question
Oct
1
awarded  Popular Question
Sep
18
accepted transaction not processing?
Sep
18
asked how can I insert a long string into a blob using an insert statement?
Aug
5
awarded  Notable Question
Jul
30
answered transaction not processing?
Jul
30
asked transaction not processing?
Jul
28
accepted On reboot listeners don't start but restarting the service after will start them
Jul
24
answered On reboot listeners don't start but restarting the service after will start them
Jul
24
asked On reboot listeners don't start but restarting the service after will start them
Jul
8
comment How can I fake inet_client_addr() for unit tests in PostgreSQL?
I forget if in pgsql whether or not the signature is super important, but you could also do it as an optional parameter so if it's passed in it uses the passed in value, if not it uses inet_client_addr(), or if signatures are highly important have the sig without the extra param, delegate to the one with. Either way preserves the existing API while allowing testing of core logic.
Jul
8
comment How can I fake inet_client_addr() for unit tests in PostgreSQL?
inject the dependency? your_procedure( inet_client_addr() ) instead of an implicit call to it, no mocking/overriding required.
Jul
2
awarded  Curious
Jun
18
comment Mariadb new features vs PostgreSQL?
@Viraj why not get MariaDB to maintain a PostgreSQL comparison table (though based on that alone PostgreSQL has had RBAC since... 8.2? which is no longer supported due to age) that table is so, mysql vs maria specific you couldn't really use it to compare to other databases, guess what, none of the other db's have that storage engine, can't tell what that even means? why do I care about that engine?
Jun
16
comment increased tablespace but dba_tablespace_usage_metrics order shows same
yeah in this case it is 10G, we have 11 in some cases, but don't know if they exhibit the same behavior.
Jun
16
asked increased tablespace but dba_tablespace_usage_metrics order shows same
May
16
awarded  Popular Question
Mar
18
awarded  Nice Question
Feb
25
awarded  Popular Question
Jan
28
comment Postgres 8.3 faster than 9.3?
+1 just arguing that 8.3 is now unsupported, and thus will receive no updates going forward.