Craig Ringer

4,259 reputation

518

bio	website	blog.ringerc.id.au
	location	Western Australia, Australia
	age
visits	member for	1 year, 1 month
	seen	17 hours ago
stats	profile views	123

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.

	4,259 reputation	bio	website	blog.ringerc.id.au	visits	member for	1 year, 1 month
518 badges		location	Western Australia, Australia		seen	17 hours ago

summary answers questions tags badges favorites bounties reputation activity

601 Actions

suggestions reviews revisions comments badges posts accepts all

18h	revised	“relation does not exist” trying to import mysql dump into postgres added 129 characters in body
18h	answered	“relation does not exist” trying to import mysql dump into postgres
19h	comment	PostgreSQL group roles @Choens From the edited question it looks like you didn't grant the user USAGE of the schema its self, so they can't see the tables.
1d	revised	PostgreSQL group roles added 311 characters in body
1d	answered	PostgreSQL group roles
1d	comment	PostgreSQL group roles @Denis Details? Please show a sequence of commands that you see as faulty and the relevant PostgreSQL version. Any such concerns are extremely serious.
1d	comment	How to get the information of the optimizer of PostgreSQL? Yep, as collecting that information would its self have a cost that would slow planning down.
2d	comment	Configuring PostgreSQL for read performance Agree with horse, there's a notable lack of detail. Table and index sizes, bloat estimates, table and index definitions, info on the host hardware, exact PostgreSQL version, `explain (buffers, analyze)` output, etc.
May 15	comment	Can't set up witness in Repmgr 2.0 Appreciated. Re passwords have you tried using a .pgpass file (see pg docs) instead of trying to specify passwords in the conninfo strings?
May 15	comment	Can't set up witness in Repmgr 2.0 Interesting issue. Looks like we could make some improvements to error reporting there. repmgr version?
May 14	comment	How to install and configure Postgres-XC in windows? Clone of stackoverflow.com/q/16534109/398670. Please do not duplicate your posts, especially without linking between them. It wastes the time of people who're trying to help.
May 13	comment	Use select query in stored procedure The query always runs in the server backend. If you need to (a) run the query and (b) send the results to the client, then all a stored proc gains you is a little bit of startup overhead.
May 13	comment	How can I benchmark a PostgreSQL query? Check out `pgbench`; you can run it with custom scripts to do some of what you want. With a wrapper shell script to stop and restart Pg and to drop the OS disk cache you have most of what you need.
May 13	comment	Use select query in stored procedure Nowhere near enough detail here. PostgreSQL version? (I'm sure I've reminded you to always include your Pg version before). Queries? Table sizes? Client/server connection info?
May 13	answered	Use select query in stored procedure
May 13	comment	How to monitor or do vacuum without stop all? Answer updated with a bit more info.
May 13	answered	How to monitor or do vacuum without stop all?
May 12	comment	PostgreSQL created a PostgreSQL user on mac. Is this necessary? What does MySQL do on OS X anyway, just by way of comparison for those of us without a Mac? Install and run as root? BTW, PostgreSQL 9.2 and above run as `NETWORKSERVICE` on Windows, the built-in limited rights account for services that require network access, specifically to avoid having to create a user. I nagged the EnterpriseDB folks until they changed the installer to use it instead of creating a `postgres` account. Mac OS X does not (AFAIK) have a comparable built-in account so PostgreSQL must create its own limited rights account.
May 12	answered	createdb command error in postgres sql
May 12	answered	How to view the full, flattened query underlying a Postgresql view?