-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon 02 Jun 2014 12:21:30 AM UTC, Ganapathy S A via smartos-discuss wrote: > I'm using postgresql 14.1.0 image. The doc says, > "You can find passwords for the root and admin accounts in the > Credentials section of the Instance Details page in the Joyent portal. > > The password listed for the postgres account is the PostgreSQL > password for logging into PostgreSQL, not for logging into the SmartOS > user account." > > But couldn't find the password over there! I'm able to reset passwords > for root, admin & postgres but > sudo -u postgres psql > gives error > psql: FATAL: password authentication failed for user "postgres" > > What is the default password for postgres account? or How to reset > postgres password using root? Please help. > > Regards, > Ganapathy
The postgres database user and the postgres system user are distinct and there is no configured trust in the defaulf configuration. Running psql as the postgres system user will not work without additional pg_hba.conf changes: From any account you should be able to run psql -u postgres -w postgres and get logged in. You almost certainly want to change that to something secure. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTi8maAAoJEP0rIXJNjNSA8RYIAJPEz76ERScdomaCmS0geXI1 B0G1dHcbdIKM0RNe+K6QdiK2QAN4SdE79l6pDg7XAo+vH3BpmSI8FaLOWwcI8NnB dkCCYmYb5XGd/hqMw72Rl64ipEy5LHxBsInX3lLbkbOvVwdVOAozJZXCna5H+YvF xfrGY0L1Xxtdksmha7LZklNcxJHIH/R7+OOCS6WSXN0cBA0Z8qHHW2RKr6WRyev8 S81ffMVFbjBPFBiUdbpYqRSWb0tgymB0lAkbpVJshs/b6u07E8TD+eyf0othomc5 BND7hvxeItsaOpTYxr2KtnaUdJ7XVudEGwPi13h4yoX5OQep2DIlGR79/WwF3TY= =g6Ai -----END PGP SIGNATURE----- ------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
