Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Testing a DB installed on remote host #39

Open
qakapil opened this issue Mar 7, 2018 · 5 comments
Open

Testing a DB installed on remote host #39

qakapil opened this issue Mar 7, 2018 · 5 comments
Labels

Comments

@qakapil
Copy link

@qakapil qakapil commented Mar 7, 2018

Hi,

This is not an issue but just a quick question about the tool. Can I use testgres to test a DB cluster installed on remote host ?

Thanks,
Kapil.

@funbringer funbringer added the question label Mar 7, 2018
@funbringer
Copy link
Collaborator

@funbringer funbringer commented Mar 7, 2018

Hi @qakapil,

Unfortunately, remote hosts are not supported yet. You could create an instance of PostgresNode and change its host, but it won't do you any good: most of its methods would be useless (e.g. start, stop, get_control_data etc).

How would you solve this problem? Perhaps you could give us an idea.

@qakapil
Copy link
Author

@qakapil qakapil commented Mar 8, 2018

Hi @funbringer,
Probably we can pass a flag to skip start/stop methods (assuming the DB Cluster on remote host is already up). I will investigate this and let you know.
I have one more question - Is testgres primarily being used to test Postgres extensions ? Does testgres tests more features which installcheck tests (pg_regress) are not testing ?

Thanks,
Kapil.

@funbringer
Copy link
Collaborator

@funbringer funbringer commented Mar 12, 2018

Is testgres primarily being used to test Postgres extensions ? Does testgres tests more features which installcheck tests (pg_regress) are not testing ?

Currently, yes. For instance, we use it for pg_pathman, pg_shardman, pg_probackup. The main reason is that you can't test streaming replication, sharding, dump/restore etc with linear regression tests.

@funbringer
Copy link
Collaborator

@funbringer funbringer commented Mar 12, 2018

Now that the questions have been answered, I think we should classify this issue as a feature request.

@funbringer funbringer removed the question label Mar 12, 2018
@stalkerg
Copy link
Contributor

@stalkerg stalkerg commented Jan 22, 2020

It should be easy to implement by a library like http://www.paramiko.org/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
You can’t perform that action at this time.