Thread: status applications
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 -----------------------------------------------------------------
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, Pennsylvania19026