BUG #15893: pg_dump is not working like as postgres version 10

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 12345shaurya(at)gmail(dot)com
Subject: BUG #15893: pg_dump is not working like as postgres version 10
Date: 2019-07-04 07:35:39
Message-ID: 15893-9b899d18cad24716@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15893
Logged by: shaurya jain
Email address: 12345shaurya(at)gmail(dot)com
PostgreSQL version: 11.3
Operating system: CentOS release 6.5 (Final)
Description:

Dear Team,

I am having version 10 and version 11 on two servers. below command for
backup is not working in 11 but works fine in 10:-

pg_dump -U postgres -Fc >> all_db_04_07_2019.dump --verbose

pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: flagging indexes in partitioned tables
pg_dump: reading extended statistics
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading rewrite rules
pg_dump: reading policies
pg_dump: reading publications
pg_dump: reading publication membership
pg_dump: reading subscriptions
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving search_path =
pg_dump: saving database definition

It is working perfectly in version 10. Please help me out. It was useful for
me to restore a particular DB from all DB backup.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2019-07-04 07:46:09 Re: BUG #15893: pg_dump is not working like as postgres version 10
Previous Message Michael Paquier 2019-07-04 04:35:12 Re: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot