Is it possible to upgrade PostgreSQL 9.2 directlly to Postgres 11.1 over CentOs 7 + cPanel?
I need PostgreSQL 11.1, but my CentOs 7 + cPanel shows:
[root@hwsrv-359572 csf]# postgres --version;postmaster --version;
postgres (PostgreSQL) 9.2.24
postgres (PostgreSQL) 9.2.24
[root@hwsrv-359572 csf]#
I can UPGRADE from 9.2 to 11.1?
Are the differences between 9.2 and 11.1 very, very big and is it required to install PostgreSQL 11.1 completely?
Maybe some links symbolics is sufficient?
by example 9.2 use:
/var/lib/pgsql/data
but from version 10.x PgSQL use:
/var/lib/pgsql/version/data
is very hard/impossible
do upgrade from 9.2 to 11.1
and then no lost the GUI of cPanel + PhpPgAdmin?
is best do a installation fresh of Postgres 11.1?
when I do this,
cPanel does not detect Postgres and more:
GUI PhpPgAdmin interface is lost in cPanel.
I believe the best option is to upgrade,
because cPanel includes only Postgres 9.2
However, I can't find how to upgrade from 9.2 to 11.1
postgresql
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
asked Nov 13 '18 at 14:09
VyRVyR
11
add a comment |
I need PostgreSQL 11.1, but my CentOs 7 + cPanel shows:
[root@hwsrv-359572 csf]# postgres --version;postmaster --version;
postgres (PostgreSQL) 9.2.24
postgres (PostgreSQL) 9.2.24
[root@hwsrv-359572 csf]#
I can UPGRADE from 9.2 to 11.1?
Are the differences between 9.2 and 11.1 very, very big and is it required to install PostgreSQL 11.1 completely?
Maybe some links symbolics is sufficient?
by example 9.2 use:
/var/lib/pgsql/data
but from version 10.x PgSQL use:
/var/lib/pgsql/version/data
is very hard/impossible
do upgrade from 9.2 to 11.1
and then no lost the GUI of cPanel + PhpPgAdmin?
is best do a installation fresh of Postgres 11.1?
when I do this,
cPanel does not detect Postgres and more:
GUI PhpPgAdmin interface is lost in cPanel.
I believe the best option is to upgrade,
because cPanel includes only Postgres 9.2
However, I can't find how to upgrade from 9.2 to 11.1
postgresql
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
asked Nov 13 '18 at 14:09
VyRVyR
11
No, you need to do a complete install of Postgres 11, then dump and reload the old database into the new installation or usepg_upgrade
– a_horse_with_no_name
Nov 13 '18 at 14:18
Ouch!, upgrade no is possible now is clear to me, thanks. Maybe can you sayme how I can integrate PgSQL11.1 with cPanel? I install but forever in any point some is breaked. Thanks
– VyR
Nov 13 '18 at 14:21
As I said, you can usepg_upgradeto migrate the old data directory to the new version.
– a_horse_with_no_name
Nov 13 '18 at 14:22
with "pg_upgrade" I can read OLD data in NEW version, but some idea about how I can use the GUI (cPanel + PhpPgAdmin) with PostgreSQL 11.1 ?
– VyR
Nov 14 '18 at 4:21
add a comment |
I need PostgreSQL 11.1, but my CentOs 7 + cPanel shows:
[root@hwsrv-359572 csf]# postgres --version;postmaster --version;
postgres (PostgreSQL) 9.2.24
postgres (PostgreSQL) 9.2.24
[root@hwsrv-359572 csf]#
I can UPGRADE from 9.2 to 11.1?
Are the differences between 9.2 and 11.1 very, very big and is it required to install PostgreSQL 11.1 completely?
Maybe some links symbolics is sufficient?
by example 9.2 use:
/var/lib/pgsql/data
but from version 10.x PgSQL use:
/var/lib/pgsql/version/data
is very hard/impossible
do upgrade from 9.2 to 11.1
and then no lost the GUI of cPanel + PhpPgAdmin?
is best do a installation fresh of Postgres 11.1?
when I do this,
cPanel does not detect Postgres and more:
GUI PhpPgAdmin interface is lost in cPanel.
I believe the best option is to upgrade,
because cPanel includes only Postgres 9.2
However, I can't find how to upgrade from 9.2 to 11.1
postgresql
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
asked Nov 13 '18 at 14:09
VyRVyR
11
I need PostgreSQL 11.1, but my CentOs 7 + cPanel shows:
[root@hwsrv-359572 csf]# postgres --version;postmaster --version;
postgres (PostgreSQL) 9.2.24
postgres (PostgreSQL) 9.2.24
[root@hwsrv-359572 csf]#
I can UPGRADE from 9.2 to 11.1?
Are the differences between 9.2 and 11.1 very, very big and is it required to install PostgreSQL 11.1 completely?
Maybe some links symbolics is sufficient?
by example 9.2 use:
/var/lib/pgsql/data
but from version 10.x PgSQL use:
/var/lib/pgsql/version/data
is very hard/impossible
do upgrade from 9.2 to 11.1
and then no lost the GUI of cPanel + PhpPgAdmin?
is best do a installation fresh of Postgres 11.1?
when I do this,
cPanel does not detect Postgres and more:
GUI PhpPgAdmin interface is lost in cPanel.
I believe the best option is to upgrade,
because cPanel includes only Postgres 9.2
However, I can't find how to upgrade from 9.2 to 11.1
postgresql
postgresql
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
asked Nov 13 '18 at 14:09
VyRVyR
11
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
asked Nov 13 '18 at 14:09
VyRVyR
11
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
edited Nov 13 '18 at 14:18
a_horse_with_no_name
293k46448541
293k46448541
asked Nov 13 '18 at 14:09
VyRVyR
11
asked Nov 13 '18 at 14:09
VyRVyR
11
asked Nov 13 '18 at 14:09
VyRVyR
11
11
No, you need to do a complete install of Postgres 11, then dump and reload the old database into the new installation or usepg_upgrade
– a_horse_with_no_name
Nov 13 '18 at 14:18
Ouch!, upgrade no is possible now is clear to me, thanks. Maybe can you sayme how I can integrate PgSQL11.1 with cPanel? I install but forever in any point some is breaked. Thanks
– VyR
Nov 13 '18 at 14:21
As I said, you can usepg_upgradeto migrate the old data directory to the new version.
– a_horse_with_no_name
Nov 13 '18 at 14:22
with "pg_upgrade" I can read OLD data in NEW version, but some idea about how I can use the GUI (cPanel + PhpPgAdmin) with PostgreSQL 11.1 ?
– VyR
Nov 14 '18 at 4:21
add a comment |
No, you need to do a complete install of Postgres 11, then dump and reload the old database into the new installation or usepg_upgrade
– a_horse_with_no_name
Nov 13 '18 at 14:18
Ouch!, upgrade no is possible now is clear to me, thanks. Maybe can you sayme how I can integrate PgSQL11.1 with cPanel? I install but forever in any point some is breaked. Thanks
– VyR
Nov 13 '18 at 14:21
As I said, you can usepg_upgradeto migrate the old data directory to the new version.
– a_horse_with_no_name
Nov 13 '18 at 14:22
with "pg_upgrade" I can read OLD data in NEW version, but some idea about how I can use the GUI (cPanel + PhpPgAdmin) with PostgreSQL 11.1 ?
– VyR
Nov 14 '18 at 4:21
No, you need to do a complete install of Postgres 11, then dump and reload the old database into the new installation or use
pg_upgrade– a_horse_with_no_name
Nov 13 '18 at 14:18
No, you need to do a complete install of Postgres 11, then dump and reload the old database into the new installation or use
pg_upgrade– a_horse_with_no_name
Nov 13 '18 at 14:18
Ouch!, upgrade no is possible now is clear to me, thanks. Maybe can you sayme how I can integrate PgSQL11.1 with cPanel? I install but forever in any point some is breaked. Thanks
– VyR
Nov 13 '18 at 14:21
Ouch!, upgrade no is possible now is clear to me, thanks. Maybe can you sayme how I can integrate PgSQL11.1 with cPanel? I install but forever in any point some is breaked. Thanks
– VyR
Nov 13 '18 at 14:21
As I said, you can use
pg_upgrade to migrate the old data directory to the new version.– a_horse_with_no_name
Nov 13 '18 at 14:22
As I said, you can use
pg_upgrade to migrate the old data directory to the new version.– a_horse_with_no_name
Nov 13 '18 at 14:22
with "pg_upgrade" I can read OLD data in NEW version, but some idea about how I can use the GUI (cPanel + PhpPgAdmin) with PostgreSQL 11.1 ?
– VyR
Nov 14 '18 at 4:21
with "pg_upgrade" I can read OLD data in NEW version, but some idea about how I can use the GUI (cPanel + PhpPgAdmin) with PostgreSQL 11.1 ?
– VyR
Nov 14 '18 at 4:21
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53282883%2fis-it-possible-to-upgrade-postgresql-9-2-directlly-to-postgres-11-1-over-centos%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53282883%2fis-it-possible-to-upgrade-postgresql-9-2-directlly-to-postgres-11-1-over-centos%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
No, you need to do a complete install of Postgres 11, then dump and reload the old database into the new installation or use
pg_upgrade– a_horse_with_no_name
Nov 13 '18 at 14:18
Ouch!, upgrade no is possible now is clear to me, thanks. Maybe can you sayme how I can integrate PgSQL11.1 with cPanel? I install but forever in any point some is breaked. Thanks
– VyR
Nov 13 '18 at 14:21
As I said, you can use
pg_upgradeto migrate the old data directory to the new version.– a_horse_with_no_name
Nov 13 '18 at 14:22
with "pg_upgrade" I can read OLD data in NEW version, but some idea about how I can use the GUI (cPanel + PhpPgAdmin) with PostgreSQL 11.1 ?
– VyR
Nov 14 '18 at 4:21