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 _________________________________________________________________________________________