programmatic interface into admin

From: "SRINIVASARAGHAVAN, RAJESH (HP-Cupertino, ex1)" <rajesh_srinivasaraghavan(at)am(dot)exch(dot)hp(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: programmatic interface into admin
Date: 2001-01-02 21:12:01
Message-ID: 87FB8F5CE210D311B60500A0C9F4871C087C6CE6@xcup01.cup.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

hi all,
I am trying to programmatically administer postgres. Spefically, interested
in adding new user, deleting an existing user, creating and deleting
databases for a user and modifying user's password. I know that all the
above (except for password modifications) can be done using JDBC calls into
the postgres database and modifying the template1 tables. My questions are

1. Is there a security risk or any downside in interfacing directly with
postgres using jdbc queries and not using the system command line utilities
2. Can I programmatically modify the user's password on the postgres system.
Is the password of the user stored in any other place other than the
password file specified in my data directory. Is it a crypt function that
generates the password and stores it in the password file. The obvious
solution to the problem is to use a series of expects with perl on the
remote system.

thank you for your time.

rajesh

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Davis 2001-01-02 21:31:02 RE: pg_dump/psql < db.out issue
Previous Message Tom Lane 2001-01-02 16:44:45 Re: pg_dump/psql < db.out issue

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Jerusalem 2001-01-02 21:15:48 load-balancing and online backup
Previous Message Bruce Momjian 2001-01-02 21:07:56 Re: Re: MySQL and PostgreSQL speed compare