From: Jeff Frost <jeff@frostconsultingllc.com>
To: Carol Walter <walterc@indiana.edu>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Continuing issues... Can't vacuum!
Date: Fri, 23 May 2008 14:15:33 -0700
Message-ID: <483733F5.6020703@frostconsultingllc.com> (raw)
In-Reply-To: <7B88EF79-78A5-4476-8A54-7EA42042A727@indiana.edu>
References: <5897F703-1525-477B-8749-80A0A4E0A656@indiana.edu>
<1211565622.17493.24.camel@jd-laptop>
<3C9DB43B-9B3D-4E55-B4DE-37E83A1CA136@indiana.edu>
<1211567980.17493.36.camel@jd-laptop>
<DC21DF01-8565-41A9-BD41-0B4B8535A259@indiana.edu>
<4836CDEA.EE98.0025.0@wicourts.gov>
<7B88EF79-78A5-4476-8A54-7EA42042A727@indiana.edu>
Carol Walter wrote:
> Hi, Again.
>
> I tried this and got the same message. It is as follows:
>
> -bash-3.00$ /opt/csw/postgresql/bin/pg_ctl -D
> /dbpdisk/postgres/prod_823 -m fas
> t stop
> pg_ctl: PID file "/dbpdisk/postgres/prod_823/postmaster.pid" does not
> exist
> Is server running?
>
> Are there other ideas?
Carol, what does:
ps -ef | grep postgres
return?
If postgres is really running, there should be a postmaster process that
shows which directory it's using as the DATA directory. It'll look
something like this:
postgres 24080 1 0 09:49 ? 00:00:07 /usr/bin/postmaster -p
5432 -D /var/lib/pgsql/data
If there isn't a postmaster, it's possible someone started postgres with
the -D option directly.
If you have multiple postgres server's running on the same machine,
you'll see multiple postmasters.
BTW: What operating system is this running under? If linux, which
distribution?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jeff@frostconsultingllc.com, walterc@indiana.edu, Kevin.Grittner@wicourts.gov, jd@commandprompt.com
Subject: Re: Continuing issues... Can't vacuum!
In-Reply-To: <483733F5.6020703@frostconsultingllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox