►
From YouTube: PostgreSQL Load Balancing 2020-06-23
Description
No description was provided for this meeting.
If this is YOUR meeting, an easy way to fix this is to add a description to your video, wherever mtngs.io found it (probably YouTube).
A
Let
me
get
my
screen
shared,
showing
what
what's
going
on
all
right,
so
I've
set
up
a
Postgres
cluster
with
two
slaves
and
replication
is
set
up
and
running
I
manually
installed
the
trigram
extension
and
then
we'll
and
process
of
bringing
up
get
one.
And,
of
course,
now
the
migrations
are
gone.
Let's
see
if
I
can
find
the
old
one
better
show
us
logs.
Now
it's
not
going
to
show
us
the
logs
I'm
not
probably
get
after
it,
kill
it
and
get
it
going
again.
Let's
do
that,
don't
quick!
So
people
could
see
that.
A
A
A
Whoa
there
we
go,
you
have
to
turn
off
auto
scroll
for
a
second.
We
come
right
up
here,
starting
around
the
I,
looked
at
migration,
looking
to
install
the
trigram
extension,
but
it's
already
installed,
but,
as
we
saw
a
few
minutes
ago
to
get
madam
using
what's
not
seen
it
so
that's
sort
of
where
we
left
off
and
I
think
that's
probably
where
we
should
start
up
again.
C
B
Don't
have
to
go.
Look
at
that.
I
will
take
a
second
call
out
the
everybody
knows
how
long
those
cycles
used
to
take.
So
there
is
your
visualization
of
how
fast
the
sites
go
now
so
the
place
to
debug.
This
is
from
inside
of
the
task
foreigner
pod,
and
this
is
a
admins
friend
it's
equivalent
to
having
the
console
in
the
omnibus
note
or
very
close
to
it.
B
B
A
A
Okay,
because
I
thought
thought
extensions
were
for
the
entire
instance
not
for
a
specific
database,
okay,
so
that
that
clears
up
a
little
bit
of
that,
but
I
probably
did
it
yeah
I'm,
probably
just
executed
on
the
Postgres
database.
So
in
theory
let
them
back
in
here.
I
can
type
the
password
correctly.
A
D
D
Yeah
and-
and
it
might
be
worth
when
you're
doing
that
to
double
check
the
upstream
documentation,
because
it
was
also,
it
had
been
my
impression
as
well
that
there
was
a
global
way
to
you,
enable
it
as
well.
It
might
just
be
some
other
method,
I'm
not
sure,
but
yes,
certainly
I've
experienced
recently
that
it
has
to
be
done
either
on
the
the
template
database
prior
to
any
database
being
created
or
on
the
database
itself.
That
you
intend
to
have.
A
A
A
A
B
A
A
A
A
Okay,
now
we're
seeing
it
there
good
now,
I'm,
not
using
the
headless,
which
is
a
I,
think
another
issue
and
in
trying
to
get
this
going,
I'm,
not
sure
if
I
actually
did
the
slave
set
the
slave
service
to
the
cluster
IP
to
knowing,
but
alright.
So
at
this
point,
ideally,
we
should
at
least
see
something
now
the.
A
A
A
B
A
A
A
B
E
A
D
B
B
D
B
A
D
A
A
A
B
A
B
Specifically
says
you
know:
if
you
have
a
primary
and
to
secondaries,
then
your
dns
should
point
to
which
ever
one
is
master
at
the
time
and
your
secondary
DNS
should
point
to
which
ever
one
is
secondary
at
the
time.
So
this
demo
actually
is
accurate
to
that
regard,
because
your
secondary
replicas
are
answering
at
that
service.
B
B
Yeah,
that's
gonna,
be
a
fun
one
I.
Let
some
comments
in
the
original
Mr
on
how
we
can
manage
to
feed
your
test
with
console
involved
or
not
involved,
and
how
to
do
that
discovery.
Behavior,
the
rails
code
base
assumes
lovey
you're
talking
to
console
because
that's
what
we
use
as
a
part
of
the
omnibus
and
what
we
use
with
production.
So
it's
more.
How
do
you
attach
counsel
in
the
right
way
to
interact
with
the
communities
environment
whether
it's
in
or
outside?
It's
interesting.
A
B
A
A
A
A
C
A
B
D
A
A
It's
our
deployment,
so
is
it
artists.
A
A
C
A
Just
flu
I
still
get
yeah.