Changes between Version 4 and Version 5 of Sensors/Grimm/settingUpPostgresDB

Timestamp:

Oct 8, 2014, 11:59:01 AM (10 years ago)

Author:

knpa

Comment:

--

Sensors/Grimm/settingUpPostgresDB

@@ -4 +4 @@
 You will need sudo on that machine.
 
-- install postgres: 
-sudo yum install postgresql
+- install postgres: [[BR]]
+sudo yum install postgresql[[BR]]
 sudo yum install postgresql-server
 
 postgres tends to install its files under the username postgres. You should therefore create and use this user for the steps below. Specifically you need access to /var/run/postgresql/
 
-- make a directory for posgres data: 
+- make a directory for posgres data: [[BR]]
 mkdir -p /usr/local/pgsql/data
 
-- Create a database cluster (file structure) 
+- Create a database cluster (file structure) [[BR]]
 initdb -D /usr/local/pgsql/data
 
-- Initialise the server (I think I only need to do the second of these things) 
-postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
+- Initialise the server (I think I only need to do the second of these things) [[BR]]
+postmaster -D /usr/local/pgsql/data >logfile 2>&1 &[[BR]]
 postgres -D /usr/local/pgsql/data &
 
-- create database: 
+- create database: [[BR]]
 createdb <db_name>
 
-- To restart the server (after shutting down for example)
-su - postgres
+- To restart the server (after shutting down for example)[[BR]]
+su - postgres[[BR]]
 pg_ctl start -D /usr/local/pgsql/data       
 
@@ -34 +34 @@
 There are two main config files, both in the above dir.
 
-pg_hba.conf (the client authentication configuration file)
+pg_hba.conf (the client authentication configuration file)[[BR]]
 postgresql.conf (all sorts of things)
 
 You need to explicity allow for external hosts to connect to the database:
 
-pg_hba.conf:
-# IPv4 local connections:
+pg_hba.conf:[[BR]]
+# IPv4 local connections:[[BR]]
 host    all             all             192.171.161.1/24         trust
 
-postgresql.conf
+postgresql.conf[[BR]]
 listen_addresses = '*'
 
-pg_ctl is a utility for monitoring and controlling a posgreSQL server
-Check server status:
-pg_ctl status -D /usr/local/pgsql/data       
+pg_ctl is a utility for monitoring and controlling a posgreSQL server[[BR]]
+Check server status:[[BR]]
+pg_ctl status -D /usr/local/pgsql/data[[BR]]       
 pg_ctl: server is running (PID: 29763)