Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 328256501B4 for ; Tue, 2 Dec 2008 13:12:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71085-02 for ; Tue, 2 Dec 2008 13:12:56 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 5597B6501A8 for ; Tue, 2 Dec 2008 13:12:56 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id mB2HCtJp077902 for ; Tue, 2 Dec 2008 13:12:55 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id mB2HC5ZH077032 for pgsql-admin@postgresql.org; Tue, 2 Dec 2008 13:12:05 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: change user passwd Date: Tue, 02 Dec 2008 12:12:00 -0500 Organization: cbbrowne Computing Inc Lines: 13 Message-ID: <87ej0qmrhb.fsf@dba2.int.libertyrms.com> References: <49344E33.6000900@nrc-cnrc.gc.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110006 (No Gnus v0.6) XEmacs/21.4.21 (linux) Cancel-Lock: sha1:njfDyJ0tieRcJZs6p1m6vWJeR8E= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/15 X-Sequence-Number: 30848 isabella.ghiurea@nrc-cnrc.gc.ca (Isabella Ghiurea) writes: > I'm using PG 8.3.4 , what's the method for remote users to change > their PG passwd . The method is to use the "ALTER USER" command. -- (format nil "~S@~S" "cbbrowne" "acm.org") http://cbbrowne.com/info/lisp.html "The classic Common Lisp defmacro is like a cook's knife; an elegant idea which seems dangerous, but which experts use with confidence." -- Paul Graham, _On Lisp_