DH Unlimited
Portfolio Blog Login
X

About
DH Unlimited is comprised solely of me, Dave. I've been doing freelance web development since 2010, mainly for the purpose of expanding my technical skill set.


Site Updated
01/06/2016

Create a new PostgreSQL user

Wednesday, April 8, 2015 12:45 pm

Example of how to create a user in PostgreSQL copied directly from:
http://www.postgresql.org/docs/9.1/static/app-createuser.html

$ createuser -P -s -e joe
Enter password for new role: xyzzy
Enter it again: xyzzy
CREATE ROLE joe PASSWORD ‘md5b5f5ba1a423792b526f799ae4eb3d59e’ SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

-P prompts for password
-s specifies superuser
-e echoes the commands



Tag(s): PostgreSQL 

Upgrade User Permissions in PostgreSQL

Tuesday, March 31, 2015 9:03 pm

ALTER USER name WITH SUPERUSER;



Tag(s): PostgreSQL 

Interesting...

Monday, March 23, 2015 12:41 pm

“All matter originates and exists only by virtue of a force… We must assume behind this force the existence of a conscious and intelligent Mind. This Mind is the matrix of all matter.”

Max Planck



Tag(s): Life  Quotes 

Check I/O in Linux

Friday, March 13, 2015 4:19 pm

[root@wks1 ~]# hdparm -tT /dev/sda



Tag(s): Linux 

Linux Time Restart

Monday, March 9, 2015 3:26 pm

Determine how far the time is off from peers
~]#ntpq -p


Restart the service
~]#service ntpd restart



Tag(s): Linux 
Back to the Top