I've searched, what I thought to be relatively thoroughly, and was unable to find a previously asked similar question. My apologies ahead of time if I missed a duplicate question.
I have set up a Postgresql database on RHEL 7 at my work but have run into an issue. Whenever this server restarts it completely blows away the postgres user and the related group as a result of my company's security policy. In order to get around this I'll need to create a service account (in VDS, please see below) and ensure it has the appropriate permissions. So my questions are:
1) Is it possible the change the default user utilized to start up the postgres service? 2) What permissions would be needed for this? Just ownership of the associated executable? Would I need to change ownership of the data folder?
Any and all help is appreciated!
Thanks!
UPDATE: By service account I mean a company definition. Basically a non user account that would be in our virtual directory service. They have specific naming conventions so I don't think I could just request postgres. I'll need to tell the VDS people the permissions this user should have on this box and then make sure this user is the assigned one to initiate the service on start up.