14,710 reputation
11237
bio website blog.ringerc.id.au
location Western Australia, Australia
age
visits member for 2 years, 6 months
seen 20 hours ago

I'm a PostgreSQL admin/developer, sysadmin, multi-language programmer (lately mostly Java and Java EE, previously C, C++, Python and good old bash) and general IT JOAT.

I work for 2nd Quadrant, a global PostgreSQL consultancy.

I maintain a technical blog at blog.ringerc.id.au. My PostgreSQL writing now appears on the 2nd quadrant blog.

I'll work in most programming languages with varying degrees of competence, though I'll only reluctantly touch PHP or Perl code. I'm more interested in the libraries, tools, and the code that's built on top of the language.

Most of my scrap code lives on https://github.com/ringerc . Most of my open source code is in the form of scattered patches across too many different bugzillas and JIRAs, rather than single new projects. Over time I've done a lot of work on Scribus and PoDoFo, but have moved away from both projects as my focus and interests changed. I contribute patches - rather infrequently - to PostgreSQL and to various Java EE 6 infrastructure components. Most of my contribution is now non-code, in the form of:

  • Detailed bug reporting with test cases, which I spend an unpleasant proportion of my development time preparing and submitting, mostly against JBoss and java.net projects.
  • User support for PostgreSQL on mailing lists and here on SE
  • PostgreSQL patch review and beta testing
  • Usability review of Java EE libs/tools, as well as usability review of PostgreSQL and its tools
  • Writing, editing and enhancing documentation, HOWTOs, etc
  • Blogging in detail on topics likely to be useful to others.

I've turned into a git fiend and no longer understand why anybody uses anything else. I'm also becoming increasingly obsessive about testing, particularly with the advent of Jenkins CI and Arquillian.


1d
comment ACID violation in Postgres 9.1?
@arthur Dirty reads aren't possible due to snapshots. So there's no dirty read to restart after. If you mean phantom reads, then no, as I explained above in auto-re-run.
2d
comment Why Postgresql 9.2 word boundary not working!
Good spot Daniel. I would have expected that the GIANT WARNING MESSAGES @MD.MohiuddinAhmed would've got about this on 9.1 should have been a hint, but i guess they chose to suppress and ignore them. Hmm, I guess we had those warnings for a reason after all.
2d
comment Why Postgresql 9.2 word boundary not working!
You'll need to provide some more details. Platform/OS/version, how you upgraded to 9.2, etc.
2d
answered Why Postgresql 9.2 word boundary not working!
2d
comment Optimizing query - understanding explain
Bizarre query plan formatting. Can't you just paste the unmodified output from EXPLAIN or preferably EXPLAIN ANALYZE?
2d
revised ACID violation in Postgres 9.1?
added 3153 characters in body
2d
answered ACID violation in Postgres 9.1?
Oct
21
comment ACID violation in Postgres 9.1?
Read the manual on transaction isolation and concurrency.
Oct
20
comment pg_get_viewdef error while running pg_dump in PostgreSQL
The fact that it is occasional is interesting. Any antivirus software on the computer? That's a common culprit.
Oct
20
comment “root” execution of the PostgreSQL server is not permitted
Doesn't it install a README or something with setup instructions? (I don't use FreeBSD).
Oct
20
comment How to simulate postgresql recovery mode?
@undefine In 8.3 the docs are postgresql.org/docs/8.3/static/continuous-archiving.html , there's no separate page for recovery.conf . (Prior link was intentionally to /9.1/ not /current/ as that's the oldest version that had the page)
Oct
20
comment How to simulate postgresql recovery mode?
Didn't notice you were on 8.3. That's super-obsolete. Plan an upgrade.
Oct
20
comment How to simulate postgresql recovery mode?
@undefine Er... recovery.conf. See postgresql.org/docs/9.1/static/recovery-config.html . But you're on an incredibly ancient version, so this advice probably doesn't apply.
Oct
20
answered How to simulate postgresql recovery mode?
Oct
18
comment How to get back the PostgreSQL database to a specific poin in time?
@user37651 The manual sets out the options. postgresql.org/docs/current/static/backup.html
Oct
17
comment How can I solve postgresql problem after deleting wal files?
@KookieMonster Please tell me their names so I can contact the vendors. That's bad.
Oct
16
comment Is there a faster way to get OR behavior in Postgres?
You'll need to translate 't1' and 't2' and the col names to those in the explain, too, otherwise there's no way to match what you're talking about above with the plan you showed.
Oct
16
comment Is there a faster way to get OR behavior in Postgres?
explain analyze ...
Oct
16
revised How can I solve postgresql problem after deleting wal files?
added 672 characters in body
Oct
16
comment How to get back the PostgreSQL database to a specific poin in time?
@user37651 You can't do a PITR recovery without stopping the database. In fact, you must stop it, restore the base backup and only then start it with an appropriate recovery.conf. PITR doesn't let you go backward in time, only forwards. So you have to restore an old enough backup, then replay forwards in time from it to reach the desired point.