Article - CS243021
ThingWorx General Knowledge Base for PostgreSQL in Linux/Unix server environment
Modified: 27-Jul-2016
Applies To
- ThingWorx Platform 6.5 to 7.1
Description
- Basic instructions for managing PostgreSQL 9.4 Database in RHEL/CentOS/Fedora/Unix Environments
- How to Start/Stop/Restart PostgreSQL 9.4 service
- Commands to start/stop/restart/status of Postgresql-9.4 service
- How to debug PostgreSQL logs
- Remotely connecting to PostgreSQL database
- Access PSQL terminal through command line interface
- How to login as root or postgres user
- Host Based Authentication, pg_hba.conf
- How to configure IPTables or Firewall for Postgresql remote connection
- Opening the postgresql port for accepting tcp/ip connection
This is a printer-friendly version of Article 243021 and may be out of date. For the latest version click CS243021