►
From YouTube: Crunchy Data Lighting Talk: The PostgreSQL Operator for OpenShift - Brian Pace (Crunchy Data)
Description
Crunchy Data Lighting Talk: The PostgreSQL Operator for OpenShift - Brian Pace (Crunchy Data)
This OpenShift Commons Gathering was held on July 6, 2022 live in London, England
https://commons.openshift.org
A
All
right
well
good
morning,
crunchy
data
is
just
as
honored
to
be
a
sponsor
of
this
event.
We're
excited
to
get
back
together
with
friends
and
colleagues
and
be
able
to
gather
again
and
look
people
in
the
eyes
in
person.
My
name
is
brian
pace.
I'm
a
senior
data
architect
at
crunchy
data.
A
I've
come
to
crunchy
with
about
30
years
of
enterprise
database
experience
and
that's
where
all
the
gray
hair
has
come
from
and
if
you've
been
in
the
business
long
enough-
and
I
know
some
of
you
have
been
in
it
a
long
time-
we
all
have
a
story
that
starts
out.
I
thought
I
was
in
depth,
but
anyway,
who
is
crunchy
data?
A
We
also
author
and
maintain
some
core
elements
in
the
community
like
postgis
and
pg
backrest,
so
our
red
hat
partnership
we're
very
proud
of
that
always
honored
to
present
with
our
red
hat
friends.
That
partnership
goes
way
back.
It
starts
when
our
crunchy
operator
that
we're
gonna
look
at
today
was
one
of
the
first
three
operators
of
any
kind
to
go
through
the
red
hat
certification.
A
A
So,
let's
talk
about
the
operator,
the
operator
enables
database
as
a
service.
What
I
mean
by
that?
Well,
we
manage
that
database
in
an
automated
fashion
from
cradle
to
grave
from
provisioning.
It
back
up,
auto
healing
you
name
it
it's
completely
automated
and
we
enable
that
in
a
very
user-friendly
method
and
that's
where
the
database
modernization
comes
into
play.
A
A
A
That's
something
you
could
take
away
and
as
we
go
to
coffee
break
you
could
you
could
even
do
it
at
coffee
break
and
going
through
slides?
Wasn't
the
answer,
so
I'm
gonna
need
your
help.
Okay,
there
there
here's
a
qr
code.
So
if
you
have
your
phone
hit,
this
qr
code
you're
going
to
get
an
application
error
because
we
haven't
deployed
anything
yet
but
get
it
ready.
A
And
what
we're
going
to
do
is
in
our
brief
time
here
that
we
have
remaining
we're
going
to
deploy
the
operator
we'll
deploy
a
production
ready,
highly
available
postgres
cluster,
we're
going
to
use
a
open
source
component
called
postgrest
with
a
t,
that's
going
to
provide
us
a
rest
api!
That's
where
this
you
are!
This
qr
code
is
going
to
take
you
to
we're
going
to
create
a
database
schema
some
objects
populate
it
with
some
data
and
then
we'll
you'll
be
our
recruited
as
our
user
testing
community.
A
Okay,
so
david,
are
you
okay,
you're
still
good
all
right
here
we
go
deploy
the
operator,
so
I'm
in
the
operator
hub.
You
all
are
familiar
with
this
view,
search
for
crunchy,
I'm
going
to
click
on
the
crunchy
certified
and
install,
and
now
we
are
deploying
the
operator
which
only
takes
about
30
seconds
or
so
but
simple,
all
right
task,
one
we're
done!
Okay!
Now
now
we
need
that
postgres
database.
A
A
Very
simple,
so
I've
just
described
what
I
want
it
to
look
like
I've
applied
a
customized
manifest
here
called.
As
my
one
of
my
directors
when
I
was
at
citibank
said,
nobody
just
needs
a
database
right,
so
we're
deploying
a
database
we're
deploying
the
postgrest.
A
Rest
api
level-
and
you
can
just
take
a
look
at
this
you'll
notice-
some
things
in
here
that
are
pretty
interesting
number
one.
We
told
it
that
we
want
backups
and
that
our
backup
schedule
we
went
and
told
our
operator
that
we
want
a
full
backup
every
sunday
we
want
nightly
incrementals
throughout
the
rest
of
the
week
and
give
you
some
other
information
about
monitoring
about
specs
that
we
want
to
limit
resources.
A
What
version
of
postgres
we
wanted,
but
you'll
also
notice
that
we
have
a
database
initialization
script.
Here,
that's
going
to
take
a
default
script,
that's
going
to
deploy
our
tables
our
objects
and
preload
it
with
some
data.
Okay,
the
other
thing
that
we
did-
and
this
is
pretty
cool-
here's
the
configuration
for
postgrest
that
rest
api
and
you'll
notice
that
I
am
passing
the
data
needed
by
that
application
on
how
to
connect
to
the
database
right.
A
It's
uri
host
port
username,
password
directly
from
a
secret,
that's
maintained
by
our
operator,
so
gone
are
the
days
of
the
dba
getting
the
password
emailing
it
to
another
person
who
emails
it
to
another
person
who
emails
it
to
another
person
who
finally
keys
it
into
an
application.
You
can
fix
somewhere,
so
all
seamless.
So,
let's
see,
let's
see
how
we're
doing.
A
If
we
go
back
and
work
it
out,
look
at
our
workload,
so
everything
is
up.
You
see
our
pods
are
configured.
We've
got
one
primary
one.
Replica
we've
got
our
initial
backup,
that's
already
completed.
Postgresql
is
up
and
running
so
now,
if
we
go
back
to
our
slide,
you
got
two
urs
or
two
qr
codes.
Now
the
one
on
the
right
is
the
agenda
of
this
event.
So
if
you
now
hit
that
uri,
you
will
see
the
event
come
back
to
you
in
json.
A
A
There
we
all
be
the
first
to
post
in
there.
So
now
there's
data
in
that
table
as
well.
If
you
get
bored
at
coffee
break,
there's
a
curl
command,
you
can
do
a
post.
I'm
gonna
leave
this
this
up
and
running,
so
I've
got
just
a
couple
of
minutes
left.
So
let's
do
this.
Everybody
got
a
picture
of
this.
That
needs
to
get
a
picture
of
that
all
right.
Let's,
let's
stress
test
it
get
your
fingers
on
the
reset
button.
A
A
So
far
you
need
coffee
because
the
charts
aren't
moving
much
at
all,
but
anyway
we're
happy
that
to
be
a
sponsor,
and
we
hope
that
you
will
stop
by
our
table,
say
hello
and
if
you
want
to
get
started
with
the
operator,
go
to
the
operator
hub,
go
to
this
git
repo
download
the
examples
and
we
look
forward
to
meeting
you
come
by
stop
and
say:
hello
get
some
cookies
or
I
think
you
call
them
biscuits
yeah,
don't
order
biscuits
with
gravy
here,
people
think
you're
crazy.
That's
just
the
american
thing
anyway.