Backup and restore for Postgresql on KubernetesBackup and restoreIncremental Backup for PostgreSQL 8.3Outlook...
Is it acceptable for a professor to tell male students to not think that they are smarter than female students?
Why would the Red Woman birth a shadow if she worshipped the Lord of the Light?
How does a predictive coding aid in lossless compression?
Is there an expression that means doing something right before you will need it rather than doing it in case you might need it?
Expand and Contract
How do conventional missiles fly?
How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?
Size of subfigure fitting its content (tikzpicture)
Avoiding direct proof while writing proof by induction
ssTTsSTtRrriinInnnnNNNIiinngg
Little known, relatively unlikely, but scientifically plausible, apocalyptic (or near apocalyptic) events
Why no variance term in Bayesian logistic regression?
What is the difference between 仮定 and 想定?
How would I stat a creature to be immune to everything but the Magic Missile spell? (just for fun)
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
How could indestructible materials be used in power generation?
What is the most common color to indicate the input-field is disabled?
Ambiguity in the definition of entropy
Are there any examples of a variable being normally distributed that is *not* due to the Central Limit Theorem?
Why is this clock signal connected to a capacitor to gnd?
How seriously should I take size and weight limits of hand luggage?
Is it logically or scientifically possible to artificially send energy to the body?
Could the museum Saturn V's be refitted for one more flight?
Should I cover my bicycle overnight while bikepacking?
Backup and restore for Postgresql on Kubernetes
Backup and restoreIncremental Backup for PostgreSQL 8.3Outlook Email backup and restoreHow to backup Servers to an SSH-Host with low traffic and access to versions and encryption?Windows 7 Backup and Restore. How does it workUSB stick backup/restore tool for Mac, Windows and LinuxBackup and restore Osmo-pimIs there a way to let PostgreSQL restore but not create a new timelinehow to create backup form PostgreSQL without console postgresql?Backup and Restore Failure
I have deployed Postgresql as stateful set in kubernetes with 3 replicas and SSL.
I have also configured backup on NFS and temp backup on cinder.
For tar I am able to restore the backup from restore job for tar present on NFS.
Now I am trying Point In Time Recovery where I have mentioned the timestamp and location of WAL Archive.
When I try to run restore job mentioning timestamp for PITR and and wal file locations K8s try to create a container and try to attach volume which is already attached to Postgresql master.
When I tried to scale replicas of Postgresql to 0 and try to run the job, job was successful but PITR was not done also my master went into readonly mode where I am able to read but not write anything to DB.
Please suggest where I am missing or any sequence is wrong.
backup restore postgresql
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have deployed Postgresql as stateful set in kubernetes with 3 replicas and SSL.
I have also configured backup on NFS and temp backup on cinder.
For tar I am able to restore the backup from restore job for tar present on NFS.
Now I am trying Point In Time Recovery where I have mentioned the timestamp and location of WAL Archive.
When I try to run restore job mentioning timestamp for PITR and and wal file locations K8s try to create a container and try to attach volume which is already attached to Postgresql master.
When I tried to scale replicas of Postgresql to 0 and try to run the job, job was successful but PITR was not done also my master went into readonly mode where I am able to read but not write anything to DB.
Please suggest where I am missing or any sequence is wrong.
backup restore postgresql
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have deployed Postgresql as stateful set in kubernetes with 3 replicas and SSL.
I have also configured backup on NFS and temp backup on cinder.
For tar I am able to restore the backup from restore job for tar present on NFS.
Now I am trying Point In Time Recovery where I have mentioned the timestamp and location of WAL Archive.
When I try to run restore job mentioning timestamp for PITR and and wal file locations K8s try to create a container and try to attach volume which is already attached to Postgresql master.
When I tried to scale replicas of Postgresql to 0 and try to run the job, job was successful but PITR was not done also my master went into readonly mode where I am able to read but not write anything to DB.
Please suggest where I am missing or any sequence is wrong.
backup restore postgresql
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have deployed Postgresql as stateful set in kubernetes with 3 replicas and SSL.
I have also configured backup on NFS and temp backup on cinder.
For tar I am able to restore the backup from restore job for tar present on NFS.
Now I am trying Point In Time Recovery where I have mentioned the timestamp and location of WAL Archive.
When I try to run restore job mentioning timestamp for PITR and and wal file locations K8s try to create a container and try to attach volume which is already attached to Postgresql master.
When I tried to scale replicas of Postgresql to 0 and try to run the job, job was successful but PITR was not done also my master went into readonly mode where I am able to read but not write anything to DB.
Please suggest where I am missing or any sequence is wrong.
backup restore postgresql
backup restore postgresql
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
asked 8 mins ago
Gourav SwarnkarGourav Swarnkar
1
1
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Gourav Swarnkar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Gourav Swarnkar is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1421216%2fbackup-and-restore-for-postgresql-on-kubernetes%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
Gourav Swarnkar is a new contributor. Be nice, and check out our Code of Conduct.
Gourav Swarnkar is a new contributor. Be nice, and check out our Code of Conduct.
Gourav Swarnkar is a new contributor. Be nice, and check out our Code of Conduct.
Gourav Swarnkar is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1421216%2fbackup-and-restore-for-postgresql-on-kubernetes%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
