Tuesday, February 07, 2012

When creating Postgresql users....

Being new to the Postgresql database server this is a note to self, in the future when creating postgresql users, remember the options precede the user name. For example, to create a user with an encrypted password issue the following from the command prompt:
$ sudo su postgres
$ createuser -e -P theUserNameHere
The first line logs you in as the postgres superuser. The next line is where the user is created. The -e option is so the password is encrypted and the -P option is so the password is requested before the user creation is complete. There, now I have it for future reference. 

No comments: