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

Wed, 1 Nov 2000 20:57:24 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
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
-----------------------------------------------------------------

Thu, 2 Nov 2000 15:04:21 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
Re: status applications
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/


Thu, 2 Nov 2000 19:27:34 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: status applications
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
-----------------------------------------------------------------

Thu, 2 Nov 2000 16:32:54 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
Re: status applications
[ 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

Sat, 4 Nov 2000 11:30:51 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: status applications