Thread: status applications

status applications

From
"Martin A. Marques"
Date:
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!!!

-- 
"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
-----------------------------------------------------------------


Re: status applications

From
"Martin A. Marques"
Date:
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
-----------------------------------------------------------------


Re: status applications

From
Peter Eisentraut
Date:
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/



Re: status applications

From
"Martin A. Marques"
Date:
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
-----------------------------------------------------------------


Re: status applications

From
Bruce Momjian
Date:
[ 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,
Pennsylvania19026