Re: Binding Postgres to port 0 for testing

From: Thorsten Glaser <tg(at)evolvis(dot)org>
To: Markus Pilman <markus(at)pilman(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Binding Postgres to port 0 for testing
Date: 2023-03-25 18:03:00
Message-ID: bf4adb88-a0f5-635e-e778-c97ff8f31a91@evolvis.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Markus,

>I am building a simple integration test framework for an application that I
>am building. For this project I am planning to use PostgreSQL.

check pg_virtualenv(1), which apparently is a Debian thing.
It auto-creates and auto-deletes at the end, if desired, a
cluster and runs your program with suitable environment
variables to access that cluster, which includes choosing
an available port. This was in fact made for integration
testing, though I use it for quickly spinning up throwaway
DBs for one-shot tools as well.

bye,
//mirabilos
--
Infrastrukturexperte • tarent solutions GmbH
Am Dickobskreuz 10, D-53121 Bonn • http://www.tarent.de/
Telephon +49 228 54881-393 • Fax: +49 228 54881-235
HRB AG Bonn 5168 • USt-ID (VAT): DE122264941
Geschäftsführer: Dr. Stefan Barth, Kai Ebenrett, Boris Esser, Alexander Steeg

****************************************************
/⁀\ The UTF-8 Ribbon
╲ ╱ Campaign against Mit dem tarent-Newsletter nichts mehr verpassen:
 ╳  HTML eMail! Also, https://www.tarent.de/newsletter
╱ ╲ header encryption!
****************************************************

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2023-03-25 18:10:19 Re: Binding Postgres to port 0 for testing
Previous Message Markus Pilman 2023-03-25 17:01:33 Binding Postgres to port 0 for testing