Thank you Rich,Fred,Scott,Viktor and Gerard for your replies.
Actually I am neither the system administrator nor the person who set up all
the servers. I am developing an application which would provide the user
with a list of running Postgres DB servers from which the user can select
one. So I wa
Wells Oliver writes:
> For whatever reason- investigations still pending- the postgres process
> froze up and I had to do a killall b/c pg_ctlcluster would not revive
> the thing. Everything seems to be in working order, but I'd like to know
> if there's any kind of consistency check I should run
For whatever reason- investigations still pending- the postgres process
froze up and I had to do a killall b/c pg_ctlcluster would not revive
the thing. Everything seems to be in working order, but I'd like to know
if there's any kind of consistency check I should run in light of
events. Also, what
I believe in this case you will have to talk with the sysadmin and have an
agreement about this requirement for your application. I don't know about
Spiceworks, but I see nmap as an application working on layer 3/4, so you
may be subject to firewall rules or anything defined in the security policy.
Excerpts from Pablo Delgado Díaz-Pache's message of jue nov 18 08:57:16 -0300
2010:
> 2) We did a strace to the postmaster pid. However we had 2 postmasters not
> dead
>
> # ps -fea |grep -i postmaster
> postgres 3889 1 0 Nov16 ?00:01:24 /usr/bin/postmaster -p 5432
> -D /var/lib/pg
Excerpts from Pablo Delgado Díaz-Pache's message of jue nov 18 08:57:16 -0300
2010:
> Well, we had the problem again. This is what we did
>
> 1) A "ps" to check what processes were running. Many "postmaster" processes
> in defunct state. A few postgres connections still working. A few "psql" (by
