X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 43C928BAF93 for ; Sun, 20 Feb 2005 13:53:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69372-07 for ; Sun, 20 Feb 2005 13:53:28 +0000 (GMT) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id 340B28BAF9E for ; Sun, 20 Feb 2005 13:53:30 +0000 (GMT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1D2rTM-0001c4-QB for pgsql-admin@postgresql.org; Sun, 20 Feb 2005 14:50:08 +0100 Received: from 200-101-054-239.bsace705.dsl.brasiltelecom.net.br ([200.101.54.239]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 20 Feb 2005 14:50:08 +0100 Received: from cviniciusm by 200-101-054-239.bsace705.dsl.brasiltelecom.net.br with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 20 Feb 2005 14:50:08 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Vinicius Subject: Having problem with postgresql configuration (template1 doesn't exist)? Date: Sun, 20 Feb 2005 10:11:40 -0300 Lines: 74 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 200-101-054-239.bsace705.dsl.brasiltelecom.net.br User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: pt-br, pt X-Gmane-MailScanner: Found to be clean X-Gmane-MailScanner: Found to be clean X-Gmane-MailScanner-SpamScore: ssss X-MailScanner-From: sql-pgsql-admin@m.gmane.org X-MailScanner-To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.688 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/175 X-Sequence-Number: 16343 Hello, I'm having problem with the configuration of postgresql. Can anybody help me, please? I did do the followings steps as explained in the section "16.2. Creating a Database Cluster" of the "PostgreSQL 7.4.7 Documentation": "root# mkdir /usr/local/pgsql/data root# chown postgres /usr/local/pgsql/data root# su postgres postgres$ initdb -D /usr/local/pgsql/data" then shows: "fixing permissions on existing directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory /usr/local/pgsql/data/global... ok creating directory /usr/local/pgsql/data/pg_xlog... ok creating directory /usr/local/pgsql/data/pg_clog... ok selecting default max_connections... 10 selecting default shared_buffers... 50 creating configuration files... ok creating template1 database in /usr/local/pgsql/data/base/1... initdb: failed" 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 Feb 20 02:01:38 ronin last message repeated 36 times Feb 20 02:01:38 ronin kernel: audit(1108875698.228: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 Feb 20 02:01:38 ronin last message repeated 47 times Feb 20 02:01:38 ronin kernel: audit(1108875698.229: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 Feb 20 02:01:38 ronin last message repeated 16 times Feb 20 02:01:38 ronin kernel: audit(1108875698.435:0): avc: denied { write } for pid=8305 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 Feb 20 02:01:38 ronin kernel: audit(1108875698.436:0): avc: denied { write } for pid=8305 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 Feb 20 02:01:38 ronin last message repeated 39 times Feb 20 02:01:38 ronin kernel: audit(1108875698.437:0): avc: denied { write } for pid=8305 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 Feb 20 02:01:38 ronin last message repeated 46 times Feb 20 02:01:38 ronin kernel: audit(1108875698.438:0): avc: denied { write } for pid=8305 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 Feb 20 02:01:38 ronin last message repeated 13 times Feb 20 02:01:52 ronin su(pam_unix)[8056]: session closed for user postgres" I have: kernel-2.6.10-1.766_FC3 libselinux-1.19.1-8 libselinux-devel-1.19.1-8 selinux-policy-targeted-1.17.30-2.80 postgresql-7.4.7-1.FC3.2 postgresql-libs-7.4.7-1.FC3.2 postgresql-server-7.4.7-1.FC3.2 TIA, Vinicius.