Re: Binary downloads and upgrading the host OS

On Sat, Apr 25, 2020 at 17:07 Magnus Hagander wrote: ... > Also don't forget that on an upgrade from Debian 9 to 10, you most likely > need to reindex your string indexes, see > https://wiki.postgresql.org/wiki/Locale_data_changes > . >

Re: Binary downloads and upgrading the host OS

On Sat, Apr 25, 2020 at 5:39 PM Tom Browder wrote: > On Sat, Apr 25, 2020 at 10:24 AM Adrian Klaver > wrote: > > On 4/25/20 8:04 AM, Tom Browder wrote: > > > I am using the PostgreSQL binary downloads for Debian from your apt > > > repositories. > ... > > Looks good to me. I'm assuming you are l

Re: Triggers and Full Text Search *

@Ericson I have the script (statements?) by which I created the triggers, but since you asked I do not see them in pga4, from which I manage my postgres. I don't know if this is significant or not. Also, this was originally done quite a while ago, so my memory may be fuzzy. From the text of the sta

Re: Binary downloads and upgrading the host OS

On Sat, Apr 25, 2020 at 10:24 AM Adrian Klaver wrote: > On 4/25/20 8:04 AM, Tom Browder wrote: > > I am using the PostgreSQL binary downloads for Debian from your apt > > repositories. ... > Looks good to me. I'm assuming you are leaving the Postgres version the > same though. Is that correct? Ye

Re: Binary downloads and upgrading the host OS

On 4/25/20 8:04 AM, Tom Browder wrote: I am using the PostgreSQL binary downloads for Debian from your apt repositories. I am about to upgrade from Debian 9 to Debian 10 and would like comments for my plan: 1. I will follow Debian's instructions for upgrading from 9 to 10. 2. Before I start th

Binary downloads and upgrading the host OS

I am using the PostgreSQL binary downloads for Debian from your apt repositories. I am about to upgrade from Debian 9 to Debian 10 and would like comments for my plan: 1. I will follow Debian's instructions for upgrading from 9 to 10. 2. Before I start the actual upgrade, I will: + ensure all i