Shulou(Shulou.com)06/01 Report--

It is believed that many inexperienced people have no idea about how to set up Centos7 database startup users. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

A database system using shared memory.

Like oracle, postgresql.

System V IPC is used by default on linux.

But centos 7 made an important change.

That is, when an os user is in logout, all resources requested by that user will be released.

At this time, the problem arises. If the requested shared memory is freed. IPC just hung up.

The database naturally hung up.

The rescue methods are as follows:

Create the startup user of the database as the system user

That is, to add the option-system when creating users.

Useradd postgres-- system-m

The os user created in this way is the system user. In this way, the system service started by this account, after the account logout,

The resources applied for will not be recycled and released.

2. Configuration parameters of os.

/ etc/systemd/logind.conf

# RemoveIPC=no

At present, this parameter is no. That is, at present, the old method can continue to be used. It is not enough to cause harm.

After reading the above, have you mastered the method of setting up users in Centos7 database? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.