How to restart postgresql 8.4 on Debian Squeeze when there are no clusters defined?
From the online documentation...
pg_ctl restart [-w] [-t seconds] [-s] [-D datadir] [-c] [-m s[mart] | f[ast] | i[mmediate] ] [-o options]
pg_ctl is a utility for starting, stopping, or restarting the PostgreSQL backend server (postgres), or displaying the status of a running server. Although the server can be started manually, pg_ctl encapsulates tasks such as redirecting log output and properly detaching from the terminal and process group. It also provides convenient options for controlled shutdown.
Oh, and since I ignored this detail in your answer, but now have reason to question it... the default location of postgresql 8.4 is: /etc/init.d/postgresql-8.4
, not /etc/init.d/postgresql
as you have in your question.
Related videos on Youtube
Daniil Ryzhkov
Updated on September 18, 2022Comments
-
Daniil Ryzhkov over 1 year
How to restart postgresql 8.4 on Debian Squeeze?
/etc/init.d/postgresql stop/start/restart
does nothing (no output given).-
Daniel Vérité over 11 yearsThis is the right command, but it may do nothing if, for example, there is no cluster defined. Could you add the output of
pg_lsclusters
? Also you can invokesh -x /etc/init.d/postgresql start
to see the sequence of commands executed inside the script. -
Daniil Ryzhkov over 11 years
pg_lsclusters
outputs empty table. Looks like this is what I am looking for. How can I define cluster and will it cause problems with existing postgesql tables? -
Daniel Vérité over 11 yearsNo cluster normally means no existing data. A new cluster can be defined with
pg_createcluster
but it will be empty. If you had a cluster previously, you need to understand what happened to it. Is there data under/var/lib/postgresql/8.4
? (trydu
there) -
Daniil Ryzhkov over 11 yearsNo,
/var/lib/postgresql/8.4
does not exsist. But for some reason my postgresql server works for 3 months. -
Daniel Vérité over 11 yearsAssuming the data is not lost, you need to locate it. Look for directories named
pg_*
andbase
. Also the postgres log files (normally in/var/log/postgresql
) may shed some light on what happened last time it was running. -
Daniil Ryzhkov over 11 yearsserverfault.com/questions/422727/… — solution. Thanks to @Daniel Vérité making my problem clearer
-
-
Daniil Ryzhkov over 11 years
pg_ctl
doesn't work in Debian (command not found). They havepg_ctlcluster
, but it requires name of the cluster. How to I get the name of my cluster? -
Daniil Ryzhkov over 11 yearsAlso
/etc/init.d/postgresql --help
actually gives output:Usage: /etc/init.d/postgresql {start|stop|restart|reload|force-reload|status} [version ..]
. And yes, I tried/etc/init.d/postgresql restart 8.4
-
HopelessN00b over 11 years@Daniil And what do the
status
andforce-reload
switches do? I guess you could always force kill the process, but it's probably more constructive to figure out why it's giving you no output when you try to start, stop or restart it. -
Chida over 11 years@Daniil - Can you post the output of $ ps ax | grep postmaster
-
Daniil Ryzhkov over 11 years@ HopelessN00b everything except help outputs nothing. @Chida, ok, wait please
-
Daniil Ryzhkov over 11 years@HopelessN00b
3814 ttyp2 S+ 0:00 grep postmaster