Postgresql server in aws.f.o

[Stephen John Smoogen]

Hi.
In Copr we use postgresql on copr-frontend. I decide that it is time to
split it off to separate server. I am going to
create new machine in AWS and deploy postgresql there. I have several open
* is there interest in having it as general sql server in AWS datacenter
for some other fedora-infra projects? Or
should I not bother about it and just keep it for Copr?

I would keep it just for COPR. I think we would prefer to have all our
databases be a single server for auditing, cleanup and downtime. Having
combined postgreses like db01/db03 have been nothing but a pain. We have no
DBA in our group so tuning and such for different needs is not something we
know how to do correctly versus caveman hack style.

* I plan to reuse roles/postgresql_server for that - any issue with this?
* if the server will be open for other Fedora project (first question)
should I amend
playbooks/groups/postgresql-server.yml or should I rather create new
playbook?
* I would love to run the server on RHEL 8. That should be completely
fine according to
https://www.redhat.com/en/blog/extending-no-cost-red-hat-enterprise-linux-open-source-organizations
do we have stored somewhere role or credentials which configure
subscription-manager?

No we are not using this program. The various CentOS/Fedora/etc
organizations come under different legal parameters because we are not
'independent' of Red Hat.

* I plan to use arm64 for that server - mostly because I can and it can
be fun :) (and it is a bit cheaper) - any
issue with this?

And another reason why it should be just for your server :).. you can run
what you want and need versus worry what anyone else wants.

--
Miroslav Suchy, RHCA
Red Hat, Associate Manager, Community Packaging Tools, #brno,
#fedora-buildsys
_______________________________________________
To unsubscribe send an email to
https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
https://pagure.io/fedora-infrastructure

[Miroslav Suchý]

  * I would love to run the server on RHEL 8. That should be completely fine according to
https://www.redhat.com/en/blog/extending-no-cost-red-hat-enterprise-linux-open-source-organizations
<https://www.redhat.com/en/blog/extending-no-cost-red-hat-enterprise-linux-open-source-organizations>
   do we have stored somewhere role or credentials which configure subscription-manager?
No we are not using this program. The various CentOS/Fedora/etc
organizations come under different legal parameters because we are not
'independent' of Red Hat.

: RHEL for Open Source Infrastructure extends Red Hat’s existing support for open source
: * Fedora for driving leading-edge development of Linux operating system improvements and enhancements.

You are misreading that.
The "RHEL for Open Source Infrastructure" program extends/adds to the
existing os choices people can make of Fedora or CentOS Stream.
ie, this is another choice for people who were considering running
Fedora or CentOS stream.

Now, when I am reading it for 10th time, it seems that you are right. But:

"""
Eligibility for RHEL for Open Source Infrastructure subscriptions

This program is available exclusively to open source projects and other organizations that support the production of
open source software. Generally, all software distributed under a Fedora-approved license is considered open source for
the purposes of this program.
"""

And Fedora seems to be eligible to me (if I am reading it correctly).


--
Miroslav Suchy, RHCA
Red Hat, Associate Manager, Community Packaging Tools, #brno, #fedora-buildsys
_______________________________________________
infrastructure mailing list -- ***@lists.fedoraproject.org
To unsubscribe send an email to infrastructure-***@lists.fedoraproject.org
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/***@lists.fedoraproject.org
Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructur

[Kevin Fenzi]

Yeah, it's not all that clearly worded. ;(

Post by Miroslav Suchý
"""
Eligibility for RHEL for Open Source Infrastructure subscriptions
This program is available exclusively to open source projects and other
organizations that support the production of open source software.
Generally, all software distributed under a Fedora-approved license is
considered open source for the purposes of this program.
"""
And Fedora seems to be eligible to me (if I am reading it correctly).

Sure, it might be. We haven't reached out to ask since we predate this
program by 15 years or so. :)

We have to mirror rhel content anyhow to build EPEL against, so we have
just used that mirrored content (carefully blocked off from leaking
anywhere) for our rhel servers.

kevin

[Kevin Fenzi]

Post by Stephen John Smoogen

Hi.
In Copr we use postgresql on copr-frontend. I decide that it is time to
split it off to separate server. I am going to
create new machine in AWS and deploy postgresql there. I have several open
* is there interest in having it as general sql server in AWS datacenter
for some other fedora-infra projects? Or
should I not bother about it and just keep it for Copr?

I would keep it just for COPR. I think we would prefer to have all our
databases be a single server for auditing, cleanup and downtime. Having
combined postgreses like db01/db03 have been nothing but a pain. We have no
DBA in our group so tuning and such for different needs is not something we
know how to do correctly versus caveman hack style.

Agree.

Post by Stephen John Smoogen

* I plan to reuse roles/postgresql_server for that - any issue with this?

Nope. Should work fine I would think/hope.

Post by Stephen John Smoogen

* if the server will be open for other Fedora project (first question)
should I amend
playbooks/groups/postgresql-server.yml or should I rather create new
playbook?
* I would love to run the server on RHEL 8. That should be completely
fine according to
https://www.redhat.com/en/blog/extending-no-cost-red-hat-enterprise-linux-open-source-organizations
do we have stored somewhere role or credentials which configure
subscription-manager?

No we are not using this program. The various CentOS/Fedora/etc
organizations come under different legal parameters because we are not
'independent' of Red Hat.

Right. So you should be able to use a RHEL ami, then setup the repos to
use infrastructure.fedoraproject.org for packages/updates.

Note also that we are using postgresql 12 for rhel8 currently.
(There's different modules available)

Post by Stephen John Smoogen

* I plan to use arm64 for that server - mostly because I can and it can
be fun :) (and it is a bit cheaper) - any
issue with this?

And another reason why it should be just for your server :).. you can run
what you want and need versus worry what anyone else wants.

Yeah, I would sure hope this would just work fine, but let us know if
you run into any problems. :)

kevin