Stop connections to aurora postgres databaseHow to upgrade PostgreSQL minor releases without a...
How does residential electricity work?
Why Were Madagascar and New Zealand Discovered So Late?
Is exact Kanji stroke length important?
Efficiently merge handle parallel feature branches in SFDX
Can I Retrieve Email Addresses from BCC?
How can I replace every global instance of "x[2]" with "x_2"
voltage of sounds of mp3files
What's the purpose of "true" in bash "if sudo true; then"
Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?
Best way to store options for panels
Do I need a multiple entry visa for a trip UK -> Sweden -> UK?
What would happen if the UK refused to take part in EU Parliamentary elections?
Was Spock the First Vulcan in Starfleet?
Why "be dealt cards" rather than "be dealing cards"?
Ways to speed up user implemented RK4
Time travel short story where a man arrives in the late 19th century in a time machine and then sends the machine back into the past
Greatest common substring
Should my PhD thesis be submitted under my legal name?
How does it work when somebody invests in my business?
Valid Badminton Score?
Implement the Thanos sorting algorithm
Go Pregnant or Go Home
Why is delta-v is the most useful quantity for planning space travel?
How does a character multiclassing into warlock get a focus?
Stop connections to aurora postgres database
How to upgrade PostgreSQL minor releases without a dump/restore?Is Postgres sharding available on Aurora (AWS)Error log flooding with aborted connections (Aurora 2.03 - MySQL 5.7.12)migrating from a local PostgreSQL database to Amazon AuroraFinding Aurora functions (PostgreSQL)Seeing AWS PostgreSQL-on-Aurora snapshot sizes of 0 GB - is this normal for a db of ~800mb?Aurora MySQL 5.7 DDL statements hangs intermittentlyDowngrading from AWS Aurora MySQL 5.7 to AWS Aurora MySQL 5.6AWS Aurora Database CorruptionHow to change the Aurora MySQL instance role
I am working towards upgrading my Aurora Postgres database from 1.3 (pg 9.6) to 2.2 (10.6). And since there is no major upgrade supported, I am planning to take pg_dump and do restore on the latest version of the database. Since the database size is large, pg_dump is taking couple of hours to run and assume restore will take similar time. Until dump and restore happens, I do not want to any user to be able to connect to the database until the upgrade is complete? With no pg_hba.conf file what are my options to block user access? One option I could think of is to revoke connect from user on all the dbs, any other options?
postgresql aws-aurora
asked 4 mins ago
nmakbnmakb
1
New contributor
nmakb 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 am working towards upgrading my Aurora Postgres database from 1.3 (pg 9.6) to 2.2 (10.6). And since there is no major upgrade supported, I am planning to take pg_dump and do restore on the latest version of the database. Since the database size is large, pg_dump is taking couple of hours to run and assume restore will take similar time. Until dump and restore happens, I do not want to any user to be able to connect to the database until the upgrade is complete? With no pg_hba.conf file what are my options to block user access? One option I could think of is to revoke connect from user on all the dbs, any other options?
postgresql aws-aurora
asked 4 mins ago
nmakbnmakb
1
New contributor
nmakb 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 am working towards upgrading my Aurora Postgres database from 1.3 (pg 9.6) to 2.2 (10.6). And since there is no major upgrade supported, I am planning to take pg_dump and do restore on the latest version of the database. Since the database size is large, pg_dump is taking couple of hours to run and assume restore will take similar time. Until dump and restore happens, I do not want to any user to be able to connect to the database until the upgrade is complete? With no pg_hba.conf file what are my options to block user access? One option I could think of is to revoke connect from user on all the dbs, any other options?
postgresql aws-aurora
asked 4 mins ago
nmakbnmakb
1
New contributor
nmakb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am working towards upgrading my Aurora Postgres database from 1.3 (pg 9.6) to 2.2 (10.6). And since there is no major upgrade supported, I am planning to take pg_dump and do restore on the latest version of the database. Since the database size is large, pg_dump is taking couple of hours to run and assume restore will take similar time. Until dump and restore happens, I do not want to any user to be able to connect to the database until the upgrade is complete? With no pg_hba.conf file what are my options to block user access? One option I could think of is to revoke connect from user on all the dbs, any other options?
postgresql aws-aurora
postgresql aws-aurora
asked 4 mins ago
nmakbnmakb
1
New contributor
nmakb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 mins ago
nmakbnmakb
1
New contributor
nmakb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 mins ago
nmakbnmakb
1
New contributor
nmakb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 mins ago
nmakbnmakb
1
asked 4 mins ago
nmakbnmakb
1
1
New contributor
nmakb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
nmakb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
nmakb 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: "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
});
}
});
nmakb 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%2fdba.stackexchange.com%2fquestions%2f233198%2fstop-connections-to-aurora-postgres-database%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
nmakb is a new contributor. Be nice, and check out our Code of Conduct.
nmakb is a new contributor. Be nice, and check out our Code of Conduct.
nmakb is a new contributor. Be nice, and check out our Code of Conduct.
nmakb is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f233198%2fstop-connections-to-aurora-postgres-database%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
