The Wayback Machine - https://web.archive.org/web/20201208204847/https://github.com/PostgresApp/PostgresApp/issues/594
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question about security on development-machine #594

Open
chmich opened this issue Sep 28, 2020 · 1 comment
Open

Question about security on development-machine #594

chmich opened this issue Sep 28, 2020 · 1 comment

Comments

@chmich
Copy link

@chmich chmich commented Sep 28, 2020

Hi Gys,

What is best practice for security on a local development-machine?
One role for each database?

sometimes, it is helpful to drag a dump from production to development for finding errors.
But, in that case, there may be sensitibe data on the dev-machine.

if anyone hacks my notebook, he has all sensitive data - and if he is a professinal all is lost - clearly.

But, would that make sense, in Postgres-App?

  • by click on role "postgres", Password is required (optional)?
  • the same, optional on the other roles?

Best Regards,
Christian

@jakob
Copy link
Member

@jakob jakob commented Sep 28, 2020

By default, Postgres.app creates a server with the following settings:

  • connections allowed only from localhost
  • no password required

The goal is to make it easy for local development. It does make you vulnerable to attackers that have partial access to your computer, eg. a sandboxed app could access your sensitive data or use Postgres.app for privilege escalation.

If you want to improve security, setting a password for all users is a good idea. You also need to edit pg_hba.conf to change the authentication settings.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.