Re: Revoke "drop database" even for superusers?

On Sun, 2012-12-02 at 08:09 -0200, Edson Richter wrote:
> 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.
>

OK, so you're using RPMs. So you need a package called
postgresql92-devel-9.2.1. For example, on a CentOS 5, with the 9.2
release, you'll need
http://yum.postgresql.org/9.2/redhat/rhel-5-x86_64/repoview/postgresql92-devel.html.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com