pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Keeping Postgresql-9.6 on Buster
4+ messages / 3 participants
[nested] [flat]

* Keeping Postgresql-9.6 on Buster
@ 2019-07-10 15:39  Phil Endecott <spam_from_pgsql_lists@chezphil.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Phil Endecott @ 2019-07-10 15:39 UTC (permalink / raw)
  To: pgsql-pkg-debian@lists.postgresql.org

Dear Experts,

I have a couple of cloud servers currently running PostgreSQL-9.6 on
Debian Stretch with streaming replication from one to the other.

I'd like to upgrade these to Buster, but keep PostgreSQL-9.6 for the
time being.  I think the packages at apt.postgresql.org will help
me to do this.  Can anyone offer any advice?

In particular, the Buster release notes mention an issue with
locales.  Is this something that I need to worry about even if I
keep PostgreSQL-9.6?  How does this interact with my replication
setup?  Can I replicate (temporarily) to an machine that has been
upgraded to the new locales from one that hasn't?


Thanks, Phil.









^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Keeping Postgresql-9.6 on Buster
@ 2019-07-11 05:32  Christoph Berg <cb@df7cb.de>
  parent: Phil Endecott <spam_from_pgsql_lists@chezphil.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Christoph Berg @ 2019-07-11 05:32 UTC (permalink / raw)
  To: pgsql-pkg-debian@lists.postgresql.org,Phil Endecott <spam_from_pgsql_lists@chezphil.org>

Am 10. Juli 2019 17:39:30 MESZ schrieb Phil Endecott <spam_from_pgsql_lists@chezphil.org>:
>Dear Experts,
>
>I have a couple of cloud servers currently running PostgreSQL-9.6 on
>Debian Stretch with streaming replication from one to the other.
>
>I'd like to upgrade these to Buster, but keep PostgreSQL-9.6 for the
>time being.  I think the packages at apt.postgresql.org will help
>me to do this.  Can anyone offer any advice?

Yes. This is one of the use cases for that repository.

>In particular, the Buster release notes mention an issue with
>locales.  Is this something that I need to worry about even if I
>keep PostgreSQL-9.6?

Still affected.

 How does this interact with my replication
>setup?  Can I replicate (temporarily) to an machine that has been
>upgraded to the new locales from one that hasn't?

No.

Christoph






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Keeping Postgresql-9.6 on Buster
@ 2019-07-11 12:30  Phil Endecott <spam_from_pgsql_lists@chezphil.org>
  parent: Christoph Berg <cb@df7cb.de>
  0 siblings, 1 reply; 4+ messages in thread

From: Phil Endecott @ 2019-07-11 12:30 UTC (permalink / raw)
  To: Christoph Berg <cb@df7cb.de>; pgsql-pkg-debian@lists.postgresql.org

Hi Christoph,

Christoph Berg wrote:
> Am 10. Juli 2019 17:39:30 MESZ schrieb Phil Endecott <spam_from_pgsql_lists@chezphil.org>:
>>In particular, the Buster release notes mention an issue with
>>locales.  Is this something that I need to worry about even if I
>>keep PostgreSQL-9.6?
>
> Still affected.
>
>> How does this interact with my replication
>>setup?  Can I replicate (temporarily) to an machine that has been
>>upgraded to the new locales from one that hasn't?
>
> No.

OK, I have found this: https://wiki.postgresql.org/wiki/Locale_data_changes
and your linked email.

Much of my data is just ASCII, or binary blobs, but I think I probably set
the locales to UTF8.  Hmmm.

I will probably have more questions, unless I just decide to not upgrade.
Is this the best place to ask?


Cheers, Phil.








^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Keeping Postgresql-9.6 on Buster
@ 2019-07-11 19:55  Christoph Berg <myon@debian.org>
  parent: Phil Endecott <spam_from_pgsql_lists@chezphil.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Christoph Berg @ 2019-07-11 19:55 UTC (permalink / raw)
  To: Phil Endecott <spam_from_pgsql_lists@chezphil.org>; +Cc: pgsql-pkg-debian@lists.postgresql.org

Re: Phil Endecott 2019-07-11 <1562848237936@dmwebmail.dmwebmail.chezphil.org>
> OK, I have found this: https://wiki.postgresql.org/wiki/Locale_data_changes
> and your linked email.
> 
> Much of my data is just ASCII, or binary blobs, but I think I probably set
> the locales to UTF8.  Hmmm.

You are affected as soon as you put an index on a "text" column with
en_US.UTF-8 collation that contains things as simple as "1-1" "1 1".
These will switch ordering, and the old index is corrupt wrt. the new
operating system. Indexes on "bytea" are fine.

> I will probably have more questions, unless I just decide to not upgrade.
> Is this the best place to ask?

Here or on pgsql-general.

Christoph





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2019-07-11 19:55 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-10 15:39 Keeping Postgresql-9.6 on Buster Phil Endecott <spam_from_pgsql_lists@chezphil.org>
2019-07-11 05:32 ` Christoph Berg <cb@df7cb.de>
2019-07-11 12:30   ` Phil Endecott <spam_from_pgsql_lists@chezphil.org>
2019-07-11 19:55     ` Christoph Berg <myon@debian.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox