mkabilov · GitHub

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

Read the original on github.com ↗