araqnid

466 reputation

bio	website	twitter.com/araqnid
	location	London, United Kingdom
	age	36
visits	member for	2 years, 4 months
	seen	Feb 27 at 12:41
stats	profile views	20

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.

	466 reputation	bio	website	twitter.com/araqnid	visits	member for	2 years, 4 months
25 badges		location	London, United Kingdom		seen	Feb 27 at 12:41

summary answers questions tags badges favorites bounties reputation activity

38 Actions

suggestions reviews revisions comments badges posts accepts all

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.