Posgres Server Configuration - Revision history

Ed: /* Find the sizes of databases on our postgres server */

2018-07-14T16:20:30Z

Find the sizes of databases on our postgres server

Ed at 22:28, 24 January 2017

2017-01-24T22:28:40Z

Ed at 21:37, 24 January 2017

2017-01-24T21:37:47Z

GunnyLiu at 21:49, 21 June 2016

2016-06-21T21:49:44Z

GunnyLiu at 21:39, 21 June 2016

2016-06-21T21:39:50Z

GunnyLiu at 19:27, 10 June 2016

2016-06-10T19:27:30Z

GunnyLiu: Created page with "See also: Working with PostgreSQL Haas PhD Server Configuration Note that the server is now on 128.32.204.203 (having been moved to the new colo) ==Mount Bear==..."

2016-06-10T19:14:23Z

Created page with "See also: *Working with PostgreSQL *Haas PhD Server Configuration Note that the server is now on 128.32.204.203 (having been moved to the new colo) ==Mount Bear==..."

imported>Ed at 21:00, 6 September 2012

2012-09-06T21:00:41Z

imported>Ed at 22:38, 29 August 2012

2012-08-29T22:38:33Z

imported>Ed at 17:31, 16 May 2012

2012-05-16T17:31:48Z

@@ Line 198: / Line 198: @@
       END DESC -- nulls first
      LIMIT 20;
-−
 ===Backing up a dbase===

@@ Line 211: / Line 211: @@
   gzip filename
   gzip -d filename.gz
 ===Restoring a dbase===

@@ Line 177: / Line 177: @@
 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):
   /usr/local/pgsql/bin/createdb -O username DBname
 [[admin_classification::IT Build| ]]

← Older revision		Revision as of 21:49, 21 June 2016
Line 177:		Line 177:
	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):		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):
	/usr/local/pgsql/bin/createdb -O username DBname		/usr/local/pgsql/bin/createdb -O username DBname
		+
		+	[[admin_classification::IT Build\| ]]

← Older revision		Revision as of 21:39, 21 June 2016
Line 1:		Line 1:
−	~~[[category:Internal]]~~
	[[category:McNair Admin]]		[[category:McNair Admin]]

← Older revision		Revision as of 19:27, 10 June 2016
Line 1:		Line 1:
		+	[[category:Internal]]
		+	[[category:McNair Admin]]
		+
	See also:		See also:
	*[[Working with PostgreSQL]]		*[[Working with PostgreSQL]]

← Older revision	Revision as of 19:14, 10 June 2016
(No difference)

@@ Line 3: / Line 3: @@
 *[[Haas PhD Server Configuration]]
-Note that the server is currently on 128.32.252.201 (but will shortly be moved)
+Note that the server is now on 128.32.204.203 (having been moved to the new colo)
 ==Mount Bear==

← Older revision		Revision as of 22:38, 29 August 2012
Line 1:		Line 1:
		+	See also:
		+	*[[Working with PostgreSQL]]
		+	*[[Haas PhD Server Configuration]]
		+
		+	Note that the server is currently on 128.32.252.201 (but will shortly be moved)
		+
	==Mount Bear==		==Mount Bear==

← Older revision		Revision as of 17:31, 16 May 2012
Line 123:		Line 123:

	psql -h 128.32.252.201 -U ed_egan test		psql -h 128.32.252.201 -U ed_egan test
		+
		+	==Adding Users==
		+
		+	===Adding Root Accounts to the box===
		+
		+	Assuming that you have root, you can create user accounts on the box and give them root too. This isn't necessary for regular users - they just need a Postgres user account (see below). To add users to the box, the process is:
		+
		+	First great the users group, checking the last group number (5xx is the next one):
		+	cat /etc/group
		+	/usr/sbin/groupadd -g 5xx username
		+
		+	Then add the user (it doesn't matter what you put for -p, it is going to be overwritten):
		+	/usr/sbin/useradd -g username -G root -s /bin/bash -p xxxx -d /home/username -m username
		+	where g is the primary group, G is other groups, p sets a password,
		+	d declares a home directory and m makes the directory
		+
		+	Change the user's password:
		+	passwd username
		+
		+	And add the user to the sudoers file
		+	echo 'username ALL=(ALL) ALL' >> /etc/sudoers
		+
		+	====Deleting a user====
		+
		+	To delete a user:
		+	/usr/sbin/userdel -r roger
		+	where r removes the home directory
		+
		+	And to remove their group
		+	/usr/sbin/groupdel username
		+
		+	And remove their entry from the sudoers file too if they had root.
		+
		+	===Adding Postgres Accounts===
		+
		+	Log on to the box as root then:
		+	su postgres
		+
		+	To work as the postgres account.
		+
		+	Now add the user using:
		+	/usr/local/pgsql/bin/createuser username
		+	(Answer y or n to whether you want the new role to be superuser - generally y)
		+
		+	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):
		+	/usr/local/pgsql/bin/createdb -O username DBname