What is the difference between "service postgresql start" and "pg_ctl start"?
10,378
The service command runs a System V-style init script. In this case you are running a script named postgreql in the /etc/init.d directory. This script likely has been written especially for Ubuntu and has the proper configuration information in it.
Related videos on Youtube
04 : 19 : 34
Learn PostgreSQL Tutorial - Full Course for Beginners
38 : 42
postgresql streaming replication , failover and failback #postgresql #opensource #postgres
18 : 21
Part 1 - PostgreSQL : PostgreSQL Introduction and Architecture.
14 : 42
Part 12 - PostgreSQL " What is a Cluster in PostgreSQL".
07 : 22
Part -23 Postgres: Stop and start PostgreSQL service
07 : 01
pg ctl for starting stopping cluster
13 : 54
Top 25 PostgreSQL Interview Questions and Answers for 2022
Author by
Hejag
Updated on June 04, 2022Comments
-
Hejag almost 2 years
On Ubuntu 14.04, if i have the PGDATA environment variable set, the two commands
service postgresql startAnd
pg_ctl startseems to do the same thing: Start the postgres server in the background. Without PGDATA set, "pg_ctl start" needs needs the additional -D /datadir argument in order to start. The service does not need this. Why is this so? What is the difference between the two ways of starting the server? And how can the service start without knowing the data dir?
-
Hejag almost 9 yearsYes. I guess
service postgresql startwill start postgres with some default location like/etc/postgresql/<version>/main. Thanks!