Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0283F633BC8 for ; Tue, 4 Aug 2009 22:16:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 79375-07 for ; Wed, 5 Aug 2009 01:15:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 3C494632E8E for ; Tue, 4 Aug 2009 22:16:07 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n751G2dB025960; Tue, 4 Aug 2009 21:16:03 -0400 (EDT) To: Venkateswara Rao Bondada cc: Rob Sargent , "pgsql-sql@postgresql.org" Subject: Re: Create table command fails with permission denied In-reply-to: <22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com> References: <22640DE58AF78445BA8AB69FF76F07321AA2C20BAB@BLRKECMBX01.ad.infosys.com> <4A775E91.4090608@gmail.com> <22640DE58AF78445BA8AB69FF76F07321AA2C2100A@BLRKECMBX01.ad.infosys.com> Comments: In-reply-to Venkateswara Rao Bondada message dated "Tue, 04 Aug 2009 13:41:29 +0530" Date: Tue, 04 Aug 2009 21:16:02 -0400 Message-ID: <25959.1249434962@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.271 tagged_above=-10 required=5 tests=AWL=1.328, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/15 X-Sequence-Number: 32924 Venkateswara Rao Bondada writes: > camd=# \c cms postgres > You are now connected to database "cms" as user "postgres". > cms=# create table test(id character varying(80)); > ERROR: could not create relation "test": Permission denied Actually, what that is complaining about is that the operating system refused its attempt to create a filesystem file to hold the table. It's got nothing to do with permissions inside the database --- there is something wrong with the filesystem permissions of the data directory. Or maybe you started the postmaster as the wrong user (not the one that owns the data directory). regards, tom lane