Re: Unrecognized service - Mailing list pgsql-general

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@aklaver.com <mailto:adrian.klaver@aklaver.com>> 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@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com