Changes
Jump to navigation
Jump to search
To work as the postgres account.
Now add the user using:
createuser --interactive joe
(Answer y or n to whether you want the new role to be superuser, etc.)
If the user doesn't have an account on the box, then you'll need to add a database for them (use DBname of 'firstname_data' as a default):
createdb -O username DBname
Drop the dbase and the user with:
dropdb DBname
dropuser username
The 'research' user is created as follows:
createuser -P -s research
# "local" is for Unix domain socket connections only local all all peer To: local all all trust
Database Server Documentation (view source)
Revision as of 15:28, 17 March 2016
, 15:28, 17 March 2016→Adding a dbase user and creating a dbase
effective_cache_size = 198GB(-3/4 of the current RAM)
Change /etc/postgresql/9.3/main/pg_hba.conf from
Restart postgres to reload the configuration:
