The following bug has been logged on the website:
Bug reference: 7684
Logged by: Timur Luchkin
Email address: timur.luchkin@gmail.com
PostgreSQL version: 9.2.1
Operating system: OpenSolaris
Description: =
Looks like pg_dumpall sorts 'create server FOREIGN DATA WRAPPER' options
(keys) as varchar and not as integer. =
Example from dumped sql (see "pX" option key):
CREATE SERVER can_master_cluster FOREIGN DATA WRAPPER plproxy OPTIONS (
connection_lifetime '1800',
p0 'dbname=3Ddatabase11 host=3Dxxx-11 port=3D9811',
p1 'dbname=3Ddatabase12 host=3Dxxx-12 port=3D9812',
p10 'dbname=3Ddatabase21 host=3Dxxx-21 port=3D9821',
p11 'dbname=3Ddatabase22 host=3Dxxx-22 port=3D9822',
p12 'dbname=3Ddatabase23 host=3Dxxx-23 port=3D9823',
p13 'dbname=3Ddatabase24 host=3Dxxx-24 port=3D9824',
p14 'dbname=3Ddatabase25 host=3Dxxx-25 port=3D9825',
p15 'dbname=3Ddatabase26 host=3Dxxx-26 port=3D9826',
p2 'dbname=3Ddatabase13 host=3Dxxx-13 port=3D9813',
p3 'dbname=3Ddatabase14 host=3Dxxx-14 port=3D9814',
p4 'dbname=3Ddatabase15 host=3Dxxx-15 port=3D9815',
p5 'dbname=3Ddatabase16 host=3Dxxx-16 port=3D9816',
p6 'dbname=3Ddatabase17 host=3Dxxx-17 port=3D9817',
p7 'dbname=3Ddatabase18 host=3Dxxx-18 port=3D9818',
p8 'dbname=3Ddatabase19 host=3Dxxx-19 port=3D9819',
p9 'dbname=3Ddatabase20 host=3Dxxx-20 port=3D9820'
);
which causes next error during the load:
ERROR: Pl/Proxy: partitions must be numbered consecutively
HINT: next valid partition number is 2
STATEMENT: CREATE SERVER can_master_cluster ...
Old 9.0 'pg_dumpall' doing job correct.