Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DF5BF64FCFC for ; Tue, 2 Dec 2008 02:04:24 -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 54326-10 for ; Tue, 2 Dec 2008 02:04:21 -0400 (AST) X-Greylist: delayed 00:06:40.681342 by SQLgrey-1.7.6 Received: from ns1.aaaonlinux.net (NS1.AAAONLINUX.net [70.84.189.18]) by mail.postgresql.org (Postfix) with ESMTP id 1201064FD42 for ; Tue, 2 Dec 2008 02:04:20 -0400 (AST) Received: (qmail 9648 invoked by uid 508); 2 Dec 2008 06:04:05 -0000 Received: from unknown (HELO direction.biz) (59.163.21.147) by ns1.aaaonlinux.net with SMTP; 2 Dec 2008 06:04:04 -0000 Received: from [172.16.2.20] ([172.16.2.20]) (authenticated user s.borse@direction.biz) by direction.biz (direction.biz) (MDaemon PRO v9.0.0) with ESMTP id md50000192342.msg for ; Tue, 02 Dec 2008 11:24:59 +0530 Subject: Re: change user passwd From: Suresh Borse Reply-To: s.borse@direction.biz To: isabella.ghiurea@nrc-cnrc.gc.ca Cc: pgsql-admin@postgresql.org In-Reply-To: <49344E33.6000900@nrc-cnrc.gc.ca> References: <49344E33.6000900@nrc-cnrc.gc.ca> Content-Type: multipart/alternative; boundary="=-lMO6W6rAaW9vmGXSfBpU" Organization: DSS Date: Tue, 02 Dec 2008 11:19:09 +0530 Message-Id: <1228196949.2250.6.camel@dss-052.dsslp.com> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) X-Authenticated-Sender: s.borse@direction.biz X-Spam-Processed: direction.biz, Tue, 02 Dec 2008 11:24:59 +0530 (not processed: spam filter heuristic analysis disabled) X-MDRemoteIP: 172.16.2.20 X-Return-Path: s.borse@direction.biz X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: direction.biz, Tue, 02 Dec 2008 11:24:59 +0530 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200812/8 X-Sequence-Number: 30841 --=-lMO6W6rAaW9vmGXSfBpU Content-Type: text/plain Content-Transfer-Encoding: 7bit How the remote user access the postgres database. Are they using pgadmin ?? Are they able to connect through psql to remote database? IF yes then try following command dbname=# alter user "Username" password 'password'; In pgadmin tool we can directly edit the user user properties & change the password. On Mon, 2008-12-01 at 12:50 -0800, Isabella Ghiurea wrote: > I'm using PG 8.3.4 , what's the method for remote users to change > their PG passwd . > Isabella > Thanks & Regards, Suresh Borse (DBA) _________________________________________________________________________________________ DIRECTION SOFTWARE SOLUTIONS 5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai - 400 013 Tel. : 91 22 66615000 (Ext: 350) Fax : 91 22 24911046 Cell : 91 9422 239338 Site : www.direction.biz _________________________________________________________________________________________ --=-lMO6W6rAaW9vmGXSfBpU Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit How the remote user access the postgres database.

Are they using pgadmin ?? Are they able to connect through psql to remote database?

IF yes then try following command

dbname=# alter user "Username" password 'password';

In pgadmin tool we can directly edit the user user properties & change the password.

On Mon, 2008-12-01 at 12:50 -0800, Isabella Ghiurea wrote:

I'm using PG 8.3.4 , what's the method for  remote users to change 
their  PG passwd .
Isabella

Thanks & Regards,

Suresh Borse
(DBA)
_________________________________________________________________________________________
DIRECTION SOFTWARE SOLUTIONS
5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai - 400 013
Tel. : 91 22 66615000 (Ext: 350) Fax : 91 22 24911046
Cell : 91 9422 239338 Site : www.direction.biz
_________________________________________________________________________________________

--=-lMO6W6rAaW9vmGXSfBpU--