[FOLIO-1036] Modules for postgres configuration Created: 18/Jan/18  Updated: 09/Nov/22  Resolved: 09/Nov/22

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: New Feature Priority: P3
Reporter: Heikki Levanto Assignee: Heikki Levanto
Resolution: Won't Do Votes: 0
Labels: core, spri30
Remaining Estimate: Not Specified
Time Spent: 1 day
Original estimate: Not Specified

Issue links:
Relates
relates to OKAPI-590 Embedded postgres mode Closed
Sprint:
Development Team: Core: Platform

 Description   

Starting an "embedded" postgres for each module does not really work. Create a module that starts the embedded postgres, and sets the env variables to point to it, so any other module starting after it will automatically use the embedded postgres.

Likewise, create a module to use an existing Postgres on the cluster. Naturally it needs configuration info somewhere, but we have a config system for that.

Finally, create one more module that provides the postgres interface, that sets the env to default configuration on localhost.



 Comments   
Comment by Julian Ladisch [ 18/Jan/18 ]

Similar functionality: https://github.com/folio-org/raml-module-builder/tree/master/postgres-runner

Comment by Heikki Levanto [ 18/Jan/18 ]

The idea is to have a separate module to be used while developing. This module will start the "embedded" postgres and set the environment variables so that any other module that can read the environment (which includes all RMB modules), will see this "embedded" pg and automagically use that one.

This differs from the "use-embedded-postgres" option of RMB in that we start only one postgres, and all modules can use that, instead of each module needing to start its own, which can take 10 seconds, and either need its own config file, or a separate port number, etc.

Later, we can make other modules that provide the same interface, and set up the environment differently, for example to use the default Pg configuration on localhost, if you want a persistent database...

Comment by Heikki Levanto [ 08/May/18 ]

Okapi-590 suggests an altrernative approach, with Okapi startijg the embedded PG

Comment by Adam Dickmeiss [ 09/Nov/22 ]

Not using embedded postgresql anymore.

Generated at Thu Feb 08 23:10:21 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.