pg_dump: Dump user mappings ordered by user name

petere · petere · commit a671d9409bfe · 2011-12-29T21:16:15.000+02:00
This is to get a deterministic dump order independent of the order in
which the user mappings were created.
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
@@ -11766,7 +11766,8 @@ dumpUserMappings(Archive *fout,
 					  "FROM pg_options_to_table(umoptions)"
 					  "), ', ') AS umoptions "
 					  "FROM pg_user_mappings "
-					  "WHERE srvid = '%u'",
+					  "WHERE srvid = '%u' "
+					  "ORDER BY usename",
 					  catalogId.oid);
 
 	res = PQexec(g_conn, query->data);
