Thread: PostgreSQL on K8 with Operator
Hi All
Greetings.
I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?
Regards,
Sasi
Hi Sasi,
Thank you for reaching out.
You will need to either contact individual companies that provide PostgreSQL services (you can google them or take a look here: https://www.postgresql.org/support/professional_support/) or you can also reach out to the community through Slack (postgresteam.slack.com) or Telegram (https://t.me/pg_sql) channels where individual consultants might be able to help.
We can't recommend a specific operator or comment on their expertise.
Kind regards,
Valeria
Valeria Kaplan
PostgreSQL advocacy
On Tue, Dec 8, 2020 at 3:54 AM SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
Hi AllGreetings.I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?Regards,Sasi
Hello,
Just a question related to the list at: https://www.postgresql.org/support/professional_support/, is there any curation done for this listing?
I just wonder about a list that includes both well-established experts that focus on PostgreSQL (ex. EDB, Crunchy Data, Data Egret, PostgreSQL Experts, etc.) when companies with 1 employee and without a working website are also on that listing (ex. PostgreSQL International). Seems like there should be some basic standards for being listed, for example: you are a registered business, you have more than one employee (ie. you haven't just created a name for your one-person consultancy, there could be a separate listing for independent consultants), you have a working website and up-to-date contact information, you follow PostgreSQL community standards/OSS policies, etc.
There also seem to be a number of companies that would be difficult to categorize as "PostgreSQL specialists" considering the breadth of their work and expertise, ex. Heroku, Savoir-Faire Linux, Web Global Net, Moki Systems, etc. yet they are on that list. This could be the start of a slippery slope.
Personally, I would struggle to pick out a reputable company with real expertise/focus on PostgreSQL from that listing at present, if I did not have any other familiarity with the companies.
Sincerely,
Katie
On Tue, Dec 8, 2020 at 5:19 AM Valeria Kaplan <kaplan.valeria@gmail.com> wrote:
Hi Sasi,Thank you for reaching out.You will need to either contact individual companies that provide PostgreSQL services (you can google them or take a look here: https://www.postgresql.org/support/professional_support/) or you can also reach out to the community through Slack (postgresteam.slack.com) or Telegram (https://t.me/pg_sql) channels where individual consultants might be able to help.We can't recommend a specific operator or comment on their expertise.Kind regards,ValeriaValeria KaplanPostgreSQL advocacyOn Tue, Dec 8, 2020 at 3:54 AM SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:Hi AllGreetings.I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?Regards,Sasi
Just a quick point. It is up to the purchaser of services to vet the services for their needs.
One size does not fit all, especially in this open source community.
Disparaging 1-person business would lose great resources as well as steady income for talented people.
Elein Mustain
elein@varlena.com
510-637-9106
On Dec 8, 2020, at 9:19 AM, Katherine Mcmillan <kmcmi046@uottawa.ca> wrote:
Hello,Just a question related to the list at: https://www.postgresql.org/support/professional_support/, is there any curation done for this listing?I just wonder about a list that includes both well-established experts that focus on PostgreSQL (ex. EDB, Crunchy Data, Data Egret, PostgreSQL Experts, etc.) when companies with 1 employee and without a working website are also on that listing (ex. PostgreSQL International). Seems like there should be some basic standards for being listed, for example: you are a registered business, you have more than one employee (ie. you haven't just created a name for your one-person consultancy, there could be a separate listing for independent consultants), you have a working website and up-to-date contact information, you follow PostgreSQL community standards/OSS policies, etc.There also seem to be a number of companies that would be difficult to categorize as "PostgreSQL specialists" considering the breadth of their work and expertise, ex. Heroku, Savoir-Faire Linux, Web Global Net, Moki Systems, etc. yet they are on that list. This could be the start of a slippery slope.Personally, I would struggle to pick out a reputable company with real expertise/focus on PostgreSQL from that listing at present, if I did not have any other familiarity with the companies.Sincerely,KatieOn Tue, Dec 8, 2020 at 5:19 AM Valeria Kaplan <kaplan.valeria@gmail.com> wrote:Hi Sasi,Thank you for reaching out.You will need to either contact individual companies that provide PostgreSQL services (you can google them or take a look here: https://www.postgresql.org/support/professional_support/) or you can also reach out to the community through Slack (postgresteam.slack.com) or Telegram (https://t.me/pg_sql) channels where individual consultants might be able to help.We can't recommend a specific operator or comment on their expertise.Kind regards,ValeriaValeria KaplanPostgreSQL advocacyOn Tue, Dec 8, 2020 at 3:54 AM SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:Hi AllGreetings.I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?Regards,Sasi
On Tue, Dec 8, 2020 at 6:19 PM Katherine Mcmillan <kmcmi046@uottawa.ca> wrote:
Hello,Just a question related to the list at: https://www.postgresql.org/support/professional_support/, is there any curation done for this listing?
Not beyond that the moderator will verify that they are providing *some* PostgreSQL service when they sign up. There is unfortunately no recurring check of companies if they*still* provide it, they are only validated at signup time.
Jonathan has done one or two big reviews with long intervals in between, but that's not really a sustainable way to handle it either. Getting that fixed with a proper long term solution is definitely on the todo list, just that we haven't figured out exactly what's needed yet.
Hi Magnus,
Thanks for your response. If there is an opportunity for me to be part of the solution, please let me know. I will also chat with Jonathan.
Sincerely,
Katie
On Tue, Dec 8, 2020 at 1:59 PM Magnus Hagander <magnus@hagander.net> wrote:
--On Tue, Dec 8, 2020 at 6:19 PM Katherine Mcmillan <kmcmi046@uottawa.ca> wrote:Hello,Just a question related to the list at: https://www.postgresql.org/support/professional_support/, is there any curation done for this listing?Not beyond that the moderator will verify that they are providing *some* PostgreSQL service when they sign up. There is unfortunately no recurring check of companies if they*still* provide it, they are only validated at signup time.Jonathan has done one or two big reviews with long intervals in between, but that's not really a sustainable way to handle it either. Getting that fixed with a proper long term solution is definitely on the todo list, just that we haven't figured out exactly what's needed yet.
There is a 2-part article that compares operators from Zalando, Crunchy, KubeDB and StackGres.io (unfortunately only in Russian, but Google Translate and its alternatives do job well nowadays)
All of them are being developed very actively, so I recommend defining your own goals and making your own tests (plus, maybe talking to developers on your own needs to see where a good match exists).
On Mon, Dec 7, 2020 at 19:54 SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
Hi AllGreetings.I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?Regards,Sasi
Excellent. Will review this and keep updated about our progress. Is anybody aware of any Production is running with PostgreSQL,K8 and Operator today?
On Wednesday, 9 December, 2020, 04:24:20 am IST, Nikolay Samokhvalov <samokhvalov@gmail.com> wrote:
There is a 2-part article that compares operators from Zalando, Crunchy, KubeDB and StackGres.io (unfortunately only in Russian, but Google Translate and its alternatives do job well nowadays)
All of them are being developed very actively, so I recommend defining your own goals and making your own tests (plus, maybe talking to developers on your own needs to see where a good match exists).
On Mon, Dec 7, 2020 at 19:54 SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
Hi AllGreetings.I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?Regards,Sasi
On Wed, 9 Dec 2020 at 02:12, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
Excellent. Will review this and keep updated about our progress. Is anybody aware of any Production is running with PostgreSQL,K8 and Operator today?
Many people are running on those 3 operators in production
Dave Cramer
www.postgres.rocks
On Wednesday, 9 December, 2020, 04:24:20 am IST, Nikolay Samokhvalov <samokhvalov@gmail.com> wrote:There is a 2-part article that compares operators from Zalando, Crunchy, KubeDB and StackGres.io (unfortunately only in Russian, but Google Translate and its alternatives do job well nowadays)All of them are being developed very actively, so I recommend defining your own goals and making your own tests (plus, maybe talking to developers on your own needs to see where a good match exists).On Mon, Dec 7, 2020 at 19:54 SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:Hi AllGreetings.I am looking for advise of running Postgres in K8 along with Operator. Which Operator will be best for this solution? Is any company running the similar setup in Production?Regards,Sasi
On 2020-12-08 21:19, Valeria Kaplan wrote: > Hi Sasi, > > Thank you for reaching out. > > You will need to either contact individual companies that provide > PostgreSQL services (you can google them or take a look here: > https://www.postgresql.org/support/professional_support/) or you can > also > reach out to the community through Slack (postgresteam.slack.com) or > Telegram (https://t.me/pg_sql) channels where individual consultants > might > be able to help. Looking at that Community Slack just now, it seems to only allow logins by people with specific domains as their email address: * omniti.com * wingspan.com * getchef.com * pgexperts.com * citusdata.com * 8kdata.com * peoplecall.com * enterprisedb.com * nabancard.com * 2ndquadrant.com * circonus.com * postgrespro.ru * openscg.com Guessing it's not (yet?) a channel for general contact from Community members? + Justin > We can't recommend a specific operator or comment on their expertise. > > Kind regards, > Valeria > > Valeria Kaplan > PostgreSQL advocacy
On Wed, Dec 9, 2020 at 12:33 PM Justin Clift <justin@postgresql.org> wrote:
On 2020-12-08 21:19, Valeria Kaplan wrote:
> Hi Sasi,
>
> Thank you for reaching out.
>
> You will need to either contact individual companies that provide
> PostgreSQL services (you can google them or take a look here:
> https://www.postgresql.org/support/professional_support/) or you can
> also
> reach out to the community through Slack (postgresteam.slack.com) or
> Telegram (https://t.me/pg_sql) channels where individual consultants
> might
> be able to help.
Looking at that Community Slack just now, it seems to only allow logins
by people with specific domains as their email address:
* omniti.com
* wingspan.com
* getchef.com
* pgexperts.com
* citusdata.com
* 8kdata.com
* peoplecall.com
* enterprisedb.com
* nabancard.com
* 2ndquadrant.com
* circonus.com
* postgrespro.ru
* openscg.com
Guessing it's not (yet?) a channel for general contact from Community
members?
That sounds very strange.
I'm not an active user of the slack channel, but I definitely have an account there, and I'm definitely not using any of those addresses. And I'm willing to bet there's a large number of users with gmail addresses there...
Hi Justin,
I was able to log in and don't have an email with either of those domains, so pretty sure it is open for all.
There are close to 10k people on it, I doubt they all have emails with those domains.
Valeria
On Wed, Dec 9, 2020 at 11:33 AM Justin Clift <justin@postgresql.org> wrote:
On 2020-12-08 21:19, Valeria Kaplan wrote:
> Hi Sasi,
>
> Thank you for reaching out.
>
> You will need to either contact individual companies that provide
> PostgreSQL services (you can google them or take a look here:
> https://www.postgresql.org/support/professional_support/) or you can
> also
> reach out to the community through Slack (postgresteam.slack.com) or
> Telegram (https://t.me/pg_sql) channels where individual consultants
> might
> be able to help.
Looking at that Community Slack just now, it seems to only allow logins
by people with specific domains as their email address:
* omniti.com
* wingspan.com
* getchef.com
* pgexperts.com
* citusdata.com
* 8kdata.com
* peoplecall.com
* enterprisedb.com
* nabancard.com
* 2ndquadrant.com
* circonus.com
* postgrespro.ru
* openscg.com
Guessing it's not (yet?) a channel for general contact from Community
members?
+ Justin
> We can't recommend a specific operator or comment on their expertise.
>
> Kind regards,
> Valeria
>
> Valeria Kaplan
> PostgreSQL advocacy
On Wed, Dec 9, 2020 at 11:38 AM Valeria Kaplan <kaplan.valeria@gmail.com> wrote:
Hi Justin,I was able to log in and don't have an email with either of those domains, so pretty sure it is open for all.There are close to 10k people on it, I doubt they all have emails with those domains.
Maybe those domains just get automatically approved, whereas others are manual.
ValeriaOn Wed, Dec 9, 2020 at 11:33 AM Justin Clift <justin@postgresql.org> wrote:On 2020-12-08 21:19, Valeria Kaplan wrote:
> Hi Sasi,
>
> Thank you for reaching out.
>
> You will need to either contact individual companies that provide
> PostgreSQL services (you can google them or take a look here:
> https://www.postgresql.org/support/professional_support/) or you can
> also
> reach out to the community through Slack (postgresteam.slack.com) or
> Telegram (https://t.me/pg_sql) channels where individual consultants
> might
> be able to help.
Looking at that Community Slack just now, it seems to only allow logins
by people with specific domains as their email address:
* omniti.com
* wingspan.com
* getchef.com
* pgexperts.com
* citusdata.com
* 8kdata.com
* peoplecall.com
* enterprisedb.com
* nabancard.com
* 2ndquadrant.com
* circonus.com
* postgrespro.ru
* openscg.com
Guessing it's not (yet?) a channel for general contact from Community
members?
+ Justin
> We can't recommend a specific operator or comment on their expertise.
>
> Kind regards,
> Valeria
>
> Valeria Kaplan
> PostgreSQL advocacy
On 2020-12-09 22:52, Dave Page wrote: > On Wed, Dec 9, 2020 at 11:38 AM Valeria Kaplan > <kaplan.valeria@gmail.com> > wrote: > >> Hi Justin, >> >> I was able to log in and don't have an email with either of those >> domains, >> so pretty sure it is open for all. >> There are close to 10k people on it, I doubt they all have emails with >> those domains. > > Maybe those domains just get automatically approved, whereas others are > manual. Hmmm, maybe I'm doing something wrong. Two screenshots attached, to show what I'm seeing. * 01 - the login page (for existing accounts) * 02 - the "create account" page, to create a new account The "create account" page only allows specific domains, though it has a note to "Contact the workspace administrator at Postgres for an invitation." for all others. With no actual link to contact info for the workspace admin. ;) Hmmm, it does have a "Continue with Google" button though, so I guess Google users are able to login too? For me, that's not going to work as Google locked me out of my account when I moved from the UK to Australia. :/ Note that this isn't urgent nor important in any way, I was more checking the Slack out of curiosity and for general awareness. :) + Justin
Attachment
Thanks to Valeria for sending me an invite to the Slack, I've been able to join and chat with the PG Slack owner (@denish, CC'd). It turns out there's a specific page we should be sending new people for joining the PG Slack: https://postgres-slack.herokuapp.com That's an app which generates invites to the PG Slack, and doesn't have a restriction on email address. :) (On a semi-related note, the Go language Slack has an app for the same thing. Seems a fairly standard approach for larger sized Slacks these days.) + Justin On 2020-12-09 23:26, Valeria Kaplan wrote: > Apologies, I thought it was a separate button for a generic email not > from > the domain list. > It might be a good idea to check with Slack admins (not sure who that > is) > to check what they had in mind when restricting number of domains for > that > channel. Will try to find out. > > On Wed, Dec 9, 2020 at 12:24 PM Valeria Kaplan <vk@dataegret.com> > wrote: > >> hmm. I've probably used the Google button when first signed in. >> and what happens if you "continue with email"? >> >> On Wed, Dec 9, 2020 at 12:14 PM Justin Clift <justin@postgresql.org> >> wrote: >> >>> On 2020-12-09 22:52, Dave Page wrote: >>> > On Wed, Dec 9, 2020 at 11:38 AM Valeria Kaplan >>> > <kaplan.valeria@gmail.com> >>> > wrote: >>> > >>> >> Hi Justin, >>> >> >>> >> I was able to log in and don't have an email with either of those >>> >> domains, >>> >> so pretty sure it is open for all. >>> >> There are close to 10k people on it, I doubt they all have emails with >>> >> those domains. >>> > >>> > Maybe those domains just get automatically approved, whereas others are >>> > manual. >>> >>> Hmmm, maybe I'm doing something wrong. Two screenshots attached, to >>> show >>> what I'm seeing. >>> >>> * 01 - the login page (for existing accounts) >>> * 02 - the "create account" page, to create a new account >>> >>> The "create account" page only allows specific domains, though it has >>> a >>> note to "Contact the workspace administrator at Postgres for an >>> invitation." >>> for all others. With no actual link to contact info for the >>> workspace >>> admin. ;) >>> >>> Hmmm, it does have a "Continue with Google" button though, so I guess >>> Google users are able to login too? For me, that's not going to work >>> as >>> Google locked me out of my account when I moved from the UK to >>> Australia. :/ >>> >>> Note that this isn't urgent nor important in any way, I was more >>> checking >>> the Slack out of curiosity and for general awareness. :) >>> >>> + Justin
aha!
Thank you, Justin
On Wed, Dec 9, 2020 at 1:18 PM Justin Clift <justin@postgresql.org> wrote:
Thanks to Valeria for sending me an invite to the Slack, I've been able
to
join and chat with the PG Slack owner (@denish, CC'd).
It turns out there's a specific page we should be sending new people for
joining the PG Slack:
https://postgres-slack.herokuapp.com
That's an app which generates invites to the PG Slack, and doesn't have
a
restriction on email address. :)
(On a semi-related note, the Go language Slack has an app for the same
thing. Seems a fairly standard approach for larger sized Slacks these
days.)
+ Justin
On 2020-12-09 23:26, Valeria Kaplan wrote:
> Apologies, I thought it was a separate button for a generic email not
> from
> the domain list.
> It might be a good idea to check with Slack admins (not sure who that
> is)
> to check what they had in mind when restricting number of domains for
> that
> channel. Will try to find out.
>
> On Wed, Dec 9, 2020 at 12:24 PM Valeria Kaplan <vk@dataegret.com>
> wrote:
>
>> hmm. I've probably used the Google button when first signed in.
>> and what happens if you "continue with email"?
>>
>> On Wed, Dec 9, 2020 at 12:14 PM Justin Clift <justin@postgresql.org>
>> wrote:
>>
>>> On 2020-12-09 22:52, Dave Page wrote:
>>> > On Wed, Dec 9, 2020 at 11:38 AM Valeria Kaplan
>>> > <kaplan.valeria@gmail.com>
>>> > wrote:
>>> >
>>> >> Hi Justin,
>>> >>
>>> >> I was able to log in and don't have an email with either of those
>>> >> domains,
>>> >> so pretty sure it is open for all.
>>> >> There are close to 10k people on it, I doubt they all have emails with
>>> >> those domains.
>>> >
>>> > Maybe those domains just get automatically approved, whereas others are
>>> > manual.
>>>
>>> Hmmm, maybe I'm doing something wrong. Two screenshots attached, to
>>> show
>>> what I'm seeing.
>>>
>>> * 01 - the login page (for existing accounts)
>>> * 02 - the "create account" page, to create a new account
>>>
>>> The "create account" page only allows specific domains, though it has
>>> a
>>> note to "Contact the workspace administrator at Postgres for an
>>> invitation."
>>> for all others. With no actual link to contact info for the
>>> workspace
>>> admin. ;)
>>>
>>> Hmmm, it does have a "Continue with Google" button though, so I guess
>>> Google users are able to login too? For me, that's not going to work
>>> as
>>> Google locked me out of my account when I moved from the UK to
>>> Australia. :/
>>>
>>> Note that this isn't urgent nor important in any way, I was more
>>> checking
>>> the Slack out of curiosity and for general awareness. :)
>>>
>>> + Justin
On 12/9/20 9:23 AM, Valeria Kaplan wrote: > aha! > that's good to know. > Thank you, Justin > > On Wed, Dec 9, 2020 at 1:18 PM Justin Clift <justin@postgresql.org > <mailto:justin@postgresql.org>> wrote: > > Thanks to Valeria for sending me an invite to the Slack, I've been able > to > join and chat with the PG Slack owner (@denish, CC'd). > > It turns out there's a specific page we should be sending new people for > joining the PG Slack: > > https://postgres-slack.herokuapp.com > <https://postgres-slack.herokuapp.com> > > That's an app which generates invites to the PG Slack, and doesn't have > a > restriction on email address. :) When checking the website[1] it appears that we link to that URL. Is it appearing somewhere else on the website where it is not being linked to that signup form? Thanks, Jonathan [1] https://www.postgresql.org/community/
Attachment
I've sent the incorrect link to Sasi by copying it from the Slack channel directly (since I'm on it).
So guess that's not an issue, unless somebody else does the same as I did and sends the link to a person who doesn't have gmail or a listed domain.
The chances are quite slim though, I think.
On Wed, Dec 9, 2020 at 2:26 PM Jonathan S. Katz <jkatz@postgresql.org> wrote:
On 12/9/20 9:23 AM, Valeria Kaplan wrote:
> aha!
> that's good to know.
> Thank you, Justin
>
> On Wed, Dec 9, 2020 at 1:18 PM Justin Clift <justin@postgresql.org
> <mailto:justin@postgresql.org>> wrote:
>
> Thanks to Valeria for sending me an invite to the Slack, I've been able
> to
> join and chat with the PG Slack owner (@denish, CC'd).
>
> It turns out there's a specific page we should be sending new people for
> joining the PG Slack:
>
> https://postgres-slack.herokuapp.com
> <https://postgres-slack.herokuapp.com>
>
> That's an app which generates invites to the PG Slack, and doesn't have
> a
> restriction on email address. :)
When checking the website[1] it appears that we link to that URL. Is it
appearing somewhere else on the website where it is not being linked to
that signup form?
Thanks,
Jonathan
[1] https://www.postgresql.org/community/
On 2020-12-10 03:35, Stephen Frost wrote: <snip> > ... should we really be sending people to such a herokuapp site to sign > up? Seems like something we could probably manage to make part of > pg.org, and really should.. Denish seems to be on the PG Advocacy mailing list now, and is CC-d anyway. So it probably wouldn't be too hard to move to PG infrastructure hosting. :) > Not sure if there's a way for the slack admin to change the URL that > folks on the slack channel see, but if so, that'd be nice to change > too, > so that there isn't this confusion in the future. Also seems unlikely > that we need to have that list of domains be associated with the > community slack...? Also leads to confusion. You mean the "postgresteam.slack.com" domain name? That kind of thing is pretty standard for Slack, and the "postgresteam" name seem on topic enough to be ok (to me). :) The list-of-domains thing sounds like it might be fixable in a month or two once the new Salesforce ownership of Slack has settled a bit more. :) + Justin