On Mon, Apr 26, 2010 at 8:55 AM, John Gage <jsmgage@xxxxxxxxxxxxxx> wrote: > A very key difficulty is that if I attempt to add postgres as a user to my > system, my system tells me postgres already is a user. But, unfortunately, > postgres as a user on my system has no password. His postgresql password > does not work on the system. The account doesn't have a password by default as it's a service account and you shouldn't need to use it interactively. If you really want to though, just set a password: gator:~ dpage$ sudo passwd postgres Changing password for postgres. New password: Retype new password: gator:~ dpage$ su - postgres Password: gator:~ postgres$ -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
