Vinicius <[EMAIL PROTECTED]> writes:
postgres$ initdb -D /usr/local/pgsql/data"
the file /var/log/messages shows:
"Feb 20 02:01:38 ronin kernel: audit(1108875698.227:0): avc: denied { write } for pid=8229 exe=/usr/bin/postgres name=data
dev=dm-0 ino=1687533 scontext=user_u:system_r:postgresql_t tcontext=root:object_r:usr_t tclass=dir
You can't put the data directory in a nonstandard place under SELinux unless you modify the security policy to allow the postgres daemon to write in that nonstandard place. The normal behavior of selinux-policy-targeted is to confine postgres to /var/lib/pgsql.
So: (1) use /var/lib/pgsql/data, (2) modify the policy, or (3) disable SELinux enforcement.
BTW, since you are using the RPMs, why are you bothering with manual database setup? "sudo /sbin/service postgresql start" is all you need to do.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Thanks.
I tryed to create another data dir because I don't have the template1 database.
"# ls /var/lib/pgsql/data/base/1
1247 16386 16396 16406 16416 16601 16606 16611 16616 16621 16630 16635 16640 16647 16652
1249 16388 16398 16408 16418 16602 16607 16612 16617 16624 16631 16636 16641 16648 16653
1255 16390 16400 16410 16595 16603 16608 16613 16618 16625 16632 16637 16642 16649 pg_internal.init
1259 16392 16402 16412 16597 16604 16609 16614 16619 16626 16633 16638 16643 16650 PG_VERSION
16384 16394 16404 16414 16599 16605 16610 16615 16620 16629 16634 16639 16644 16651"
How to workaround this, please? Should I remove the /var/lib/pgsql/data dir and create another with initdb command, please?
TIA, Vinicius.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
