version.c File Reference

#include "postgres_fe.h"
#include "fe_utils/string_utils.h"
#include "pg_upgrade.h"

Include dependency graph for version.c:

Go to the source code of this file.

Functions
bool	protocol_negotiation_supported (const ClusterInfo *cluster)
static void	process_extension_updates (DbInfo *dbinfo, PGresult *res, void *arg)
void	report_extension_updates (ClusterInfo *cluster)

Function Documentation

process_extension_updates()

static void process_extension_updates ( DbInfo *  dbinfo, PGresult *  res, void *  arg  )

static

Definition at line 39 of file version.c.

{
    int         ntups = PQntuples(res);
    int         i_name = PQfnumber(res, "name");
    UpgradeTaskReport *report = (UpgradeTaskReport *) arg;
    PQExpBufferData connectbuf;
 
    if (ntups == 0)
        return;
 
    if (report->file == NULL &&
        (report->file = fopen_priv(report->path, "w")) == NULL)
        pg_fatal("could not open file \"%s\": %m", report->path);
 
    initPQExpBuffer(&connectbuf);
    appendPsqlMetaConnect(&connectbuf, dbinfo->db_name);
    fputs(connectbuf.data, report->file);
    termPQExpBuffer(&connectbuf);
 
    for (int rowno = 0; rowno < ntups; rowno++)
        fprintf(report->file, "ALTER EXTENSION %s UPDATE;\n",
                quote_identifier(PQgetvalue(res, rowno, i_name)));
}

References appendPsqlMetaConnect(), arg, DbInfo::db_name, fb(), UpgradeTaskReport::file, fopen_priv, fprintf, initPQExpBuffer(), UpgradeTaskReport::path, pg_fatal, PQfnumber(), PQgetvalue, PQntuples, quote_identifier(), and termPQExpBuffer().

Referenced by report_extension_updates().

protocol_negotiation_supported()

bool protocol_negotiation_supported

(

const ClusterInfo *

cluster

)

Definition at line 20 of file version.c.

{
    /*
     * The February 2018 patch release (9.3.21, 9.4.16, 9.5.11, 9.6.7, and
     * 10.2) added support for NegotiateProtocolVersion. But ClusterInfo only
     * has information about the major version number. To ensure we can still
     * upgrade older unpatched servers, just assume anything prior to PG11
     * can't negotiate. It's not possible for those servers to make use of
     * newer protocols anyway, so nothing is lost.
     */
    return (GET_MAJOR_VERSION(cluster->major_version) >= 1100);
}

References fb(), and GET_MAJOR_VERSION.

Referenced by generate_old_dump(), get_db_conn(), and start_conn().

report_extension_updates()

void report_extension_updates

(

ClusterInfo *

cluster

)

Definition at line 68 of file version.c.

{
    UpgradeTaskReport report;
    UpgradeTask *task = upgrade_task_create();
    const char *query = "SELECT name "
        "FROM pg_available_extensions "
        "WHERE installed_version != default_version";
 
    prep_status("Checking for extension updates");
 
    report.file = NULL;
    strcpy(report.path, "update_extensions.sql");
 
    upgrade_task_add_step(task, query, process_extension_updates,
                          true, &report);
 
    upgrade_task_run(task, cluster);
    upgrade_task_free(task);
 
    if (report.file)
    {
        fclose(report.file);
        report_status(PG_REPORT, "notice");
        pg_log(PG_REPORT, "\n"
               "Your installation contains extensions that should be updated\n"
               "with the ALTER EXTENSION command.  The file\n"
               "    %s\n"
               "when executed by psql by the database superuser will update\n"
               "these extensions.",
               report.path);
    }
    else
        check_ok();
}

References check_ok(), fb(), UpgradeTaskReport::file, UpgradeTaskReport::path, pg_log(), PG_REPORT, prep_status(), process_extension_updates(), report_status(), upgrade_task_add_step(), upgrade_task_create(), upgrade_task_free(), and upgrade_task_run().

Referenced by issue_warnings_and_set_wal_level().