On Wed, Sep 17, 2014 at 01:07:56PM +, Matthew Kelly wrote:
> * Unless you keep _all_ of your clusters on the same OS, machines
> from your database spare pool probably won't be the right OS when you
> add them to the cluster because a member failed.
There has been discussion about having ma
On Thu, Sep 18, 2014 at 6:51 AM, Heikki Linnakangas
wrote:
> The same it works with libxml, openssl, libreadline and all the other
> libraries you can build with.
I like the comparison with libxml. If we were to adopt ICU, it would
be as a core component that makes collation versioning work, that
On 09/18/2014 04:12 PM, Oleg Bartunov wrote:
On Thu, Sep 18, 2014 at 3:25 PM, Martijn van Oosterhout
wrote:
On Thu, Sep 18, 2014 at 01:35:10PM +0900, Tatsuo Ishii wrote:
In my understanding PostgreSQL's manual MUST include the ICU license
term (this is not a problem). What I am not so sure i
On Thu, Sep 18, 2014 at 3:25 PM, Martijn van Oosterhout
wrote:
> On Thu, Sep 18, 2014 at 01:35:10PM +0900, Tatsuo Ishii wrote:
> > In my understanding PostgreSQL's manual MUST include the ICU license
> > term (this is not a problem). What I am not so sure is, any software
> > uses PostgreSQL als
On Wed, Sep 17, 2014 at 03:57:38PM +0100, Greg Stark wrote:
> Then there's the concern that ICU is a *huge* dependency. ICU is
> itself larger than the entire Postgres install. It's a big burden on
> users to have to install and configure a second collation library in
> addition to the system libra
On Thu, Sep 18, 2014 at 01:35:10PM +0900, Tatsuo Ishii wrote:
> In my understanding PostgreSQL's manual MUST include the ICU license
> term (this is not a problem). What I am not so sure is, any software
> uses PostgreSQL also MUST include the ICU license or not. If yes, I
> think this is surely a
On Wed, Sep 17, 2014 at 9:35 PM, Tatsuo Ishii wrote:
> In my understanding PostgreSQL's manual MUST include the ICU license
> term (this is not a problem). What I am not so sure is, any software
> uses PostgreSQL also MUST include the ICU license or not. If yes, I
> think this is surely a problem
> On Wed, Sep 17, 2014 at 9:06 PM, Oleg Bartunov wrote:
>> We use ICU with postgres for many years in our mchar extension, which
>> provides case-insensitive text data type for popular russian financial
>> system. I don't know if we may ask ICU to give us special BSD-compatible
>> license ?
>
On Thu, Sep 18, 2014 at 1:09 PM, Peter Geoghegan wrote:
> On Wed, Sep 17, 2014 at 9:06 PM, Oleg Bartunov
> wrote:
> > We use ICU with postgres for many years in our mchar extension, which
> > provides case-insensitive text data type for popular russian financial
> > system. I don't know if
On 09/17/2014 09:17 PM, Robert Haas wrote:
> What I find astonishing is that whoever maintains glibc (or the Red
> Hat packaging for it) thinks it's OK to change the collation order in
> a minor release. I'd understand changing it between, say, RHEL 6 and
> RHEL 7. But the idea that minor release
On Wed, Sep 17, 2014 at 9:06 PM, Oleg Bartunov wrote:
> We use ICU with postgres for many years in our mchar extension, which
> provides case-insensitive text data type for popular russian financial
> system. I don't know if we may ask ICU to give us special BSD-compatible
> license ?
I don'
We use ICU with postgres for many years in our mchar extension, which
provides case-insensitive text data type for popular russian financial
system. I don't know if we may ask ICU to give us special BSD-compatible
license ?
On Wed, Sep 17, 2014 at 5:16 PM, Robert Haas wrote:
> Of course, there's also the question of whether ICU would have similar
> issues. You're assuming that they *don't* whack the collation order
> around in minor releases, or at least that they do so to some lesser
> degree than glibc, but is tha
On Wed, Sep 17, 2014 at 10:06 AM, Matthew Kelly wrote:
> Let me double check that assertion before we go too far with it.
>
> Most of the problems I've seen are across 5 and 6 boundaries. I thought I
> had case where it was within a minor release but I can't find it right now.
> I'm going to d
> On Wed, Sep 17, 2014 at 3:47 PM, Tatsuo Ishii wrote:
>> I don't think we cannot achieve that because even MySQL accomplishes:-)
>
> We've always considered it an advantage that we're consistent with the
> collations in the rest of the system. Generally speaking the fact that
> Postgres integrat
> On 9/17/14 10:47 AM, Tatsuo Ishii wrote:
>> Why don't we have our collation data? It seems MySQL has already done this.
>
> Where would you get the source data from? How would you maintain it?
Don't know. However seeing that that MySQL manages it, it should be
possible for us.
Best regards,
-
On Wed, Sep 17, 2014 at 7:46 AM, Greg Stark wrote:
> You could have a problem if you have an expression index on (timestamp
> AT TIME ZONE '...'). I may have the expression slightly wrong but I
> believe it is posisble to write an immutable expression that depends
> on the tzdata data as long as i
On Wed, Sep 17, 2014 at 11:08 AM, Peter Eisentraut wrote:
> I also wrote PostGIS dependent libraries, not PostGIS itself. If you
> are comparing RHEL 5 and 6, as you wrote elsewhere, then some of those
> will most likely be different. (Heck, glibc could be different. Is
> glibc never allowed to
On 9/17/14 2:07 PM, Peter Geoghegan wrote:
> On Wed, Sep 17, 2014 at 11:05 AM, Peter Eisentraut wrote:
>>> We could at least use the GNU facility for versioning collations where
>>> available, LC_IDENTIFICATION [1].
>>
>> It looks like the revisions or dates reported by LC_IDENTIFICATION
>> aren't
On 9/17/14 10:46 AM, Greg Stark wrote:
> You could have a problem if you have an expression index on (timestamp
> AT TIME ZONE '...'). I may have the expression slightly wrong but I
> believe it is posisble to write an immutable expression that depends
> on the tzdata data as long as it doesn't dep
On Wed, Sep 17, 2014 at 11:05 AM, Peter Eisentraut wrote:
>> We could at least use the GNU facility for versioning collations where
>> available, LC_IDENTIFICATION [1].
>
> It looks like the revisions or dates reported by LC_IDENTIFICATION
> aren't ever updated for most locales.
That's not surpr
On 9/17/14 9:07 AM, Matthew Kelly wrote:
> Here is where I think the timezone and PostGIS cases are fundamentally
> different:
> I can pretty easily make sure that all my servers run in the same timezone.
> That's just good practice. I'm also going to install the same version of
> PostGIS ever
On Wed, Sep 17, 2014 at 01:07:56PM +, Matthew Kelly wrote:
> I'm with Martjin here, lets go ICU, if only because it moves sorting
> to a user level library, instead of a system level. Martjin do you
> have a link to the out of tree patch? If not I'll find it. I'd like
> to apply it to a bran
On 9/16/14 5:57 PM, Peter Geoghegan wrote:
> On Tue, Sep 16, 2014 at 2:07 PM, Peter Eisentraut wrote:
>> Clearly, this is worth documenting, but I don't think we can completely
>> prevent the problem. There has been talk of a built-in index integrity
>> checking tool. That would be quite useful.
On 9/17/14 10:47 AM, Tatsuo Ishii wrote:
> Why don't we have our collation data? It seems MySQL has already done this.
Where would you get the source data from? How would you maintain it?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
On Wed, Sep 17, 2014 at 6:17 AM, Robert Haas wrote:
> What I find astonishing is that whoever maintains glibc (or the Red
> Hat packaging for it) thinks it's OK to change the collation order in
> a minor release. I'd understand changing it between, say, RHEL 6 and
> RHEL 7. But the idea that min
On Wed, Sep 17, 2014 at 3:47 PM, Tatsuo Ishii wrote:
> I don't think we cannot achieve that because even MySQL accomplishes:-)
We've always considered it an advantage that we're consistent with the
collations in the rest of the system. Generally speaking the fact that
Postgres integrates with the
Why don't we have our collation data? It seems MySQL has already done this.
http://dev.mysql.com/doc/refman/5.0/en/charset-collation-implementations.html
I don't think we cannot achieve that because even MySQL accomplishes:-)
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.
On Tue, Sep 16, 2014 at 11:41 PM, Peter Geoghegan wrote:
> The timezone case you highlight here seems quite distinct from what
> Matthew is talking about, because in point of fact the on-disk
> representation is merely *interpreted* with reference to the timezone
> database. So, you could have an
Let me double check that assertion before we go too far with it.
Most of the problems I've seen are across 5 and 6 boundaries. I thought I had
case where it was within a minor release but I can't find it right now. I'm
going to dig.
That being said the sort order changes whether you staticall
On Wed, Sep 17, 2014 at 9:07 AM, Matthew Kelly wrote:
> Here is where I think the timezone and PostGIS cases are fundamentally
> different:
> I can pretty easily make sure that all my servers run in the same timezone.
> That's just good practice. I'm also going to install the same version of
Here is where I think the timezone and PostGIS cases are fundamentally
different:
I can pretty easily make sure that all my servers run in the same timezone.
That's just good practice. I'm also going to install the same version of
PostGIS everywhere in a cluster. I'll build PostGIS and its de
On Tue, Sep 16, 2014 at 02:57:00PM -0700, Peter Geoghegan wrote:
> On Tue, Sep 16, 2014 at 2:07 PM, Peter Eisentraut wrote:
> > Clearly, this is worth documenting, but I don't think we can completely
> > prevent the problem. There has been talk of a built-in index integrity
> > checking tool. Th
On Tue, Sep 16, 2014 at 2:07 PM, Peter Eisentraut wrote:
> It seems to me that this is a more general problem that can affect any
> data type that relies on anything external. For example, you could
> probably create a case where indexes are corrupted if you have two
> different time zone databas
On Tue, Sep 16, 2014 at 2:07 PM, Peter Eisentraut wrote:
> Clearly, this is worth documenting, but I don't think we can completely
> prevent the problem. There has been talk of a built-in index integrity
> checking tool. That would be quite useful.
We could at least use the GNU facility for ver
On 9/16/14 12:06 PM, Matthew Kelly wrote:
> The second and far more challenging problem is how do we fix this issue?
> As of our last discussion, Peter Geoghegan revived the proposal of
> using ICU as an alternative.
>
> (http://www.postgresql.org/message-id/CAEYLb_WvdCzuL=cyf1xyzjwn-1cvo6kzeawm
Hello,
Last month, I brought up the following issue to the general mailing list about
how running streaming replication between machines running different versions
of glibc can cause corrupt indexes.
http://www.postgresql.org/message-id/ba6132ed-1f6b-4a0b-ac22-81278f5ab...@tripadvisor.com
In th
37 matches
Mail list logo
