Re: Revoke "drop database" even for superusers?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Revoke "drop database" even for superusers?
Date: 2012-12-02 10:09:35
Message-ID: BLU0-SMTP4136D7615B151597B089084CF410@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 02/12/2012 07:53, Guillaume Lelarge escreveu:
> On Sun, 2012-12-02 at 10:32 +0530, Pavan Deolasee wrote:
>> On Sun, Dec 2, 2012 at 7:53 AM, Edson Richter <edsonrichter(at)hotmail(dot)com>wrote:
>>
>>> Em 01/12/2012 22:22, Chris Angelico escreveu:
>>>
>>> On Sun, Dec 2, 2012 at 10:20 AM, Edson Richter <edsonrichter(at)hotmail(dot)com>
>>>> wrote:
>>>>
>>>>> I've put both files in ~/deny_drop folder, and executed "make":
>>>>>
>>>>> # LANG=C make
>>>>> Makefile:13: ../../src/Makefile.global: No such file or directory
>>>>> Makefile:14: /contrib/contrib-global.mk: No such file or directory
>>>>> make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
>>>>>
>>>> The most common thing to do before running 'make' is to look for a
>>>> configure script:
>>>>
>>>> $ ./configure
>>>> $ make
>>>>
>>>> ChrisA
>>>>
>>>>
>>>> Yes, that was my first tought. But there is no configure script in the
>>> folder.
>>> Must be something else...
>>>
>>>
>> While I haven't looked at the code, the error message looks very similar to
>> what you will see while building contrib modules. So try this:
>>
>> $ export USE_PGXS=1
>> $ export PATH=$path_to_your_pg_config$:$PATH
>>
>> Set the PATH so that the correct pg_config command is used. It must come
>> from the same installation that your server is running.
>>
>> $ make clean
>> $ make
>> $ make install
>>
> Yeah, you need to use the USE_PGXS environment variable. You also need
> the pg_config tool and PostgreSQL header files which should be available
> if you install the -devel package of your distribution.
>
> What distribution are you on?
>
Centos 5.8, Centos 6.3 - both 64bit.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2012-12-02 10:31:55 Re: Revoke "drop database" even for superusers?
Previous Message Guillaume Lelarge 2012-12-02 09:53:00 Re: Revoke "drop database" even for superusers?