Create Postgresql Role

  • October, 21 2013
  • triplem
  • Linux
CREATE ROLE username WITH LOGIN PASSWORD 'password'; +
CREATE DATABASE dbname OWNER username;

Edit pga_hba.conf to avoid connections via trust or clear text passwords.

Search

    confused thoughts from a confused mind