Streaming replication in PostgreSQL 9.4
We have recently setup streaming replication in our Postgres server (t01, t02).
t01 is master and t02 is the slave. I want to understand the below two issues:
Recently our
/vardirectory of t01 server got full and app team was not able to access the application. My understanding was if t01/varwas full, the connection should be made to t02 and application should start using that as t02/varwas not full.If we shutdown t01 server, will my application automatically use the t02 databases, Streaming replication will provide HA in this case or not?
postgresql database-replication postgresql-9.4 failover
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
add a comment |
We have recently setup streaming replication in our Postgres server (t01, t02).
t01 is master and t02 is the slave. I want to understand the below two issues:
Recently our
/vardirectory of t01 server got full and app team was not able to access the application. My understanding was if t01/varwas full, the connection should be made to t02 and application should start using that as t02/varwas not full.If we shutdown t01 server, will my application automatically use the t02 databases, Streaming replication will provide HA in this case or not?
postgresql database-replication postgresql-9.4 failover
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
This question is an off-topic on SO. Ask it on dba.stackexchange.com
– Roman Konoval
Nov 28 '18 at 15:11
add a comment |
We have recently setup streaming replication in our Postgres server (t01, t02).
t01 is master and t02 is the slave. I want to understand the below two issues:
Recently our
/vardirectory of t01 server got full and app team was not able to access the application. My understanding was if t01/varwas full, the connection should be made to t02 and application should start using that as t02/varwas not full.If we shutdown t01 server, will my application automatically use the t02 databases, Streaming replication will provide HA in this case or not?
postgresql database-replication postgresql-9.4 failover
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
We have recently setup streaming replication in our Postgres server (t01, t02).
t01 is master and t02 is the slave. I want to understand the below two issues:
Recently our
/vardirectory of t01 server got full and app team was not able to access the application. My understanding was if t01/varwas full, the connection should be made to t02 and application should start using that as t02/varwas not full.If we shutdown t01 server, will my application automatically use the t02 databases, Streaming replication will provide HA in this case or not?
postgresql database-replication postgresql-9.4 failover
postgresql database-replication postgresql-9.4 failover
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
edited Nov 28 '18 at 15:27
Laurenz Albe
51.1k103050
51.1k103050
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
asked Nov 28 '18 at 15:08
MpathakMpathak
19110
19110
This question is an off-topic on SO. Ask it on dba.stackexchange.com
– Roman Konoval
Nov 28 '18 at 15:11
add a comment |
This question is an off-topic on SO. Ask it on dba.stackexchange.com
– Roman Konoval
Nov 28 '18 at 15:11
This question is an off-topic on SO. Ask it on dba.stackexchange.com
– Roman Konoval
Nov 28 '18 at 15:11
This question is an off-topic on SO. Ask it on dba.stackexchange.com
– Roman Konoval
Nov 28 '18 at 15:11
add a comment |
1 Answer
1
active
oldest
votes
No, PostgreSQL won't failover to the standby. Configuring failover properly is a hard problem, and you need specialized cluster software like Patroni to handle that.
As it is, you will have to fail over manually by running pg_ctl promote on the standby to do it.
You will also have to configure your clients to use the new server. To avoid that, you could use a virtual IP address that you can move to the standby, or you have to setup the clients to try both servers.
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
add a comment |
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%2f53522496%2fstreaming-replication-in-postgresql-9-4%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
No, PostgreSQL won't failover to the standby. Configuring failover properly is a hard problem, and you need specialized cluster software like Patroni to handle that.
As it is, you will have to fail over manually by running pg_ctl promote on the standby to do it.
You will also have to configure your clients to use the new server. To avoid that, you could use a virtual IP address that you can move to the standby, or you have to setup the clients to try both servers.
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
add a comment |
No, PostgreSQL won't failover to the standby. Configuring failover properly is a hard problem, and you need specialized cluster software like Patroni to handle that.
As it is, you will have to fail over manually by running pg_ctl promote on the standby to do it.
You will also have to configure your clients to use the new server. To avoid that, you could use a virtual IP address that you can move to the standby, or you have to setup the clients to try both servers.
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
add a comment |
No, PostgreSQL won't failover to the standby. Configuring failover properly is a hard problem, and you need specialized cluster software like Patroni to handle that.
As it is, you will have to fail over manually by running pg_ctl promote on the standby to do it.
You will also have to configure your clients to use the new server. To avoid that, you could use a virtual IP address that you can move to the standby, or you have to setup the clients to try both servers.
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
No, PostgreSQL won't failover to the standby. Configuring failover properly is a hard problem, and you need specialized cluster software like Patroni to handle that.
As it is, you will have to fail over manually by running pg_ctl promote on the standby to do it.
You will also have to configure your clients to use the new server. To avoid that, you could use a virtual IP address that you can move to the standby, or you have to setup the clients to try both servers.
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
answered Nov 28 '18 at 15:25
Laurenz AlbeLaurenz Albe
51.1k103050
51.1k103050
add a comment |
add a comment |
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%2f53522496%2fstreaming-replication-in-postgresql-9-4%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
This question is an off-topic on SO. Ask it on dba.stackexchange.com
– Roman Konoval
Nov 28 '18 at 15:11