Hello,
I have an issue with recovering my db from the pg_dump plain text file:
I have the following cluster in my db:
CREATE SERVER my_cluster FOREIGN DATA WRAPPER plproxy OPTIONS (
connection_lifetime '900',
p0 'host=localhost port=6432 dbname=my_db_01',
p1 'host=localhost port=6432 dbname=my_db_02',
p2 'host=localhost port=6432 dbname=my_db_03',
p3 'host=localhost port=6432 dbname=my_db_04',
p4 'host=localhost port=6432 dbname=my_db_05',
p5 'host=localhost port=6432 dbname=my_db_06',
p6 'host=localhost port=6432 dbname=my_db_07',
p7 'host=localhost port=6432 dbname=my_db_08',
p8 'host=localhost port=6432 dbname=my_db_09',
p9 'host=localhost port=6432 dbname=my_db_10',
p10 'host=localhost port=6432 dbname=my_db_11',
p11 'host=localhost port=6432 dbname=my_db_12',
p12 'host=localhost port=6432 dbname=my_db_13',
p13 'host=localhost port=6432 dbname=my_db_14',
p14 'host=localhost port=6432 dbname=my_db_15',
p15 'host=localhost port=6432 dbname=my_db_16'
);When I make a back-up of the schema of my db using pg_dump I see the following description of my FDW server in the dump file:
CREATE SERVER my_cluster FOREIGN DATA WRAPPER plproxy OPTIONS (
connection_lifetime '900',
p0 'host=localhost port=6432 dbname=my_db_01',
p1 'host=localhost port=6432 dbname=my_db_02',
p10 'host=localhost port=6432 dbname=my_db_11',
p11 'host=localhost port=6432 dbname=my_db_12',
p12 'host=localhost port=6432 dbname=my_db_13',
p13 'host=localhost port=6432 dbname=my_db_14',
p14 'host=localhost port=6432 dbname=my_db_15',
p15 'host=localhost port=6432 dbname=my_db_16',
p2 'host=localhost port=6432 dbname=my_db_03',
p3 'host=localhost port=6432 dbname=my_db_04',
p4 'host=localhost port=6432 dbname=my_db_05',
p5 'host=localhost port=6432 dbname=my_db_06',
p6 'host=localhost port=6432 dbname=my_db_07',
p7 'host=localhost port=6432 dbname=my_db_08',
p8 'host=localhost port=6432 dbname=my_db_09',
p9 'host=localhost port=6432 dbname=my_db_10'
);As you can see nodes are sorted in a different way and when I try to recover my db I get the following error:
ERROR: Pl/Proxy: partitions must be numbered consecutively
HINT: next valid partition number is 2