Re: Revoke "drop database" even for superusers? - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Revoke "drop database" even for superusers?
Date
Msg-id 1354444315.4185.7.camel@localhost.localdomain
Whole thread Raw
In response to Re: Revoke "drop database" even for superusers?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
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@hotmail.com>wrote:
> >>
> >>> Em 01/12/2012 22:22, Chris Angelico escreveu:
> >>>
> >>>   On Sun, Dec 2, 2012 at 10:20 AM, Edson Richter <edsonrichter@hotmail.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



pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Revoke "drop database" even for superusers?
Next
From: ivan marchesini
Date:
Subject: Re: difference in query performance due to the inclusion of a polygon geometry field