Cannot start postgresql properly

Question

I cannot "service postgresql start" by root:

Startup Log: /usr/bin/postmaster: error while loading shared libraries: libz.so.1: failed to map segment from shared object: Permission denied

I cannot "service postgresql start" by postgres:

Startup Log:runuser: cannot set groups: Operation not permitted

But I can start it by postgres user with command:

postmaster -D /usr/local/pgsql/data

Why?

When I installed, I used

initdb -D /usr/local/pgsql/data

not

service postgresql initdb

So I afterwards changed init.d/postgresql script with the new path. Is this causing problem?

Sounds like a permission problem on the data directory. Did you check if the postgres (operating system) user has full access to /usr/local/pgsql/data and all sub-directories? — user330315
– user330315, Commented May 31, 2012 at 10:52
@a_horse_with_no_name Looks to me like zlib has the wrong permissions or SELinux label, m'self. — Craig Ringer
– Craig Ringer, Commented May 31, 2012 at 13:01
OP: what OS and version are you on? What version of PostgreSQL? How did you install PostgreSQL and from where? If it's CentOS or Fedora, are there any SELinux messages in the system log or dmesg? — Craig Ringer
– Craig Ringer, Commented May 31, 2012 at 13:02
CentOS5.6 PostgreSQL8.1.23 I installed by yum. Nothing in dmesg. What permission should zlib has? It's now owned by root. I chown postgres:postgres /usr/local/pgsql — Hao
– Hao, Commented May 31, 2012 at 14:44

AlSher · Accepted Answer · 2014-05-11 06:57:52Z

2

Caused for me by creating the DB with

/etc/init.d/postgresql-9.3 initdb

Recreating with

service postgresql-9.3 initdb

solved the issue.

answered May 11, 2014 at 6:57

AlSher

1379 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

KaiThomasWerther Over a year ago

What should I do when i don't have "service" available?

AlSher Over a year ago

@KaiThomasWerther and pg_createcluster?

KaiThomasWerther Over a year ago

Running the Scripts on init.d solved it. CentOs is weird when you are used to Windows ;)

Chris Travers · Accepted Answer · 2013-04-02 10:41:23Z

0

As Craig said this is either a file permission issue or a selinux issue. If it is a file permissions issu, that is easy enough to fix (give read/execute perms).

If it is an selinux issue your best option is to run audit2allow to identify the problem and ensure that selinux is configured to allow the correct access.

answered Apr 2, 2013 at 10:41

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Collectives™ on Stack Overflow

Cannot start postgresql properly

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related