[%
USE Whostmgr;

IF locale.get_html_dir_attr() == 'rtl';
SET rtl_bootstrap = Whostmgr.find_file_url('/3rdparty/bootstrap-rtl/optimized/dist/css/bootstrap-rtl.min.css');
END;

SET styleSheets = [
    rtl_bootstrap,
];

WRAPPER 'master_templates/master.tmpl'
    header = locale.maketext("PostgreSQL Upgrade"),
    stylesheets = styleSheets,
    theme='bootstrap',
    breadcrumbdata= {
        previous = [
            {
                name = "Home",
                url  = "/scripts/command?PFILE=main",
            },
            {
                name = "Plugins",
                url  = "/scripts/command?PFILE=Plugins",
            },
        ],
        name = 'PostgreSQL Upgrade',
        url = '/cgi/troglodyne/pgupgrade.cgi',
        help_url = 'https://troglodyne.net/better-postgres-for-cpanel',
    },
    icon='/addon_plugins/troglophant.png';
%]
<h3>Brought to you by <a href="https://troglodyne.net">Troglodyne</a></h3>
<p>
PostgreSQL is <em>the best</em> relational database management system you can conceive of, even on cPanel systems.
This interface allows you to upgrade your PostgreSQL server to a newer version.
Yum and cPanel will automagically upgrade PostgreSQL installations to newer point releases (the third digit in the version string),
as these upgrades involve little risk to your users’ data.
Upgrades to new major releases (the first two digits in the version string) are more involved because there is a substantial risk of data loss.
This interface at least attempts to take care of those issues for you.
</p>
<div class="callout callout-info">
    <p>Although in-place upgrades are generally safe, you should always perform a full database backup before you begin the upgrade process.</p>
    <p>
        Please note that downgrades to previous versions are not allowed by this software. After you upgrade your system to a newer version,
        any consequences related to switching back are your responsibility alone.
    </p>
</div>
<h3>Current Version</h3>
<div id="psqlVersion">Loading... <span class="fa fa-spin fa-spinner"></span></div>
<h3 id="upgradeTitle">Select a Version</h3>
<div id="upgradeDiv">
    <form id="upgradeForm" name="upgradeForm">
        <table class="table table-striped">
            <thead>
                <tr>
                    <th>Version</th>
                    <th>Features</th>
                    <th>Release Date</th>
                    <th>End of Life</th>
                </th>
            </thead>
            <tbody>
                <tr>
                    <td colspan=5 id="loadingCell">
                        Loading... <span class="fa fa-spin fa-spinner"></span>
                    </td>
                </tr>
            </tbody>
        </table>
    </form>
    <pre style="display: none;" id="upgradeWell" class="well">
    </pre>
</div>
<button id="submit" class="btn btn-success" title="Please select a version above to continue" onclick="window.doUpgrade();">Continue</button>
<br><br>
<script type="text/javascript" src="js/pgupgrade.js"></script>
<style>
    #upgradeWell {
        height: 42rem;
    }
</style>
[% END %]