Обсуждение: Running Installcheck remotely

On Sat, Mar 24, 2018 at 01:02:47AM -0700, Kapil Sharma wrote:
> Is it possible to run installcheck (pg_regress) tests from a remote
> host?

You can use EXTRA_REGRESS_OPTS to pass a custom set of options to
pg_regress, say:
EXTRA_REGRESS_OPTS='--host=remote_ip' make installcheck
You can use as well a custom port with --port
--
Michael

Kapil Sharma <kapil.bncoe@gmail.com> writes:
> Is it possible to run installcheck (pg_regress) tests from a remote host ?

I think if you set PGHOST and other relevant libpq environment variables,
an installcheck run will connect where they specify.  The hard part would
be making sure that (a) your test files match the remote server's version
and (b) the various .so files loaded by the tests exist on the remote host
at the same filesystem locations expected by the tests.

            regards, tom lane

On Tue, Apr 03, 2018 at 09:12:48AM -0700, Kapil Sharma wrote:
> So this means that the host running the test should have capability to SSH
> to the DB Instance host ?

That's not what it means as the whole test will run through libpq.
Please make sure that the files used for the tests match the version of
the server and that all the libraries needed by the tests are installed
on the host where the database is running.
--
Michael