| 760 | } |
| 761 | |
| 762 | static void |
| 763 | reindex_all_databases(ConnParams *cparams, |
| 764 | const char *progname, bool echo, bool quiet, bool verbose, |
| 765 | bool concurrently, int concurrentCons, |
| 766 | const char *tablespace) |
| 767 | { |
| 768 | PGconn *conn; |
| 769 | PGresult *result; |
| 770 | int i; |
| 771 | |
| 772 | conn = connectMaintenanceDatabase(cparams, progname, echo); |
| 773 | result = executeQuery(conn, "SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;", echo); |
| 774 | PQfinish(conn); |
| 775 | |
| 776 | for (i = 0; i < PQntuples(result); i++) |
| 777 | { |
| 778 | char *dbname = PQgetvalue(result, i, 0); |
| 779 | |
| 780 | if (!quiet) |
| 781 | { |
| 782 | printf(_("%s: reindexing database \"%s\"\n"), progname, dbname); |
| 783 | fflush(stdout); |
| 784 | } |
| 785 | |
| 786 | cparams->override_dbname = dbname; |
| 787 | |
| 788 | reindex_one_database(cparams, REINDEX_DATABASE, NULL, |
| 789 | progname, echo, verbose, concurrently, |
| 790 | concurrentCons, tablespace); |
| 791 | } |
| 792 | |
| 793 | PQclear(result); |
| 794 | } |
| 795 | |
| 796 | static void |
| 797 | help(const char *progname) |
no test coverage detected