[Server-devel] pgsql password

[Rodolfo D. Arce S.]

On Wed, May 09, 2012 at 12:18:56AM -0700, Sameer Verma wrote:
> I'd like to use the postgresql database to runs some tables for
> another service (pathagar). How/where do I look for the password to
> get to pgsql?

http://wiki.spry.com/Change_forgotten_PostgreSQL_password

This are some useful commands to reseting postgresql root(postgres) password

The important commmands are:

root at localhost# su - postgres
-bash-3.0$ psql
postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'secret';
postgres=#\q

Where "secret" is your new password.

You might want to check if the auth settings for the server are similar

Cheers.. R
> 
> cheers,
> Sameer
> -- 
> Sameer Verma, Ph.D.
> Professor, Information Systems
> San Francisco State University
> http://verma.sfsu.edu/
> http://commons.sfsu.edu/
> http://olpcsf.org/
> http://olpcjamaica.org.jm/
> _______________________________________________
> Server-devel mailing list
> Server-devel at lists.laptop.org
> http://lists.laptop.org/listinfo/server-devel

-- 
Rodolfo D. Arce S.
http://people.sugarlabs.org/~rolf/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: Digital signature
URL: <http://lists.laptop.org/pipermail/server-devel/attachments/20120527/fa9f7f29/attachment.pgp>