Re: server will not start (Debian)

On Tue, Dec 10, 2019 at 04:13:02PM +0000, Ray O'Donnell wrote:
> On 10/12/2019 16:11, Adrian Klaver wrote:
> > On 12/10/19 7:32 AM, stan wrote:
> >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> >>> Hi Stan
> >>>
> >>> Check security make sure V12 postgres?? has the correct credentials....
> >>>
> >> OK,
> >>
> >> postgres@stantest:/var/run/postgresql$ ls -ld
> >> drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 .
> >>
> >> Looks correct to me.
> >>
> >> This sundirectory 12-main.pg_stat_tmp keeps getting deleted.
> >>
> >> If I create it by hand as user psotgres, the DB starts up when I run:
> >>
> >> /usr/lib/postgresql/12/bin/postgres -D /var/lib/postgresql/12/main -c
> >> config_file=/etc/postgresql/12/main/postgresql.conf
> >>
> >> But tring to start it with /etc/ini.d/postgresql start fails
> >>
> > 
> > How did you install Postgres 12?

sudo apt-get install pointed at:

deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main

> > 
> > Why are you using the file in init.d/ instead of pg_ctlcluster?
> 
> Or indeed systemctl? :-)

I tried that also. did not remeber 

also:

postgres@ica-db:~$ pg_ctlcluster 12 main start
Warning: the cluster will not be running as a systemd service. Consider
using systemctl:
  sudo systemctl start postgresql@12-main
  Cluster is already running.

> 
> Ray.
> 
> -- 
> Raymond O'Donnell // Galway // Ireland
> [email protected]

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin