NAME

pcurse - Monitor Postgres databases

SYNOPSIS

$ pcurse  [options]   [dbname]   [user]
for example:
$ pcurse -h localhost  template1  john  --passwd apple

options

--passwd      Default is read from ~/.pgpass
--dbname      Default is template1
--host        Default is localhost
--user        Default is getlogin() 
--port        Default is 5432

DESCRIPTION

pcurse(1) monitors a Postgres database cluster. It shows statistics on tables, indexes, vacuuming, buffers, etc,.

INVOCATION

USAGE

It is too simple:

1. Select a 'MODE' from the menu. To navigate, use arrow keys, the vi keys (j ,k , m ), or ENTER . TAB (or 'l') moves you to the next window.

2. Most modes requires to select a namespace from the the 'Schemas' listbox. Use arrows, vi keys, ENTER (or SPACE, or ' ' ) seals the selection. Press 'd' to view more acl permissions on schema TAB (or 'l') moves you to the button window.

3. The results are displayed in the bottom window. Use arrows, vi keys, ENTER (or SPACE, or ' ' ) seals the selection. Pressing 'd' to view more results. Ctrl-H displays Help screen Ctrl-F appends the contents of the bottom display to /tmp/pcurse.out In tables mode Ctrl-L displays the last 20 updates in table In tables and database mode Ctrl-A analyses at table or database In tables and database mode Ctrl-V analyses at table or database Press 'd' to exit from any of the above tables. TBB (or 'l') takes you back to the starting menu.

4. Press 'q' to quit the program. Thank you for flying Pcurse!

SEE ALSO

AUTHOR

Ioannis Tambouras, <ioannis@cpan.org>

COPYRIGHT AND LICENSE

Copyright (C) 2008 by Ioannis Tambouras

This library is free software; you can redistribute it and/or modify it under the same terms of GPLv3