RE: programmatic interface into admin

From: "Andrew Snow" <als(at)fl(dot)net(dot)au>
To: "SRINIVASARAGHAVAN, RAJESH (HP-Cupertino, ex1)" <rajesh_srinivasaraghavan(at)am(dot)exch(dot)hp(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: RE: programmatic interface into admin
Date: 2001-01-03 01:35:05
Message-ID: JEEGIJPOJIGGIIHGKOKOOEHICHAA.als@fl.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general


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

Please see the Postgres User's docs. There are SQL queries provided to
CREATE and DROP users, tables, and set a user's password.

- Andrew

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Breen 2001-01-03 11:04:36 Postmaster crashes with "ServerLoop: select failed message"
Previous Message SRINIVASARAGHAVAN, RAJESH (HP-Cupertino, ex1) 2001-01-03 01:00:29 programmatic interface into admin

Browse pgsql-general by date

  From Date Subject
Next Message Sungchul Park 2001-01-03 01:57:12 Re: Re: Hierarchical queries in pgsql
Previous Message Lincoln Yeoh 2001-01-03 01:17:25 Re: SV: MySQL and PostgreSQL speed compare