-general
Subject: Re: upgrade and migrate
Off topic but food for thought given the jump in versions 8.3 to (9.6 or
greater.)
List of major changes i can think of to watch out for that can bite without
warning..
SQL operators~=~ for Like were drop in 8.4 => for hstore was drop in 9.0
in
l-general@lists.postgresql.org ;
> pgsql-general
> *Subject:* Re: upgrade and migrate
>
> Stephen Frost writes:
> > * Laurenz Albe (laurenz.a...@cybertec.at) wrote:
> >> Right, Slony is the way to go, since pg_upgrade doesn't support 8.3.
> >> I would upgr
*From:* Tom Lane
*Sent:* Wednesday, December 4, 2019 5:28 AM
*To:* Stephen Frost
*Cc:* Laurenz Albe ; Michael Paquier
; Julie Nishimura ;
pgsql-general@lists.postgresql.org ;
pgsql-general
*Subject:* Re: upgrade and migrate
Stephen Frost writes:
* Laurenz Albe
step requires downtime. Second does not. Correct?
-Julie
From: Tom Lane
Sent: Wednesday, December 4, 2019 5:28 AM
To: Stephen Frost
Cc: Laurenz Albe ; Michael Paquier
; Julie Nishimura ;
pgsql-general@lists.postgresql.org ;
pgsql-general
Subject: Re: upgrade
On 2019-12-04 08:56, Laurenz Albe wrote:
On Wed, 2019-12-04 at 13:48 +0900, Michael Paquier wrote:
On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote:
Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gn
Stephen Frost writes:
> * Laurenz Albe (laurenz.a...@cybertec.at) wrote:
>> Right, Slony is the way to go, since pg_upgrade doesn't support 8.3.
>> I would upgrade to a version more recent than 9.6.
> So... there's a bit of history here. pg_upgrade in 9.4 actually does
> support upgrading from
Greetings,
* Laurenz Albe (laurenz.a...@cybertec.at) wrote:
> On Wed, 2019-12-04 at 13:48 +0900, Michael Paquier wrote:
> > On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote:
> > > Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
> > > x86_64-redhat-linux-gnu to Postg
On Wed, Dec 04, 2019 at 08:38:01AM +0100, Thomas Kellerer wrote:
> But pg_upgrade only supports 8.4+
Ditto. You're right here.
--
Michael
signature.asc
Description: PGP signature
On Wed, 2019-12-04 at 13:48 +0900, Michael Paquier wrote:
> On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote:
> > Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
> > x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu
> > server, with minimal downtime
Michael Paquier schrieb am 04.12.2019 um 05:48:
> On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote:
>> Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
>> x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu
>> server, with minimal downtime?
>> The cave
On 12/3/19 10:48 PM, Michael Paquier wrote:
On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote:
Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu
server, with minimal downtime?
The caveat is the sourc
On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote:
> Hello, what is the best way to migrate from PostgreSQL 8.3.11 on
> x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu
> server, with minimal downtime?
> The caveat is the source has about 80 databases overall almost
12 matches
Mail list logo
