sexta-feira, 18 de março de 2016

setting a new password for user Postgres...

There is no default password for user postgres on a fresh Postgres install, so you need to set it. On the command line (linux bash), just type:

     $ sudo -u postgres psql

This will start the postgres interactive console. Use the alter user to change the password:

     postgres=> alter user postgres password 'yournewpasswordgoeshere';

And your are done.  =)

I'm using HeidiSQL to interact with postgres by the way:




Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06

Nenhum comentário:

Postar um comentário

Leave your comment here!