Yesterday, I commented on a post about how widespread uptake on 9.0 replication will be. I disagreed with the assessment that “users” (by which we mean small installations of PostgreSQL, defined however you care to) will not be interested in 9.0’s hot standby/streaming replication.
Ultimately, of course, we’ll find out. But I strongly feel that 9.0’s streaming replication will
Over at the Command Prompt blog, Joshua Drake makes a (probably deliberately) provocative point about “users” not wanting replication, as opposed to “customers” who do. I’ll confess I’m not 100% sure about his distinction between “users” and “customers,” so I’ll just make something up: Users are the people sitting in front of the application, entering data, buying shoes, or doing
What does this mean?
It clearly means something along the lines of, “Can handle lots of transactions per unit time,” but how many?
I mean, WordPress with WP-SuperCache is “web scale” if all that is meant is, “Can be used to implement a high volume site,” but I assume those who are touting something as “web scale” are
The slides from my talk, Introduction to PostgreSQL are available here.
The archive video for the February 9, 2010 SFPUG meeting is now available:
For downloading, the direct link is here.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
The archive video for the December 8, 2009 SFPUG meeting is now available:
For downloading, the direct link is here.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
The archive video for the November 10, 2009 SFPUG meeting is now available:
For downloading, the direct link is here.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
No, I’m not going to write another Git vs Mercurial post that really digs into them, because… well, if you are using one or the other, it is probably for reasons that don’t have much to do with your preferences.
In strictly my opinion, for personal use, I like Mercurial. For projects that use Git, I use Git.
The archive video for the October 13, 2009 SFPUG meeting is now available:
For downloading, the direct link is here, and it is also available on Vimeo if that’s more your thing.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
The default installation of PostgreSQL listens on 127.0.0.1 (the local loopback address) and on Unix sockets. The controlling parameter, listen_addresses, isn’t documented to have a setting that just listens on sockets, and not the loopback address.
As it happens, such a setting exists:
1 listen_addresses=''
Among other things, this appears to prevent local instances of