Changes
Jump to navigation
Jump to search
Database Server Documentation (view source)
Revision as of 20:29, 9 March 2016
, 20:29, 9 March 2016→Mapping a drive to the Dbase server's bulk directory
With username:
MCNAIRDB\username
==Adding a dbase user and creating a dbase==
Log on to the box as root then:
su postgres
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
Change /etc/postgresql/9.3/main/pg_hba.conf from
# "local" is for Unix domain socket connections only
local all all peer
To:
local all all trust
==McNair Center Users==
Use the 'research' account to create dbases and log into them using psql
createdb -O research Test
postgres@McNairDBServ:~$ pg_ctl restart -D /var/lib/postgres-xc/DN2 -Z datanode
pg_ctl: could not open PID file "/var/lib/postgres-xc/DN2/postmaster.pid": Permission denied
