status applications

On Mi� 01 Nov 2000 20:57, Martin A. Marques wrote:

Seeing that nobody responded to my questions, here I go. ;-)

I think one of the poor partes about postgres is the administration tools. I
am not a PostgreSQL hacker (would like to be one) so I don know if there are
things like user threads, locks and all those stuff to check for with some
sort of administration tool.

I am willing to help in the development of this tool, and I think it would be
very important for the PostgreSQL community, adn for PostgreSQL as a whole.

Any comments? Bruce? Tom? Vadim?

Are there any status and mode applications for postgres? I mean, an
application that will tell me the status of the server at the moment, and
an app to start and stop postgres.
Does postgres have "administration mode" like a mode to make backups on,
without threads connected?

Thanks!!!

Saludos... :-)

--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Martin A. Marques writes:

Are there any status and mode applications for postgres? I mean, an
application that will tell me the status of the server at the moment, and an
app to start and stop postgres.

pg_ctl

Does postgres have "administration mode" like a mode to make backups on,
without threads connected?

You just disallow everyone to connect.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

On Jue 02 Nov 2000 15:27, you wrote:

Martin A. Marques writes:

Are there any status and mode applications for postgres? I mean, an
application that will tell me the status of the server at the moment,
and an app to start and stop postgres.

pg_ctl

Yes, I have just been checking on that script.

Does postgres have "administration mode" like a mode to make backups on,
without threads connected?

You just disallow everyone to connect.

How would you do something like that?

Thanks.

--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart���n Marqu���s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

[ Charset ISO-8859-1 unsupported, converting... ]

On Mi? 01 Nov 2000 20:57, Martin A. Marques wrote:

Seeing that nobody responded to my questions, here I go. ;-)

I think one of the poor partes about postgres is the administration tools. I
am not a PostgreSQL hacker (would like to be one) so I don know if there are
things like user threads, locks and all those stuff to check for with some
sort of administration tool.

I am willing to help in the development of this tool, and I think it would be
very important for the PostgreSQL community, adn for PostgreSQL as a whole.

Any comments? Bruce? Tom? Vadim?

I want to write a tcl/tk utility that can monitor database connections
and server status. I hope to start in in the next month or two.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026