Setting up PostgreSQL in RHEL/CentOS 6.x

After you've installed PostgreSQL and its required dependencies in your CentOS server, configure it using the following steps.

1. Add the user postgres to your server. You might have to change your server's user and group policy settings in the file "/etc/adduser.conf":

adduser <options> postgres;

2. Create the directory data to store datafiles of the PostgreSQL database:

mkdir -p /usr/local/pgsql/data;

3. Change ownership of the directory data from root to postgres:

chown <options> postgres /usr/local/pgsql/data;

4. Log in as the user postgres:

su - postgres;

5. Create a default PostgreSQL database using datafiles to be stored in the directory "/usr/local/pgsql/data":

initdb <options> -D /usr/local/pgsql/data;

6. Start the PostgreSQL database service:

postgres <options> -D /usr/local/pgsql/data;

7. Create a new default PostgreSQL database:

createdb <options> <db name>;

9. Automatically start your PostgreSQL service on boot up:

update-rc.d  postgresql <options>;

10. Edit the file "/etc/hosts.allow" that's the hosts access control list for allowing access to services on your server from specific hostnames, IP addresses, networks, and FQDNs:

<service or wildcard>: <hostname> <ip address>/<subnet mask> <fqdn>

11. Edit the file "/etc/hosts.deny" that's the hosts access control list for denying access to services on your server from specific hostnames, IP addresses, networks, and FQDNs:

<service or wildcard>: <hostname> <ip address>/<subnet mask> <fqdn>

12. Allow incoming and outgoing client connections to your PostgreSQL service through your firewall:

iptables -A INPUT -i <interface> -p tcp --dport 5432 -j ACCEPT

iptables -A OUTPUT -o <interface> -p tcp --sport 5432 -j ACCEPT

Do you have a suggestion about how to improve this blog? Let's talk about it. Contact me at David.Brenner.Jr@Gmail.com or 720-584-5229.

Comments

The meaning of time in reinforcement learning

Reinforcement learning (RL) is one of three basic machine learning paradigms, alongside supervised learning and unsupervised learning. Reinforcement learning is concerned with how software agents ought to take actions in an environment in order to maximize the notion of cumulative reward through the process of trial and error. In reinforcement learning an agent starts at an empty state then analyzes the available datasets according to a policy of positive states and negative states. Rather than being explicitly taught as in supervised learning the correct set of actions for performing a task, reinforcement learning uses rewards as signals for positive states and punishments as signals for negative states. The agent obtains the best path to a desirable reward as a cumulation of positive states and negative states. As compared to unsupervised learning, reinforcement learning is different in terms of goals. While the goal in unsupervised learning is to find similarities and differences...

Threat hunting polymorphic malware in Linux with Python

You can investigate suspicious activity that could be polymorphic malware by collecting relevant machine data from your endpoint. You can use the machine data to create your own analysis. Before you start your investigation you will need to determine normal activity on your endpoint. Normal activity is the scope of functionality of the software on your endpoint during periods of low activity and high activity. You will need some kind of software that periodically collects specific machine data from your endpoint like my software developed in Python that's available for free download at https://github.com/davidbrennerjr/server-stats-collector Ingest one or more of the following machine data from Category #1. Ingest one or more of the following machine data from Category #2. And ingest one or more of the following machine data from Category #3. Category #1 General system-wide error messages from /var/log/syslog Auditing logs of application rule...

Application behavior monitoring in Linux with Python

You can monitor application behaviors by collecting relevant machine data from your endpoint. You can use the machine data to investigate suspicious activity and create your own analysis. Before you start your investigation you will need to determine normal activity on your endpoint. Normal activity is the scope of functionality of the software on your endpoint during periods of low activity and high activity. You will need some kind of software that periodically collects specific machine data from your endpoint like my software developed in Python that's available for free download at https://github.com/davidbrennerjr/server-stats-collector Ingest one or more of the following machine data from Category #1. Ingest one or more of the following machine data from Category #2. Category #1 General system-wide error messages from /var/log/syslog Auditing logs of application rulesets Auditing logs of security contexts Auditing logs of ...

David Brenner Jr

Search This Blog