PG 11: Support PG utilities new options (RM #3503)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3503 Originally created by Khushboo Vashi at 2018-07-16 09:35:43 UTC.

• Add pg_dumpall option --encoding to control encoding
• Add pg_dump option --load-via-partition-root to force loading of data into the partition's root table, rather than the original partitions
• The new pg_dump, pg_dumpall, and pg_restore option is --no-comments.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-1 Originally created by Akshay Joshi at 2018-07-20 10:21:35 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-2 Originally created by Akshay Joshi at 2018-08-01 09:41:49 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	Ready	EDB Sprint 20

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-3 Originally created by Akshay Joshi at 2018-08-14 06:43:36 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	New	In Progress
Assigned To changed		Akshay Joshi

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-4 Originally created by Akshay Joshi at 2018-08-14 12:01:13 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 20	EDB Sprint 21

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-5 Originally created by Akshay Joshi at 2018-08-21 06:48:07 UTC.

Patch sent: https://www.postgresql.org/message-id/CANxoLDdKzwy7QLwpKPuj7FooTM+SJ=yrj+fxSeUYYrsTrPf60A@mail.gmail.com

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-6 Originally created by Akshay Joshi at 2018-08-22 06:54:19 UTC.

Applied in changeset commit:0ab1305ddf5ef51136110c202c2da3f0c52940e3.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	In Progress	In Testing
Done Ratio changed	0	90

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-7 Originally created by Fahar Abbas at 2018-09-04 14:24:17 UTC.

This is tested comprehensively on Windows 07 ultimate SP1 for 3.3 Community build with all mentioned optons of dump, dumpall and restore for PG-11

Redmine ticket header update:

Name	Old Value	New Value
Status changed	In Testing	Resolved
Done Ratio changed	90	100

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3503#note-8 Originally created by Dave Page at 2018-09-06 13:04:12 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Fixed Version changed		3.3

[dpage]

Issue closed on Redmine.