public inbox for [email protected]help / color / mirror / Atom feed
Containerizing PostgreSQL 3+ messages / 3 participants [nested] [flat]
* Containerizing PostgreSQL @ 2024-07-22 06:01 Cainzos Yvan <[email protected]> 2024-08-20 01:34 ` Re: Containerizing PostgreSQL Bruce Momjian <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Cainzos Yvan @ 2024-07-22 06:01 UTC (permalink / raw) To: Pgsql-admin <[email protected]> Dear All, What is your experience with containerizing PostgreSQL, particularly on OpenShift? I am looking to identify the advantages and disadvantages of this type of architecture, mainly from an operational standpoint. I am interested in preferred use cases and those to be avoided. Thank you for sharing your experience. Best regards. Yvan Cainzos ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Containerizing PostgreSQL 2024-07-22 06:01 Containerizing PostgreSQL Cainzos Yvan <[email protected]> @ 2024-08-20 01:34 ` Bruce Momjian <[email protected]> 2024-08-20 02:45 ` Re: Containerizing PostgreSQL Ron Johnson <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Bruce Momjian @ 2024-08-20 01:34 UTC (permalink / raw) To: Cainzos Yvan <[email protected]>; +Cc: Pgsql-admin <[email protected]> On Mon, Jul 22, 2024 at 06:01:46AM +0000, Cainzos Yvan wrote: > Dear All, > > > > What is your experience with containerizing PostgreSQL, particularly on > OpenShift? > > I am looking to identify the advantages and disadvantages of this type of > architecture, mainly from an operational standpoint. > > I am interested in preferred use cases and those to be avoided. > > Thank you for sharing your experience. This presentation might be helpful, and its videos: https://momjian.us/main/presentations/administration.html#cloud -- Bruce Momjian <[email protected]> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Containerizing PostgreSQL 2024-07-22 06:01 Containerizing PostgreSQL Cainzos Yvan <[email protected]> 2024-08-20 01:34 ` Re: Containerizing PostgreSQL Bruce Momjian <[email protected]> @ 2024-08-20 02:45 ` Ron Johnson <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Ron Johnson @ 2024-08-20 02:45 UTC (permalink / raw) To: Pgsql-admin <[email protected]> On Mon, Aug 19, 2024 at 9:34 PM Bruce Momjian <[email protected]> wrote: > On Mon, Jul 22, 2024 at 06:01:46AM +0000, Cainzos Yvan wrote: > > Dear All, > > > > > > > > What is your experience with containerizing PostgreSQL, particularly on > > OpenShift? > > > > I am looking to identify the advantages and disadvantages of this type of > > architecture, mainly from an operational standpoint. > > > > I am interested in preferred use cases and those to be avoided. > > > > Thank you for sharing your experience. > > This presentation might be helpful, and its videos: > > https://momjian.us/main/presentations/administration.html#cloud > > https://www.youtube.com/watch?v=wKJBpcoRAsc#t=1h26m46s The important bits start here, I think. Distilled: 1. Do you have an existing VM infrastructure, like VMware? 2a. Do you *frequently* create new PG instances? 2b. Do you have *hundreds* of PG instances? For me, the answers are "yes" and "no,no". I've got a "design document" and common config files in a shared directory. Need a new PG server? I give a standard list of mount points and port numbers to the VM build team, and they come back with a server that has RHEL installed, and ports open. "yum install" a set of RPMs from PGDG. Five minutes later, I sudo to postgres, cp config file templates and run some sed commands. Up comes PG! Patching happens every three months; yum and bash scripts which I've developed over time make that pretty darned fast and painless. Thus, PG containers are of no use *to us*. Lots of application containers, but that's outside my domain. -- Death to America, and butter sauce. Iraq lobster! ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-20 02:45 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-22 06:01 Containerizing PostgreSQL Cainzos Yvan <[email protected]> 2024-08-20 01:34 ` Bruce Momjian <[email protected]> 2024-08-20 02:45 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox