On Sun, May 31, 2020 at 02:02:08PM -0700, Adrian Klaver wrote:
> On 5/31/20 1:38 PM, Christophe Pettus wrote:
> >
> >
> > > On May 31, 2020, at 13:37, Adrian Klaver
> > > wrote:
> > >
> > > Just a reminder that the OP's original issue was with using pg_upgrade.
> >
> > True, although IIRC pg_
On Wed, Jun 3, 2020 at 04:10:55PM -0400, Alvaro Herrera wrote:
> On 2020-May-31, t...@exquisiteimages.com wrote:
>
> > I am now needing to upgrade to a new version of PostgreSQL and I am running
> > into problems when pg_upgrade calls pg_dump. pg_dump stalled at: "pg_dump:
> > saving database def
On 2020-May-31, t...@exquisiteimages.com wrote:
> I am now needing to upgrade to a new version of PostgreSQL and I am running
> into problems when pg_upgrade calls pg_dump. pg_dump stalled at: "pg_dump:
> saving database definition" for 24 hours before I killed the process.
>
> My pg_class table
On 5/31/20 1:38 PM, Christophe Pettus wrote:
On May 31, 2020, at 13:37, Adrian Klaver wrote:
Just a reminder that the OP's original issue was with using pg_upgrade.
True, although IIRC pg_ugprade uses pg_dump under the hood to do the schema
migration.
Again true, but pg_upgrade will not
> On May 31, 2020, at 13:37, Adrian Klaver wrote:
>
> Just a reminder that the OP's original issue was with using pg_upgrade.
True, although IIRC pg_ugprade uses pg_dump under the hood to do the schema
migration.
--
-- Christophe Pettus
x...@thebuild.com
On 5/31/20 1:13 PM, Christophe Pettus wrote:
On May 31, 2020, at 13:10, t...@exquisiteimages.com wrote:
On 2020-05-31 13:08, Christophe Pettus wrote:
On May 31, 2020, at 08:05, t...@exquisiteimages.com wrote:
My pg_class table contains 9,000,000 entries and I have 9004 schema.
Which version
> On May 31, 2020, at 13:10, t...@exquisiteimages.com wrote:
>
> On 2020-05-31 13:08, Christophe Pettus wrote:
>>> On May 31, 2020, at 08:05, t...@exquisiteimages.com wrote:
>>> My pg_class table contains 9,000,000 entries and I have 9004 schema.
>> Which version of pg_dump are you running? Ol
On 2020-05-31 13:08, Christophe Pettus wrote:
On May 31, 2020, at 08:05, t...@exquisiteimages.com wrote:
My pg_class table contains 9,000,000 entries and I have 9004 schema.
Which version of pg_dump are you running? Older versions (don't have
the precise major version in front of me) have N^2
> On May 31, 2020, at 08:05, t...@exquisiteimages.com wrote:
>
> My pg_class table contains 9,000,000 entries and I have 9004 schema.
Which version of pg_dump are you running? Older versions (don't have the
precise major version in front of me) have N^2 behavior on the number of
database ob
On 2020-05-31 11:24, Adrian Klaver wrote:
On 5/31/20 8:05 AM, t...@exquisiteimages.com wrote:
I have always used pg_basebackup to backup my database and I have
never had any issues.
I am now needing to upgrade to a new version of PostgreSQL and I am
running into problems when pg_upgrade calls
On 5/31/20 8:05 AM, t...@exquisiteimages.com wrote:
I have always used pg_basebackup to backup my database and I have never
had any issues.
I am now needing to upgrade to a new version of PostgreSQL and I am
running into problems when pg_upgrade calls pg_dump. pg_dump stalled at:
"pg_dump: sa
I have always used pg_basebackup to backup my database and I have never
had any issues.
I am now needing to upgrade to a new version of PostgreSQL and I am
running into problems when pg_upgrade calls pg_dump. pg_dump stalled at:
"pg_dump: saving database definition" for 24 hours before I kille
12 matches
Mail list logo
