On 04/17/2014 05:55 PM, Augori wrote:
Hi Adrian,
I don't know the answer to #1. Was that a wildcard search?
It was a grep of the processes running. You replied with this:
"Here's what the ps command gives:
root(at)server# ps ax | grep post
9165 pts/1 S+ 0:00 grep post"
If postgres was running it should have shown up above. Just seemed to be
at odds with later post:
"
woohoo!
service postgresql-9.2 status
(pid 9924) is running...
"
All I can figure is at some point between the first and second post the
service for Postgres was started again. There just was no mention of
that so I was trying to figure out the sequence of events.
As for #2, I should have been more clear, that's not a check that it
does every night. I just ran that check when it seemed to be down. It
has been a long time to since I've worked with it, so I didn't correctly
recall that I needed to look for postgresql-9.2 and not just postgresql.
The problem came up because the nightly process (a Python script that
uses psycopg2) tried to, but couldn't connect to postgresql-9.2 server.
Does that make more sense?
Sort of, if the Python script is the only thing hitting the database.
Otherwise I would have expected other 'users' to notice the database was
down. Furthermore, psycopg2 does not know service names, it connects to
a port, host, database as a user. So unless those where changed I would
expect it to keep on connecting, unless the service was stopped, which
seems to follow what I mention above. At any rate everything worked out.
On Tue, Apr 15, 2014 at 12:08 AM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
On 04/14/2014 08:25 PM, Augori wrote:
Hi all,
woohoo!
service postgresql-9.2 status
(pid 9924) is running...
It seems that I was looking for the service by the wrong
name, as
John guessed correcty. Also, Tom, it's good to know that the data
won't necessarily go away if I need to reinstall at some point.
Well that still leaves two questions unanswered.
1) Why did the postgres process not show up in the ps ax output?
2) Why is the nightly process doing a status check on postgresql not
postgresql-9.2 ?
>From the original post:
# service postgresql status
postgresql: unrecognized service
thank you so much for the messages from all three of you. Your
rapid
responses were very encouraging.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
