1

I have a constraint, that I can use only one user on a SUSE Linux Enterprise Server 11.

Now, I need to install PostgreSQL 9.4. Is it possible to somehow avoid the automatic creation of "postgres" linux user by PostgreSQL's installation wizard, and use current user as a database admin?

Additional explanation about the weird constraints:

We have to host our software on the server of the IT company, which is subsidiary of the big bank. They have quite strict rules, due to storing and processing of the sensitive user data. So, one of the rules, is that we can have only one user there and everything should be installed under this user (with sudo rights). Initially, the server has only the most basic software (and PostgreSQL is not included there).

  • 1
    Could you describe a bit why this (very weird) constraint is in place? Is there any other user there than root? – dezso Sep 5 '18 at 8:38
  • @dezso, we have to host our software on the server of the IT company, which is subsidiary of the big bank. They have quite strict rules, due to storing and processing of the sensitive user data. So, one of the rules, is that we can have only one user there and everything should be installed under this user (with sudo rights). Initially, the server has only the most basic software (and PostgreSQL is not included there). – Bi0max Sep 5 '18 at 9:17
  • But you can install software on it? I would expect them to provide you with the installation in that case. – Tom V Sep 5 '18 at 9:18
  • 2
    And (irrelevant to the issue but) why 9.4 and not the latest version (10)? Why a version that is 3 versions behind? – ypercubeᵀᴹ Sep 5 '18 at 9:50
  • 1
    .. and soon to be 4 ... – ypercubeᵀᴹ Sep 5 '18 at 9:57
0

The full answer is in this post: https://serverfault.com/questions/929677/postgresql-installation-avoid-creating-postgres-user

The only way is to build PostgreSQL from source.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.