Changes
Jump to navigation
Jump to search
==McNair Center Users==Delete the postgres-xc account: userdel -r postgres-xc vi /etc/group #check the user's group is gone too
Use ==Create the 'research' account to create dbases and log into them using psql createdb -O research Testresearcher user==
Log into the Test DataBase using psql groupadd -g 505 researcher psql useradd -g researcher -s /bin/bash -p xxxx -d Test/home/researcher -U researchm researcher passwd researcher
[https==Notes on individual users== 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)://help.ubuntu.com/community/PostgreSQL installing] createdb -O username DBname Otherwise, they can create databases themselves with createdb DBName Drop the dbase and the user with: dropdb DBname dropuser username
Database Server Documentation (view source)
Revision as of 14:40, 17 March 2016
, 14:40, 17 March 2016no edit summary
Restart postgres to reload the configuration:
/etc/init.d/postgresql restart #Not found if properly removed
The 'research' user on the dbase server is created as follows (su to postgres first):
createuser -P -s researcher
Or postgres@McNairDBServ:~$ pg_ctl restart createuser -D /var/lib/postgres-xc/DN2 -Z datanodeinteractive researcher pg_ctl: could not open PID file "/var/lib/postgres-xc/DN2/postmaster(Answer y or n to whether you want the new role to be superuser, etc.pid": Permission denied)
The issue here seems to be that we have installed Postgres-XC researcher user can create and an entire database cluster...drop databases with: createdb DBName dropdb DBname
