Download M4 Source Macro Index Page

ms_pgsql_priv_root

Synopsis

MS_PGSQL_PRIV_ROOT(DB, USER, [HOST], [PASSWORD], [ACTION_IF_FAILED], [ACTION_IF_OK])

Description

This macro checks wether the given PostgreSQL user has root privileges (can create and drop databases) It is recommended to first call MS_CHECK_PGSQL_DB, this makes it easier to locate the cause of error. The macro MS_PROG_PGCLIENT is required by this one.

The variable $pgclient_root_call is set for later use in Makefiles, if you'd like to make use of this, you must do

    AC_SUBST(pgclient_root_call)

after having called MS_CHECK_PGSQL_PRIV_ROOT. You can then do something like the following in your Makefile.am:

    @pgclient_root_call@ -f file.sql

If you want the user to set the data, you should support something like these configure options:

    AC_ARG_WITH(pgsql-host,
            [  --with-pgsql-host=HOST               server is running on HOST @<:@local socket@:>@],
            [pg_host=$withval], [pg_host=])

    AC_ARG_WITH(pgsql-db,
            [  --with-pgsql-db=DBNAME               use database DBNAME @<:@test@:>@],
            [pg_db=$withval], [pg_db=test])

    AC_ARG_WITH(pgsql-root-user,
            [  --with-pgsql-root-user=USER          use user USER, must have root (all) privileges @<:@postgres@:>@],
            [pg_root_user=$withval], [pg_root_user=postgres])

    AC_ARG_WITH(pgsql-password,
            [  --with-pgsql-password=PASSWORD       use password PASSWORD @<:@none@:>@],
            [pg_password=$withval], [pg_password=""])

You can then call the macro like this:

    MS_CHECK_PGSQL_PRIV_ROOT([$pg_db], [$pg_root_user], [$pg_host], [$pg_password], [AC_MSG_ERROR([We need root privileges on database!])])

Author

Moritz Sinn <moritz@freesources.org>

Last Modified

2002-09-25

M4 Source Code

AC_DEFUN([MS_CHECK_PGSQL_PRIV_ROOT], [
AC_REQUIRE([MS_PROG_PGCLIENT])dnl
AC_REQUIRE([MS_CHECK_PGSQL_DB])dnl
AC_MSG_CHECKING([if PostgreSQL user $2 has root privileges])

pgclient_root_call="$pgclient"

if test "x$1" != "x"; then
        pgclient_root_call="$pgclient_root_call dbname=$1";
fi
if test "x$2" != "x"; then
        pgclient_root_call="$pgclient_root_call user=$2";
fi
if test "x$3" != "x"; then
        pgclient_root_call="$pgclient_root_call host=$3";
fi
if test "x$4" != "x"; then
        pgclient_root_call="$pgclient_root_call password=$4";
fi

testdb="test`date +%s`"
echo "CREATE DATABASE $testdb; DROP DATABASE $testdb;" | $pgclient_root_call  > /dev/null 2>&1
if test "x$?" = "x0"; then
        AC_MSG_RESULT([yes])
        $6
else
        AC_MSG_RESULT([no])
        $5
fi;
])dnl