• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1033
  • Last Modified:

error when start PostgreSQL in Linux

Today I cannot start PostgreSQL and return with following error message


-bash-4.1$ pgl_ctl start -o "-p 5437"
-bash: pgl_ctl: command not found
-bash-4.1$ pg_ctl start
server starting
-bash-4.1$ postgres cannot access the server configuration file "/opt/PostgreSQL/9.2/data/:/opt/PostgreSQL/9.2/data/postgresql.conf": No such file or directory

-bash-4.1$

then after changing some permission, now I get this error below

-bash-4.1$ pg_ctl start -D /opt/PostgreSQL/9.2/data
server starting
-bash-4.1$ 2013-06-13 17:49:42 MYT FATAL:  data directory "/opt/PostgreSQL/9.2/data" has group or world access
2013-06-13 17:49:42 MYT DETAIL:  Permissions should be u=rwx (0700).
0
motioneye
Asked:
motioneye
1 Solution
 
earth man2Commented:
As user root
chown -R postgres /opt/PostgreSQL/9.2/data
chmod -R 0700 /opt/PostgreSQL/9.2/data
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now