Thread: Running Installcheck remotely
Hi,
Is it possible to run installcheck (pg_regress) tests from a remote host ?
Thanks,
Kapil.
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
Attachment
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
So this means that the host running the test should have capability to SSH to the DB Instance host ?
Thanks,
Kapil.
On Sat, Mar 24, 2018 at 7:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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