testgres

What's Changed

• Add pg_upgrade option by @demonolock (#97)
  This function allows upgrade PostgreSQL versions.
• Remove unnecessary output by @homper (#88)
• Fix get_pg_version for Linux Mint by @demonolock (#101)
• Set default test locale to en by @Ogurezzz (#107)
  This change aims to standardize test outputs.
• Fix Error during executing query by @z-kasymalieva (#110)
  Resolved an issue related to executing queries within the framework, particularly when executing commands that do not produce row output, which previously resulted in errors.
• Run the archive command through exec by @asavchkov (#113)
  If the PostgreSQL archive command is run through the dash shell the shell produces a core dump upon receiving a SIGQUIT during the PostgreSQL server shutdown. This change replaces the dash process with pg_probackup to avoid the production of a core dump.

New Contributors

• @homper made their first contribution in https://github.com/postgrespro/testgres/pull/88
• @z-kasymalieva made their first contribution in https://github.com/postgrespro/testgres/pull/105
• @Ogurezzz made their first contribution in https://github.com/postgrespro/testgres/pull/107

Full Changelog: https://github.com/postgrespro/testgres/compare/1.9.3...1.10.0

• Fixed a problem on MacOS with command --version
• Fixed problems on Windows

• Removed sshtunnel and fabric libraries usage

• Removed paramiko library usage

• Added the ability to create PostgreSQL nodes on remote hosts via SSH. All local commands, such as directory creation and file reading, have been moved to the LocalOperations class. Remote commands are now housed in the RemoteOperations class. The class is selected depending on the parameters passed to PostgresNode.

• Introducing support for specific PostgreSQL versions

• Minor enhancements in test syntax

.

And revert cdc933ff4af.

Small fix: PostgresNode.safe_psql() now raises error on wrong input (issue #52).

Small fix: make NodeBackup aware of inheritors of PostgresNode.

• Add suppress option to PostgresNode.poll_query_until() (PR #51);
• Add format option to PostgresNode.dump() (PR #32);
• Add promote() method to PostgresNode (PR #47);
• Add version property to PostgresNode (PR #49);
• Add support for logical replication (PR #42);

• Add wait option to PostgresNode.start() (PR #45);
• PostgresNode.reload() now returns self;
• Add support for replication slots (PR #41);

• New dependency: psutil;

• New properties:

  • child_processes - list of ProcessProxy objects representing PostgreSQL processes,
  • auxiliary_processes - subset of child_processes, represents auxiliary processes (e.g. autovacuum),
  • auxiliary_pids - dict of { ProcessType : PID } pairs,
  • source_walsender - available on replica: represents master's walsender;

• New context manager scoped_config(): temporary change GlobalConfig;

• Testgres is able to provide unique system ids for cached instances (see #35);

• Temp dirs use tgs_ as prefix;

• Improved pgbench API (see pgbench_run() etc);
• Set allow_streaming=True in init() and default_conf() by default;
• New option unix_sockets=True in init() and default_conf();
• Fixed base_dir ignore if provided base_dir does not exist (#31);
• StartNodeException now includes last N lines of postgresql.log;
• Improved exception handling (using six.raise_from);
• Auto name generation for PostgresNode (see generate_app_name);
• Provide compatibility mode for execute(), psql(), safe_psql() and poll_query_until() methods (see positional_args_hack);

apply --auth-local and --auth-host params passed to initdb in PostgresNode.init();

• use max_attempts=0 (infinite) by default in poll_query_until();
• fix support for utf-8 (non-ascii symbols);
• improved error handling;
• don't install enum34 on python 3.4+.

• introduced default_conf();
• don't remove base_dir if it was provided by user;

• introduced TestgresConfig;
• add log_statement='all' parameter to default_conf();