Source of Entry in Postgreswhitelist for allowed user queries in postgresHow do I detach all other users from...
Why does the Persian emissary display a string of crowned skulls?
Why the "ls" command is showing the permissions of files in a FAT32 partition?
How were servants to the Kaiser of Imperial Germany treated and where may I find more information on them
Why is the Sun approximated as a black body at ~ 5800 K?
Personal or impersonal in a technical resume
Language involving irrational number is not a CFL
How do I tell my boss that I'm quitting in 15 days (a colleague left this week)
Isometric embedding of a genus g surface
El Dorado Word Puzzle II: Videogame Edition
Proving an identity involving cross products and coplanar vectors
What is this high flying aircraft over Pennsylvania?
Did I make a mistake by ccing email to boss to others?
Has the laser at Magurele, Romania reached a tenth of the Sun's power?
What the heck is gets(stdin) on site coderbyte?
Deciphering cause of death?
How do I fix the group tension caused by my character stealing and possibly killing without provocation?
Can I run 125kHz RF circuit on a breadboard?
Why didn’t Eve recognize the little cockroach as a living organism?
Why do Radio Buttons not fill the entire outer circle?
Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?
How would you translate "more" for use as an interface button?
Does the Crossbow Expert feat's extra crossbow attack work with the reaction attack from a Hunter ranger's Giant Killer feature?
Mimic lecturing on blackboard, facing audience
Do I have to know the General Relativity theory to understand the concept of inertial frame?
Source of Entry in Postgres
whitelist for allowed user queries in postgresHow do I detach all other users from a postgres database?Moving a Postgres database from standalone local DB to Amazon RDSRestrict root user access to postgres userRestrict Postgres roles by IP address outside of the pg_hba.conf fileAdding new user in Postgrestrying to log into correct database without passwordpg_hba.conf entry queryHow to setup vault and Postgres in Google cloud to have the correct permissions?User / Client IP restrictions in Postgres running on RDSHow does PostGIS make its data types compatable with Postgres?
I want to make a small web app using Postgres as database.
Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
postgresql permissions connectivity authentication
edited 7 mins ago
Paul White♦
53.2k14284457
asked yesterday
Hasan A YousefHasan A Yousef
1083
New contributor
Hasan A Yousef 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 want to make a small web app using Postgres as database.
Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
postgresql permissions connectivity authentication
edited 7 mins ago
Paul White♦
53.2k14284457
asked yesterday
Hasan A YousefHasan A Yousef
1083
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
What exactly do you mean with "app"? If this is on a mobile device, you have no choice but to use something like SQLite. On a desktop, is the Postgres server to be installed on the same PC, or elsewhere? What should happen if there is some other app that also wants to install a Postgres server?
– CL.
20 hours ago
@CL. it is web app.
– Hasan A Yousef
17 hours ago
add a comment |
I want to make a small web app using Postgres as database.
Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
postgresql permissions connectivity authentication
edited 7 mins ago
Paul White♦
53.2k14284457
asked yesterday
Hasan A YousefHasan A Yousef
1083
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I want to make a small web app using Postgres as database.
Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
postgresql permissions connectivity authentication
postgresql permissions connectivity authentication
edited 7 mins ago
Paul White♦
53.2k14284457
asked yesterday
Hasan A YousefHasan A Yousef
1083
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 7 mins ago
Paul White♦
53.2k14284457
asked yesterday
Hasan A YousefHasan A Yousef
1083
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 7 mins ago
Paul White♦
53.2k14284457
edited 7 mins ago
Paul White♦
53.2k14284457
edited 7 mins ago
Paul White♦
53.2k14284457
53.2k14284457
asked yesterday
Hasan A YousefHasan A Yousef
1083
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Hasan A YousefHasan A Yousef
1083
asked yesterday
Hasan A YousefHasan A Yousef
1083
1083
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hasan A Yousef is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
What exactly do you mean with "app"? If this is on a mobile device, you have no choice but to use something like SQLite. On a desktop, is the Postgres server to be installed on the same PC, or elsewhere? What should happen if there is some other app that also wants to install a Postgres server?
– CL.
20 hours ago
@CL. it is web app.
– Hasan A Yousef
17 hours ago
add a comment |
What exactly do you mean with "app"? If this is on a mobile device, you have no choice but to use something like SQLite. On a desktop, is the Postgres server to be installed on the same PC, or elsewhere? What should happen if there is some other app that also wants to install a Postgres server?
– CL.
20 hours ago
@CL. it is web app.
– Hasan A Yousef
17 hours ago
What exactly do you mean with "app"? If this is on a mobile device, you have no choice but to use something like SQLite. On a desktop, is the Postgres server to be installed on the same PC, or elsewhere? What should happen if there is some other app that also wants to install a Postgres server?
– CL.
20 hours ago
What exactly do you mean with "app"? If this is on a mobile device, you have no choice but to use something like SQLite. On a desktop, is the Postgres server to be installed on the same PC, or elsewhere? What should happen if there is some other app that also wants to install a Postgres server?
– CL.
20 hours ago
@CL. it is web app.
– Hasan A Yousef
17 hours ago
@CL. it is web app.
– Hasan A Yousef
17 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Start by identifying the methods by which your database will determine if the SQL statement is coming from your app. - mustaccio
You can use a combination of firewall and pg_hba.conf rules to limit incoming connections. - dezso
Are all connections made to the database via a web server? If so, you can take advantage of whitelisting the app server, if connections are made directly from the clients, maybe creating a whitelist wrapper would do the trick instead? - John Eisbrener
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
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
});
}
});
Hasan A Yousef 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%2f232555%2fsource-of-entry-in-postgres%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
Start by identifying the methods by which your database will determine if the SQL statement is coming from your app. - mustaccio
You can use a combination of firewall and pg_hba.conf rules to limit incoming connections. - dezso
Are all connections made to the database via a web server? If so, you can take advantage of whitelisting the app server, if connections are made directly from the clients, maybe creating a whitelist wrapper would do the trick instead? - John Eisbrener
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
add a comment |
Start by identifying the methods by which your database will determine if the SQL statement is coming from your app. - mustaccio
You can use a combination of firewall and pg_hba.conf rules to limit incoming connections. - dezso
Are all connections made to the database via a web server? If so, you can take advantage of whitelisting the app server, if connections are made directly from the clients, maybe creating a whitelist wrapper would do the trick instead? - John Eisbrener
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
add a comment |
Start by identifying the methods by which your database will determine if the SQL statement is coming from your app. - mustaccio
You can use a combination of firewall and pg_hba.conf rules to limit incoming connections. - dezso
Are all connections made to the database via a web server? If so, you can take advantage of whitelisting the app server, if connections are made directly from the clients, maybe creating a whitelist wrapper would do the trick instead? - John Eisbrener
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
Start by identifying the methods by which your database will determine if the SQL statement is coming from your app. - mustaccio
You can use a combination of firewall and pg_hba.conf rules to limit incoming connections. - dezso
Are all connections made to the database via a web server? If so, you can take advantage of whitelisting the app server, if connections are made directly from the clients, maybe creating a whitelist wrapper would do the trick instead? - John Eisbrener
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
answered 9 mins ago
Comment ConverterComment Converter
1,3421325
1,3421325
add a comment |
add a comment |
Hasan A Yousef is a new contributor. Be nice, and check out our Code of Conduct.
Hasan A Yousef is a new contributor. Be nice, and check out our Code of Conduct.
Hasan A Yousef is a new contributor. Be nice, and check out our Code of Conduct.
Hasan A Yousef 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%2f232555%2fsource-of-entry-in-postgres%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
What exactly do you mean with "app"? If this is on a mobile device, you have no choice but to use something like SQLite. On a desktop, is the Postgres server to be installed on the same PC, or elsewhere? What should happen if there is some other app that also wants to install a Postgres server?
– CL.
20 hours ago
@CL. it is web app.
– Hasan A Yousef
17 hours ago