Keeping Postgresql-9.6 on Buster

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Keeping Postgresql-9.6 on Buster

Phil Endecott
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.






Reply | Threaded
Open this post in threaded view
|

Re: Keeping Postgresql-9.6 on Buster

Christoph Berg
Am 10. Juli 2019 17:39:30 MESZ schrieb Phil Endecott <[hidden email]>:
>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



Reply | Threaded
Open this post in threaded view
|

Re: Keeping Postgresql-9.6 on Buster

Phil Endecott
Hi Christoph,

Christoph Berg wrote:

> Am 10. Juli 2019 17:39:30 MESZ schrieb Phil Endecott <[hidden email]>:
>>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.





Reply | Threaded
Open this post in threaded view
|

Re: Keeping Postgresql-9.6 on Buster

Christoph Berg-2
Re: Phil Endecott 2019-07-11 <[hidden email]>
> 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