Sfrgttk

Purpose of creating non root user

Do you waste sorcery points if you try to apply metamagic to a spell from a scroll but fail to cast it?

What should be the ideal length of sentences in a blog post for ease of reading?

Has the laser at Magurele, Romania reached a tenth of the Sun's power?

When and why was runway 07/25 at Kai Tak removed?

Overlapping circles covering polygon

Limit max CPU usage SQL SERVER with WSRM

I'm just a whisper. Who am I?

Why is the principal energy of an electron lower for excited electrons in a higher energy state?

Why is the sun approximated as a black body at ~ 5800 K?

Should I warn a new PhD Student?

Unable to disable Microsoft Store in domain environment

Quoting Keynes in a lecture

Why didn’t Eve recognize the little cockroach as a living organism?

Would a primitive species be able to learn English from reading books alone?

Do I have to know the General Relativity theory to understand the concept of inertial frame?

PTIJ: does fasting on Ta'anis Esther give us reward as if we celebrated 2 Purims? (similar to Yom Kippur)

Can I say "fingers" when referring to toes?

Typing CO_2 easily

Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?

How to leave product feedback on macOS?

The Digit Triangles

What does the word 'upstream' mean in the context?

What is the meaning of "You've never met a graph you didn't like?"

Streaming replication version between different minor versions

Does PostgreSQL 9.1 Streaming Replication catch up after a lag without WAL archiving?How does Postgres 9.2's streaming replication handle schema changes, and initial table setup?Streaming Replication Log is puzzling meData Corruption on base backups created with wal-e?Design for active/passive Master-Master mysql SetupDoes PostgreSQL take time to start streaming replication after restart master?Replication compatibility between minor MySQL versionsPostgreSQL: Step by step procedure for switchover between primary and secondary in PG asynchronous streaming replicationStreaming replication in postgres questionStreaming replication archive folder taking all space- Postgresql- 9.4

1

0

I want to know few details about streaming replication.

I want to setup streaming replication between version 9.4.4 and 9.4.20 ?

I have the master server in centos6.6 with postgres version 9.4.4 which is a physical machine and we have created a new virtual machine centos7.5 and postgres version is 9.4.20. I want to know if this will cause any problem due to version mismatch.

Also, How can I download specific minor version 9.4.4 of postgres ? I checked some official documentation and by yum I am able to see only 9.4 which is actually 9.4.20 after I installed.

postgresql replication postgresql-9.4

share|improve this question

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

asked Dec 18 '18 at 16:50

MpathakMpathak

134

bumped to the homepage by Community♦ 7 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Why not upgrade the master from 9.4.4 to 9.4.20 first? And then setup replication?
  
  – ypercubeᵀᴹ
  Dec 18 '18 at 16:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, we can't do the upgrade as of now. Other option comes out to be installing 9.4.4. version in slave server. Can you suggest/help with that ? Also, if we somehow managed to accept the app team for upgrade to 9.4.20, how we can do that? I checked regarding "pg_upgrade" but it is used for major releases not minor releases. Thanks for your help
  
  – Mpathak
  Dec 18 '18 at 17:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The minor upgrade is usually much easier. Stop the database, replace binaries, restart (and even better take a backup first, just in case).
  
  – ypercubeᵀᴹ
  Dec 18 '18 at 17:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, Any suggestion on how to get 9.4.4 rpm of postgres ?
  
  – Mpathak
  Dec 18 '18 at 18:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I don't know. I mainly work with Debian/Ubuntu.
  
  – ypercubeᵀᴹ
  Dec 19 '18 at 20:47
  

  
  
  
  

 | 
show 1 more comment

1

0

I want to know few details about streaming replication.

I want to setup streaming replication between version 9.4.4 and 9.4.20 ?

I have the master server in centos6.6 with postgres version 9.4.4 which is a physical machine and we have created a new virtual machine centos7.5 and postgres version is 9.4.20. I want to know if this will cause any problem due to version mismatch.

Also, How can I download specific minor version 9.4.4 of postgres ? I checked some official documentation and by yum I am able to see only 9.4 which is actually 9.4.20 after I installed.

postgresql replication postgresql-9.4

share|improve this question

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

asked Dec 18 '18 at 16:50

MpathakMpathak

134

bumped to the homepage by Community♦ 7 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Why not upgrade the master from 9.4.4 to 9.4.20 first? And then setup replication?
  
  – ypercubeᵀᴹ
  Dec 18 '18 at 16:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, we can't do the upgrade as of now. Other option comes out to be installing 9.4.4. version in slave server. Can you suggest/help with that ? Also, if we somehow managed to accept the app team for upgrade to 9.4.20, how we can do that? I checked regarding "pg_upgrade" but it is used for major releases not minor releases. Thanks for your help
  
  – Mpathak
  Dec 18 '18 at 17:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The minor upgrade is usually much easier. Stop the database, replace binaries, restart (and even better take a backup first, just in case).
  
  – ypercubeᵀᴹ
  Dec 18 '18 at 17:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, Any suggestion on how to get 9.4.4 rpm of postgres ?
  
  – Mpathak
  Dec 18 '18 at 18:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I don't know. I mainly work with Debian/Ubuntu.
  
  – ypercubeᵀᴹ
  Dec 19 '18 at 20:47
  

  
  
  
  

 | 
show 1 more comment

I want to know few details about streaming replication.

I want to setup streaming replication between version 9.4.4 and 9.4.20 ?

I have the master server in centos6.6 with postgres version 9.4.4 which is a physical machine and we have created a new virtual machine centos7.5 and postgres version is 9.4.20. I want to know if this will cause any problem due to version mismatch.

Also, How can I download specific minor version 9.4.4 of postgres ? I checked some official documentation and by yum I am able to see only 9.4 which is actually 9.4.20 after I installed.

postgresql replication postgresql-9.4

share|improve this question

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

asked Dec 18 '18 at 16:50

MpathakMpathak

134

share|improve this question

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

asked Dec 18 '18 at 16:50

MpathakMpathak

134

share|improve this question

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

asked Dec 18 '18 at 16:50

MpathakMpathak

134

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

edited Dec 19 '18 at 20:47

ypercubeᵀᴹ

77.7k11135218

asked Dec 18 '18 at 16:50

MpathakMpathak

134

asked Dec 18 '18 at 16:50

MpathakMpathak

134

1 Answer
1

active

oldest

votes

0

AFAIK it will work and documentation says, it should work.

In general, log shipping between servers running different major
PostgreSQL release levels is not possible. It is the policy of the
PostgreSQL Global Development Group not to make changes to disk
formats during minor release upgrades, so it is likely that running
different minor release levels on primary and standby servers will
work successfully. However, no formal support for that is offered and
you are advised to keep primary and standby servers at the same
release level as much as possible. When updating to a new minor
release, the safest policy is to update the standby servers first — a
new minor release is more likely to be able to read WAL files from a
previous minor release than vice versa.

https://www.postgresql.org/docs/9.4/warm-standby.html

For upgrade process

If you installed PostgreSQL via yum, yum update postgresql* should work. If you need rpms here is the PostgreSQL download link;

http://download.postgresql.org/pub/repos/yum/9.4/redhat/

share|improve this answer

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});


}
});

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f225292%2fstreaming-replication-version-between-different-minor-versions%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

AFAIK it will work and documentation says, it should work.

In general, log shipping between servers running different major
PostgreSQL release levels is not possible. It is the policy of the
PostgreSQL Global Development Group not to make changes to disk
formats during minor release upgrades, so it is likely that running
different minor release levels on primary and standby servers will
work successfully. However, no formal support for that is offered and
you are advised to keep primary and standby servers at the same
release level as much as possible. When updating to a new minor
release, the safest policy is to update the standby servers first — a
new minor release is more likely to be able to read WAL files from a
previous minor release than vice versa.

https://www.postgresql.org/docs/9.4/warm-standby.html

For upgrade process

If you installed PostgreSQL via yum, yum update postgresql* should work. If you need rpms here is the PostgreSQL download link;

http://download.postgresql.org/pub/repos/yum/9.4/redhat/

share|improve this answer

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639

add a comment | 

0

AFAIK it will work and documentation says, it should work.

In general, log shipping between servers running different major
PostgreSQL release levels is not possible. It is the policy of the
PostgreSQL Global Development Group not to make changes to disk
formats during minor release upgrades, so it is likely that running
different minor release levels on primary and standby servers will
work successfully. However, no formal support for that is offered and
you are advised to keep primary and standby servers at the same
release level as much as possible. When updating to a new minor
release, the safest policy is to update the standby servers first — a
new minor release is more likely to be able to read WAL files from a
previous minor release than vice versa.

https://www.postgresql.org/docs/9.4/warm-standby.html

For upgrade process

If you installed PostgreSQL via yum, yum update postgresql* should work. If you need rpms here is the PostgreSQL download link;

http://download.postgresql.org/pub/repos/yum/9.4/redhat/

share|improve this answer

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639

add a comment | 

AFAIK it will work and documentation says, it should work.

In general, log shipping between servers running different major
PostgreSQL release levels is not possible. It is the policy of the
PostgreSQL Global Development Group not to make changes to disk
formats during minor release upgrades, so it is likely that running
different minor release levels on primary and standby servers will
work successfully. However, no formal support for that is offered and
you are advised to keep primary and standby servers at the same
release level as much as possible. When updating to a new minor
release, the safest policy is to update the standby servers first — a
new minor release is more likely to be able to read WAL files from a
previous minor release than vice versa.

https://www.postgresql.org/docs/9.4/warm-standby.html

For upgrade process

If you installed PostgreSQL via yum, yum update postgresql* should work. If you need rpms here is the PostgreSQL download link;

http://download.postgresql.org/pub/repos/yum/9.4/redhat/

share|improve this answer

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639

share|improve this answer

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639

answered Dec 20 '18 at 13:36

Yavuz SelimYavuz Selim

639