Hi,
You could use the following...;-) psql -U postgres template1 UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres'; You could also use GRANT or create other users as well... kindly check the administrative section of your documentation...;-) Cheers, John Clark ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl