How to restart Postgresql

Try this as root (maybe you can use sudo or su):

/etc/init.d/postgresql restart

Without any argument the script also gives you a hint on how to restart a specific version

[Uqbar@Feynman ~] /etc/init.d/postgresql
Usage: /etc/init.d/postgresql {start|stop|restart|reload|force-reload|status} [version ...]

Similarly, in case you have it, you can also use the service tool:

[Uqbar@Feynman ~] service postgresql
Usage: /etc/init.d/postgresql {start|stop|restart|reload|force reload|status} [version ...]

Please, pay attention to the optional [version ...] trailing argument. That’s meant to allow you, the user, to act on a specific version, in case you were running multiple ones. So you can restart version X while keeping version Y and Z untouched and running.

Finally, in case you are running systemd, then you can use systemctl like this:

[Uqbar@Feynman ~] systemctl status postgresql
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
   Active: active (running) since Wed 2017-11-14 12:33:35 CET; 7min ago
...

You can replace status with stop, start or restart as well as other actions. Please refer to the documentation for full details. In order to operate on multiple concurrent versions, the syntax is slightly different. For example to stop v12 and reload v13 you can run:

systemctl stop postgresql-12.service
systemctl reload postgresql-13.service

Thanks to @Jojo for pointing me to this very one. Finally Keep in mind that root permissions may be needed for non-informative tasks as in the other cases seen earlier.

Related Posts:

  1. How to install grub after installing Windows 10
  2. How do I deal with a filename that starts with the hyphen (-) character?
  3. Bash: No such file or directory?
  4. What’s a .sh file?
  5. How to get the url of the current svn repo?
  6. How to unmount a busy device
  7. How to unmount a busy device
  8. performing HTTP requests with cURL (using PROXY)
  9. No space left on device
  10. Pass a password to ssh in pure bash
  11. How can I exclude directories from grep -R?
  12. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  13. gcc: error: unrecognized command line option
  14. How to exclude a directory in find . command
  15. How can I find all *.js file in directory recursively in Linux?
  16. How to set proxy for wget?
  17. How to change permissions for a folder and its subfolders/files in one step
  18. Docker can’t connect to docker daemon
  19. Need a good hex editor for Linux
  20. Python subprocess.Popen “OSError: [Errno 12] Cannot allocate memory”
  21. What is the format for the PostgreSQL connection string / URL?
  22. How to open some ports on Ubuntu?
  23. Given two directory trees, how can I find out which files differ by content?
  24. Postgresql 9.2 pg_dump version mismatch
  25. How can I drop all the tables in a PostgreSQL database?
  26. Trying to use bash on Windows and got no installed distributions message
  27. How to restart PostgreSQL in Ubuntu 18.04
  28. “Unable to find remote helper for ‘https'” during git clone
  29. What is the difference between “#!/usr/bin/env bash” and “#!/usr/bin/bash”?
  30. Is there a “goto” statement in bash?
  31. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  32. Bash script: bad interpreter
  33. tar: Cowardly refusing to create an empty archive
  34. PG::ConnectionBad: fe_sendauth: no password supplied
  35. How can I delete a user in linux when the system says its currently used in a process
  36. Command to change the default home directory of a user
  37. Read and write to binary files in C?
  38. How to grep and replace
  39. PostgreSQL: Query has no destination for result data
  40. psql: FATAL: database “” does not exist
  41. Can’t remove a directory in Unix
  42. How to recursively download a folder via FTP on Linux
  43. C fopen vs open
  44. input file appears to be a text format dump. Please use psql
  45. Why does “docker attach” hang?
  46. Retrieve last 100 lines logs
  47. What are various options / arguments for “./configure” in Linux
  48. What does ls -d command stand for in linux terminal? 
  49. Postgresql column reference “id” is ambiguous
  50. How to include file in a bash shell script
  51. Does Mac OS X use Linux?
  52. CronJob not running
  53. Delete .DS_STORE files in current folder and all subfolders from command line on Mac
  54. How to configure WP filesystem access in Linux (Ubuntu Server)?
  55. Can’t upload media to my Raspberry Pi WordPress server
  56. My WordPress is giving me an 403 error when saving post/draft with specific words
  57. How can I sort du -h output by size
  58. What exactly do the colors in htop status bars mean?
  59. Why is my crontab not working, and how can I troubleshoot it?
  60. Showing total progress in rsync: is it possible?
  61. How to bind MySQL server to more than one IP address?
  62. Why is “chmod -R 777 /” destructive?
  63. What’s the best way of handling permissions for Apache 2’s user www-data in /var/www?
  64. How to check if a library is installed?
  65. Is it normal to get hundreds of break-in attempts per day?
  66. How to setup passwordless `sudo` on Linux?
  67. How do I prevent accidental rm -rf /*?
  68. How do I verify the speed of my NIC?
  69. What does Virtual memory size in top mean?
  70. What’s the best way to check if a volume is mounted in a Bash script?
  71. How do I find the UUID of a filesystem
  72. Find out symbolic link target via command line
  73. Meaning of directories on Unix and Unix like systems
  74. How to handle security updates within Docker containers?
  75. Job scheduling using crontab, what will happen when computer is shutdown during that time?
  76. Is it possible to make Nginx listen to different ports?
  77. how do you create an ssh key for another user?
  78. REJECT vs DROP when using iptables
  79. Linux command line best practices and tips?
  80. How to run command as user who has /usr/sbin/nologin as Shell?
  81. How to get pid of just started process
  82. How to disable everything in crontab -l?
  83. df says disk is full, but it is not
  84. Perform rsync while following sym links
  85. What is the maximum port number?
  86. Show all users and their groups/vice versa
  87. Why is TCP accept() performance so bad under Xen?
  88. Caching/preloading files on Linux into RAM
  89. How to sort ps output by process start time?
  90. What’s wrong with always being root?
  91. Is there a proper way to clear logs?
  92. pg_dump and pg_restore: input file does not appear to be a valid archive
  93. Hundreds of failed ssh logins
  94. Transfer 15TB of tiny files
  95. What should I do when I got the KEYEXPIRED error message after an apt-get update?
  96. protocol version mismatch — is your shell clean?
  97. How do I join two named pipes into single input stream in linux
  98. How should an IT department choose a standard Linux distribution?
  99. Command line program to test DHCP service
  100. Service start request repeated too quickly, refusing to start limit

Leave a Comment