Re: It's dead and won't get up!! - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: It's dead and won't get up!!
Date
Msg-id 200111082336.fA8NaGcg030871@linda.lfix.co.uk
Whole thread Raw
In response to Re: It's dead and won't get up!!  ("KUCHARSKI, DAVID R." <dave@iemco.com>)
List pgsql-novice
"KUCHARSKI, DAVID R." wrote:
  >the man page suggested
  >#nohup postmaster >logfile2>1  &
  >
  >from a google search they suggested going to the control tab of linuxconf
  >and trying to restart the service there.  NO LUCK that way.
  >
  >when I try:
  >#su postgres
  >$ postmaster
  >
  >I get the following:
  >/usr/bin/postmaster doesn't know where to find database system data.  You
  >must specify the directory that contains the database system either by
  >specifying the -D invocation option or by setting the PGDATA environment
  >variable.

You would do better to use "su - postgres" so as to load the login
environment for postges, which ought to define PGDATA.  If it still doesn't
work you can use -D as suggested by the error message.


As to your original problem, have you perhaps run short of disk space?
WAL now creates its files in 16Mb chunks; see if there is anything
about that in your log files.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "And whosoever liveth and believeth in me shall never
      die. Believest thou this?"    John 11:26



pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: Benchmarking
Next
From: "KUCHARSKI, DAVID R."
Date:
Subject: Re: It's dead and won't get up!!