What does restarting Jira DB mean?

[Pravin Patil]

Hi,

I dont have much experience with DataBases and how they function.

My Jira App and Jira DB (postgres 9.5) are on separate centos boxes/servers.

There are linux administrative tasks planned which needs to restart the entire server.

I know from Jira App perspective to start/stop the jira services, and the server/box its sitting on can be restarted.

But, how to stop/start the DB? what are the things to look out for restarting the Jira DB server?

[Kurt Klinner · Accepted solution]

@Pravin Patil 

To ensure that your application is in a defined state when the db server gets restarted you should first stop your jira instance

1. Stop Jira

2. Stop DB

3. Run administrative tasks

4. Start DB

5. Start Jira

for each of the steps you should also check the log files of the component.

If i am not completely wrong than centos makes use of systemdb

so something like

service postgresql-9.5 stop

should stop the instance

Cheers

Kurt

[Pravin Patil]

Thank you for your response Kurt.

Do I have to be at any particular folder/directory level to execute the DB stop start commands?

Should this be executed as root user?

Are the commands below correct:

Stop DB service/process:

service postgresql-9.5 stop

 Start DB Service/process:

service postgresql-9.5 start

[Nic Brough -Adaptavist-]

Those commands look they are probably right, although on my database server it is just postgresql without any version.   You can check safely with "service postgresql-9.5 status" to just report back the current status of the service, and that it is the right name!

It should be run as root, or with sudo.  You don't need to be in any particular directory to do it.