Running two PostgreSQL servers in same Ubuntu machine
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
We installed PostgreSQL 9.4 in two Ubuntu servers and now we need to configure Slave servers for these two servers. So in a third Ubuntu server we installed PostgreSQL 9.4 running on port 5432 and configured as slave server.
Now is it possible to install PostgreSQL 9.4 server on this server that runs on port 5433 so that we can configure second slave server on this machine itself.
Can anyone please help us on it.
14.04 postgresql
asked Jul 6 '15 at 4:29
GeoGeo
2124
add a comment |
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
We installed PostgreSQL 9.4 in two Ubuntu servers and now we need to configure Slave servers for these two servers. So in a third Ubuntu server we installed PostgreSQL 9.4 running on port 5432 and configured as slave server.
Now is it possible to install PostgreSQL 9.4 server on this server that runs on port 5433 so that we can configure second slave server on this machine itself.
Can anyone please help us on it.
14.04 postgresql
asked Jul 6 '15 at 4:29
GeoGeo
2124
add a comment |
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
We installed PostgreSQL 9.4 in two Ubuntu servers and now we need to configure Slave servers for these two servers. So in a third Ubuntu server we installed PostgreSQL 9.4 running on port 5432 and configured as slave server.
Now is it possible to install PostgreSQL 9.4 server on this server that runs on port 5433 so that we can configure second slave server on this machine itself.
Can anyone please help us on it.
14.04 postgresql
asked Jul 6 '15 at 4:29
GeoGeo
2124
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
We installed PostgreSQL 9.4 in two Ubuntu servers and now we need to configure Slave servers for these two servers. So in a third Ubuntu server we installed PostgreSQL 9.4 running on port 5432 and configured as slave server.
Now is it possible to install PostgreSQL 9.4 server on this server that runs on port 5433 so that we can configure second slave server on this machine itself.
Can anyone please help us on it.
14.04 postgresql
14.04 postgresql
asked Jul 6 '15 at 4:29
GeoGeo
2124
asked Jul 6 '15 at 4:29
GeoGeo
2124
asked Jul 6 '15 at 4:29
GeoGeo
2124
asked Jul 6 '15 at 4:29
GeoGeo
2124
asked Jul 6 '15 at 4:29
GeoGeo
2124
2124
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
Yes, that's why Ubuntu has pg_wrapper.
See https://help.ubuntu.com/community/PostgreSQL and the manual for pg_createcluster, pg_ctlcluster, etc.
Unfortunately there does not appear to be a wrapper for pg_basebackup. So you'll need to take a base backup manually if you want to run a replica. You can pg_createcluster, stop it, delete the data directory, and replace it with a base backup.
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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%2faskubuntu.com%2fquestions%2f644961%2frunning-two-postgresql-servers-in-same-ubuntu-machine%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
Yes, that's why Ubuntu has pg_wrapper.
See https://help.ubuntu.com/community/PostgreSQL and the manual for pg_createcluster, pg_ctlcluster, etc.
Unfortunately there does not appear to be a wrapper for pg_basebackup. So you'll need to take a base backup manually if you want to run a replica. You can pg_createcluster, stop it, delete the data directory, and replace it with a base backup.
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
add a comment |
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
Yes, that's why Ubuntu has pg_wrapper.
See https://help.ubuntu.com/community/PostgreSQL and the manual for pg_createcluster, pg_ctlcluster, etc.
Unfortunately there does not appear to be a wrapper for pg_basebackup. So you'll need to take a base backup manually if you want to run a replica. You can pg_createcluster, stop it, delete the data directory, and replace it with a base backup.
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
add a comment |
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
Yes, that's why Ubuntu has pg_wrapper.
See https://help.ubuntu.com/community/PostgreSQL and the manual for pg_createcluster, pg_ctlcluster, etc.
Unfortunately there does not appear to be a wrapper for pg_basebackup. So you'll need to take a base backup manually if you want to run a replica. You can pg_createcluster, stop it, delete the data directory, and replace it with a base backup.
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
Please let us know in an Ubuntu 14.04 Machine is it possible to run same PostgreSQL 9.4 Instances in same machine with different ports.
Yes, that's why Ubuntu has pg_wrapper.
See https://help.ubuntu.com/community/PostgreSQL and the manual for pg_createcluster, pg_ctlcluster, etc.
Unfortunately there does not appear to be a wrapper for pg_basebackup. So you'll need to take a base backup manually if you want to run a replica. You can pg_createcluster, stop it, delete the data directory, and replace it with a base backup.
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
answered Jul 6 '15 at 5:07
Craig RingerCraig Ringer
2,94411615
2,94411615
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- 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%2faskubuntu.com%2fquestions%2f644961%2frunning-two-postgresql-servers-in-same-ubuntu-machine%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
