CODEWITHSUNDEEP
postgresql
user1424966
user1424966

Reputation:

How to create Postgres regression test database

The Postgres documentation for the EXPLAIN command states that

Examples in this section are drawn from the regression test database after doing a VACUUM ANALYZE, using 9.3 development sources. You should be able to get similar results if you try the examples yourself (...)

How do I set up the regression test database?

Upvotes: 4

Views: 1233

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246013

The documentation is here.

You ./configure and make install the PostgreSQL software, then create a database cluster with initdb.

Then you set PGPORT and PGUSER (if you want something nonstandard) and run

make installcheck

for the regular test suite or

make installcheck-world

for the extended test suite.

After that, you'll have a new database called regression with all kinds of objects created by the tests, which can be useful for testing.

Upvotes: 5

Related Questions