Re: [ADMIN] schema sizes

2005-03-02 Thread Morus Walter
Daniel Rubio writes: > Hi all! > > We want to obtain the size of the diferent schemas of some databases. > We've installed dbsize and it works fine, but it returns the size of all > the database. > Exists some method to determine the size of a concrete schema? > I use SELECT nspname, sum(relpa

Re: [ADMIN] Application gui

2005-03-02 Thread Marco Rademeyer
There are 2 that I know of. pgaccess and pgadmin3 On Debian you can do an apt-get to get them Regards Marco On Tue, 2005-03-01 at 15:48 -0300, Philip Pinkerton wrote: > I am looking for an application builder to create an application to > enter client data into the database. > > any sug

Re: [ADMIN] Automatic database backup on Windows Machine

2005-03-02 Thread John DeSoi
On Mar 2, 2005, at 4:18 AM, William Shatner wrote: I am a newbie at PostgreSQL. I am running PostgreSQL 8.0 on Windows XP. I would like to automate my database backup (pg_dump, pg_dumpall). I can't add it to scheduled tasks as Windows doesn't see my PostgreSQL superuser account (it only sees the se

Re: [ADMIN] Scheduling/Automated Jobs in Postgre

2005-03-02 Thread Jim C. Nasby
This is something that comes up every few months. Core is of the opinion that you should just use the tools of your OS. Personally, I think some kind of job system in the database would be very useful, so the last time this came up I created http://pgfoundry.org/projects/pgjob/. No work is being do

Fwd: Re: [GENERAL] [ADMIN] pg_shadow passwd decrypt

2005-03-02 Thread Arcane_Rhino
One can, however, simply delete the forgotten password and create another for temporary usage until the user in question can create a new one. (At least one could in 7.4, I have not tried it in 8.0.) Jeff --- Bruce Momjian wrote: > From: Bruce Momjian > Subject: Re: [GENERAL] [ADMIN] pg_shad

Re: [ADMIN] I have elaborated some useful views...

2005-03-02 Thread Greg Patnude
Sweet !!! "Martha Cecilia Ayala "Hernández"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > > I have elaborated some useful views for administration purposes: > > create or replace view pga_functions as >select >l.lanname as language, >n.nspname || '.' || p.pr

Re: [ADMIN] Database Name

2005-03-02 Thread Greg Patnude
"Envbop" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > I've just inherited a PostgreSQL database, for which I do not have any > details of, like database name or the users. > This used to be a library database which was managed via a web page > written > in php. > Its runni

Re: [ADMIN] pg_shadow passwd decrypt

2005-03-02 Thread Bruce Momjian
Hemapriya wrote: > Hi, > > Does postgres support any system functions that > decode/decrypt the user passwords stored in pg_shadow > system catalog. > > Is there a way to retrieve the passwords, if > forgotten. No. They are MD5 and are designed to be unencryptable. -- Bruce Momjian

[ADMIN] pg_shadow passwd decrypt

2005-03-02 Thread Hemapriya
Hi, Does postgres support any system functions that decode/decrypt the user passwords stored in pg_shadow system catalog. Is there a way to retrieve the passwords, if forgotten. Thanks in Advance. Priya __ Celebrate Yahoo!'s 10th

Re: [ADMIN] Database Name

2005-03-02 Thread Bernt Andreas Drange
On Tue, 2005-03-01 at 09:44 +1300, Envbop wrote: > Hi > > I've just inherited a PostgreSQL database, for which I do not have any > details of, like database name or the users. > This used to be a library database which was managed via a web page written > in php. > Its running on a Linux box. > Th

Re: [ADMIN] Scheduling/Automated Jobs in Postgre

2005-03-02 Thread Christopher Browne
[EMAIL PROTECTED] ("Aravindhan G.D") wrote: > I need to do some user defined jobs when ever the Postgre server > gets restarted. These tasks should be automated one i.e) When ever I > restart the server the PL/SQL functions I have defined should be > executed automatically without my intervention.

[ADMIN] schema sizes

2005-03-02 Thread Daniel Rubio
Hi all! We want to obtain the size of the diferent schemas of some databases. We've installed dbsize and it works fine, but it returns the size of all the database. Exists some method to determine the size of a concrete schema? Thanks in advance. -- ***

Re: [ADMIN] Running multiple postmaster instances in the same machine

2005-03-02 Thread thomas . revell
>Hi, >I'm trying to run multiple postmaster instances on the same machine. I >want to start and stop the server >from inside of my application. However, for each of these instances, I >want to specify a different "storage cluster". >I understand that I can do that while initializing (initdb -D )

[ADMIN] Automatic database backup on Windows Machine

2005-03-02 Thread William Shatner
Hi, I am a newbie at PostgreSQL. I am running PostgreSQL 8.0 on Windows XP. I would like to automate my database backup (pg_dump, pg_dumpall). I can't add it to scheduled tasks as Windows doesn't see my PostgreSQL superuser account (it only sees the service a/c). Even if it did i think there migh

Re: [ADMIN] Procedures, rules & UDF's....

2005-03-02 Thread Michael Fuhr
On Mon, Feb 28, 2005 at 02:22:59PM -0800, Greg Patnude wrote: > Is there a quick and dirty SQL query where I can locate the rules, > procudures and user-defined functions in the system catalogs ??? > > there ain't a ton of documentation on the pg_catalog tables & view Have you seen the "Sys

Re: [ADMIN] Scheduling/Automated Jobs in Postgre

2005-03-02 Thread Michael Fuhr
On Wed, Mar 02, 2005 at 10:09:53AM +0530, Aravindhan G.D wrote: > I need to do some user defined jobs when ever the Postgre server > gets restarted. These tasks should be automated one i.e) When ever > I restart the server the PL/SQL functions I have defined should be > executed automatically with