Is (sudo) service postgresql restart a clean shutdown

I know database indexes can become corrupted if the server crashes. If I do:

sudo service postgresql restart

can that cause the same kind of corruption as a server crash?

Copyright Notice：Content Author:「zelinka」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/38467697/is-sudo-service-postgresql-restart-a-clean-shutdown

Products recommended by Amazon

More >>>

SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN

HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs

AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler

Timberland Men's 6-Inch Premium Waterproof Boot

More about “Is (sudo) service postgresql restart a clean shutdown” related questions

Is (sudo) service postgresql restart a clean shutdown

I know database indexes can become corrupted if the server crashes. If I do: sudo service postgresql restart can that cause the same kind of corruption as a server crash?

Show Detail

PostgreSQL connection issue after service restart

I have edited my pg_hba file and copied it to server and restarted the services by "sudo service postgresql restart" but after that the server is not connecting. Showing the below error, Your data...

Show Detail

Postgresql cannot restart No PostgreSQL clusters exist

I want to restart my postgres using command sudo service postgresql restart However I'm getting the following error: [warn] No PostgreSQL clusters exist; see "man pg_createcluster" ... (

Show Detail

PostgreSQL server is not connecting after Service Restart

I have edited my pg_hba file(Added a row at the end host all ..... Xxxxxx/32" and copied it to server and restarted the services by "sudo service postgresql restart" but after that the server is not

Show Detail

$ sudo service mysql restart Failed to restart mysql.service: Unit mysql.service not found

I was trying to do this: Install MariaDB $ sudo apt-get update $ sudo apt-get install mariadb-server-10.3 $ sudo apt-get install libmysqlclient-dev Edit the file "/etc/mysql/my.cnf" $ s...

Show Detail

Shutdown or Restart Computer from WCF Service Not Working

I have a function in a WCF service hosted in IIS 7.5 which it task is shutdown or restart computer when it is being called. I use the built in command line and execute it by passing "shutdown.exe ...

Show Detail

Run an ansible task to restart a service using sudo

In advance thank you for your help. I use ansible into my CI gitlab and I need to restart a linux service witout become root. When I run my playbook, I use a local user for my deploiement "dep...

Show Detail

Windows Service log writing on system shutdown / restart

The issue is that when host machine is restarted (Windows restart) or shutdown (Windows shutdown) nothing is being written to the log. I have the following in a Windows Service: protected overrid...

Show Detail

How to check docker service logs when restart and stop by: sudo systemctle restart docker or sudo systemctl stop docker?

I have an ubuntu 18.04 running on a metal server. My docker working good but one day i can not build new docker image, my build script hang without showing any error (the script working good before...

Show Detail

Python Tkinter Shutdown

I am working on an embedded device GUI and have a simple two button screen working, which has restart and shutdown (e.g. poweroff). The restart command works fine, but I am having trouble with the

Show Detail