740 reputation
310
bio website blog.ringerc.id.au
location Western Australia, Australia
age
visits member for 2 years, 1 month
seen Nov 26 at 2:40

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.


Oct
28
awarded  Nice Answer
Oct
23
awarded  Yearling
Oct
13
comment PostgreSQL 9.3 denying remote connection from user despite pg_hba.conf/postgresql.conf configurations
In addition to giomasce's point, also make sure you reloaded PostgreSQL after changing pg_hba.conf.
Oct
8
comment Postgresql: How do full_page_writes help prevent data loss?
Reposted to dba.stackexchange.com/q/78644/7788 so please delete this one.
Sep
26
answered How to get crontab to run when backup requires a password
Sep
24
awarded  Autobiographer
Sep
17
revised tsvector type does not exist in Postgres 8.2.15 - how to fix?
Added greenplum tag, fixed formatting
Sep
16
answered tsvector type does not exist in Postgres 8.2.15 - how to fix?
Sep
16
suggested approved edit on tsvector type does not exist in Postgres 8.2.15 - how to fix?
Sep
4
comment Can't tab complete in psql
OS X uses libedit, rather than GNU Readline, and there have been a long series of bugs in libedit that've affected psql. Perhaps another libedit/readline difference is at fault? (I can't test, as I don't have Apple branded hardware and Apple won't let me run an OS X VM without buying their hardware - rather developer-hostile, no?)
Aug
31
answered postgres creating new user/role
Aug
25
answered Delete PostgreSQL data and Library directories on Mac
Aug
20
comment Postgresql 8.4 service not starting windows 7
... and the PostgreSQL logs, from data/pg_log? (By default, C:\Program Files\PostgreSQL\8.4\data\pg_log). As for needing 8.4, you'd better start grumping a the vendor of whatever the product is (or tell me what it is so I can grump at them), as 8.4 is end-of-life and going to be unsupported.
Aug
19
comment Postgresql 8.4 service not starting windows 7
Well, look at the windows error logs (Event Viewer), and PostgreSQL's own logs in the data/pg_log directory. Did you change anything? Did you just install Pg (and if so why on earth would you install 8.4?) or is this an old install? If it's an old install, what changed recently?
Aug
18
comment Debian - Postgresql can't install /etc/postgresql after purge
Please show the exact commands run.
Jul
31
answered Installing PostgresSQL on CentOS 6.4 without yum
Jul
17
answered Check the contents of a PostgreSQL data directory
Jul
3
comment PostgreSQL service password is reset after each Windows update
Do you mean the postgres password within PostgreSQL, that's used when you connect with psql? Or do you mean the service account password, for the postgres Windows user created by PostgreSQL installers below version 9.2?
Jun
20
comment Transactions per second in a database (say PostgreSQL)
See prev comment. Measure how long each commit takes. Should be avg wal writer delay / 2. If not show your self contained runnable test code, full pg config and test run logs.
Jun
19
comment Transactions per second in a database (say PostgreSQL)
Measure the delay between issuing the commit command and having it return. It'll average half your wal writer delay and be fairly evenly distributed. Because commits are queuing. Your mistake is assuming that only one record can be written when the wal writer wakes up. That is not the case.