486 reputation
25
bio website twitter.com/araqnid
location London, United Kingdom
age 37
visits member for 3 years, 2 months
seen Mar 13 at 9:48
Currently working as a Tech-Finance Java developer; often slaving over a hot database, throwing XML around and wishing we used Git for version control. Past lives have featured Perl, Debian, C, C++ and sordid affairs with VHDL and Verilog simulators.

Jan
26
awarded  Yearling
Dec
20
comment Connect to Postgresql 9.2 from Eclipse Data Tools Platform
Presumably "postgres" is the default? Or "postgres" is tried and "template1" used as a fallback. Or the tool should know to put "database name" into the URL (but why it wasn't doing that before I don't know)
Dec
20
answered Connect to Postgresql 9.2 from Eclipse Data Tools Platform
Dec
18
comment What is actually happening when postgresql discovers the trigger file and promotes it self from slave to master?
yes, that's right.
Dec
17
answered What is actually happening when postgresql discovers the trigger file and promotes it self from slave to master?
Dec
17
comment Optimal way to ignore duplicate inserts?
@DaveJarvis: when it comes to data validation, duplication and redundancy aren't (necessarily) bad things
Dec
12
revised Rebuild a table from history records
use named window
Dec
12
revised Rebuild a table from history records
fixes after testing
Dec
12
answered Rebuild a table from history records
Dec
12
comment Postgres Incremental Backup (Continuous Archiving WAL)
You need to do pg_switch_xlog() copy files from your xlog archive that are not part of any previous backup. In order to restore, you must have the base backup and all xlog files up to the point that you want to restore too, yes. Once you have restored a db and started running it, you can't apply more xlog files.
Dec
12
answered Postgres Incremental Backup (Continuous Archiving WAL)
Dec
7
answered Why/how did the behavior of extract(epoch…) from “timestamp without time zone” fields change between PostgreSQL 8.4 and 9.2?
Dec
5
answered Advantages of using PgBouncer vs HAProxy?
Nov
16
comment Connecting pgAdmin3 to Postgres on Heroku
Awesome answer!
Oct
31
revised Postgres requires commit or rollback after exception
had "on" instead of "off"
Oct
31
awarded  Commentator
Oct
31
comment Postgres requires commit or rollback after exception
@DaveyBob Ah, then the JDBC driver will be adding an implicit "start transaction" before the first "insert" as well. I've added some more explanation.
Oct
31
revised Postgres requires commit or rollback after exception
added 1912 characters in body
Oct
31
answered Postgres requires commit or rollback after exception
Jul
13
comment PostrgeSQL 9.1 Certificate Authentication: how to get certificate common name of client?
@tscho unfortunately, afaik this information isn't put into shared memory in the way that the information in pg_stat_activity is, so the other processes can't access it.