Обсуждение: (Perl) script to set up an instance for regression tests

For regression tests, I'd like to automatically set up a fresh
PostgreSQL instance.  Has anybody automated the task (initdb, setting
a password, choosing a port at random, starting the server, and after
running the tests, stopping the server and deleting all the
directories)?  I know, it's a straightforward Perl script, but perhaps
someone else has already written it. 8-)

And:

$ fakeroot /usr/lib/postgresql/8.1/bin/postgres -D . postgres
"root" execution of the PostgreSQL server is not permitted.
[...]

This is a major problem when autobuilding Debian packages. 8-(

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

Florian Weimer <fweimer@bfk.de> writes:
> For regression tests, I'd like to automatically set up a fresh
> PostgreSQL instance.  Has anybody automated the task (initdb, setting
> a password, choosing a port at random, starting the server, and after
> running the tests, stopping the server and deleting all the
> directories)?

"make check"?

> $ fakeroot /usr/lib/postgresql/8.1/bin/postgres -D . postgres
> "root" execution of the PostgreSQL server is not permitted.
> This is a major problem when autobuilding Debian packages. 8-(

Surely you don't build random packages as root.

            regards, tom lane

* Tom Lane:

> Florian Weimer <fweimer@bfk.de> writes:
>> For regression tests, I'd like to automatically set up a fresh
>> PostgreSQL instance.  Has anybody automated the task (initdb, setting
>> a password, choosing a port at random, starting the server, and after
>> running the tests, stopping the server and deleting all the
>> directories)?
>
> "make check"?

Ah, pg_regress.sh is indeed a good start.  Silly me.  Thanks.

>> $ fakeroot /usr/lib/postgresql/8.1/bin/postgres -D . postgres
>> "root" execution of the PostgreSQL server is not permitted.
>> This is a major problem when autobuilding Debian packages. 8-(
>
> Surely you don't build random packages as root.

It's just fakeroot, a user-space emulation of UID=0, using pre-loaded
dynamic shared objects.  Although "fakeroot id -u" returns "0", you
cannot actually execute any operations that require privileges you
haven't got.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99