Hey, above-life channel. It's Bridget. Nice to see you. Oh my goodness. Oh my goodness. Oh my goodness. I am really excited to do this channeling today. This is an unexpected channeling. Now, as you can see from my Paisley Park shirt, I was thinking of channeling somebody else. However, I am in Seattle, Washington in today's Sunday, and I happened to have some time, and my sister and I went to Lakeview Cemetery. If you follow me on Instagram, you already saw this. I showed him any video, and I actually live streamed from there on Instagram, Bridget inspired, visiting the grave of Brandon and Bruce Lee. And it's beautiful. I have never been to such a beautiful memorial. And true, I haven't been out to Hollywood. I have not been out to other famous grave sites, but this was so incredible, the energy. So when we got there, it was around 10 a.m. And the cemetery had been open for an hour, and there were quite a few people there. And there was a pretty steady stream of groups of people that would come through. It wasn't a wait or anything, but it was a pretty steady stream of handfuls of people would come through. And I was there for about 40 minutes, and it was just profound. And so I want to share that with you a little bit. I'm really, it's later in the day, it's like 5 p.m. So it's been, what, seven hours since I've been there? And I have been changed. The energetics were one of extreme peacefulness, strong empowerment. It was very inspiring, the energetics. And it was mostly from Bruce. Like I touched his monument, the marker, the actual book. And I will post a picture of, that I have of my hand touching the book on the bottom of his. It's this beautiful black book with gorgeous gold writing on it. And it has a beautiful circle symbol of a yin-yang. And then it has the arrows on the sides of it. And a friend of mine who is really into Bruce Lee stuff, she told me that that is his, that is a core sign for him, the sign of core. And it was interesting because I was telling her some of my feelings that I had from when I was there, and what it felt like for me. And she was like, you're using words that he would use. And I'm like, well, that makes sense because I channel, right? And all the feelings that I had are definitely this just profound connection of peace and passion and harmony, harmonization of the energy of this peacefulness, this calmness and this kind of intensity, this passionate energy, and the coming together of those. And then it creates this harmonizing vibration, which means we're all both, we're all both shadow and light, we're all both right and we're wrong. Right? We really are this true balance. And it ebbs and it flows and it moves and it's fluid and our energies and our pulsing life force energies are, we are the center core. And maybe that's what it means by being the center of the universe. I'm not sure, but it just, there's so much that I felt being there and it was just incredible. It was changing for me. I really felt, I was really inspired to do my work, to be a channel. I really felt just motivated, empowered, I'm not motivated, empowered, like just how special, magical it is to be able to feel energy and understand the messaging and just such profound, beautiful connection to that, which is more than our physical body, but then understand that the physical body is this beautiful temple that we're held in. And as I'm sharing this with you, I'm getting a ringing in my ears and I'm adjusting the energies adjusting and then it just quieted. Okay. So Bruce Lee is here in present energetically. And so I want to ask him about duality, because when I looked up the yin-yang symbol when we were driving, my sister and I was, I was so out of my body. We went to some bakery not too far from there, a couple miles from there. And I was just like, wait, what? What? Like I didn't know what was going on. Like I was just like, just, I said, this is profound. I've never felt like this before. I've never felt like visiting a cemetery would be so transformative and so unbelievably life affirming and just, I'm like, I just can't even, words do not do it justice how it felt. And the new understandings now I have access to new wisdom. And so I looked up that symbol, like I touched it with my hand and it felt like a button or a key. And I've never been drawn to yin-yang before until now like this and being like, Whoa, like really understanding the power of that sacred symbol. I've never really felt that. And I felt it like a button or a key like a push the button and then all of a sudden this energy, like I could talk and feel the connection. And so I, I felt a lot. So he's here and I wanted to ask him about duality because one of the things was is about duality or polarity or something duality is the question. Of course, I'm having tea. I love tea and I'm having green ginger tea and I bought it before and I thought this is a perfect thing to have when I'm talking to Bruce Lee. So we'll see how he comes in. He's really on my left side here. The passion that you describe is the energy of integrity. It's an integral part of who you are, he says. The life force that is within you is within all. What is in every, okay, let's see if I can get the channeling correct here. What you are describing is life, not the understanding or the balance between life and death, but between life and life, fullness, living, a life and living of life, embodiment, embodiment, embodiment honing the skills and the understanding of embodiment. He says, Bridget, you've been on this journey of embodiment. You've asked for guidance and specific, specific. I'm going to use the word intel, but specifics about embodiment and you shall have it. This is part of the transition point for you, he says. To begin to ask the deeper questions is to then learn how to be patient to receive, to know the answers, to allow them to come up inside from within you, as you well know. But it feels different than it is as it is explained. When it is explained and you listen, that's one thing, one level or way of learning that is one way. You listen, it is explained, you listen, that is one way. But the embodiment is the living of it, the truly and the cells of your being holding the sacredness, that sanctity of the wisdom in the body of the vessel of the human being. And then to live that from that place, it will take a great deal of discipline. And at times it will be challenging. And there will be struggle and grief. And there already has been all of those things. And life has those things regardless of what you are doing. And instead of people feeling as though those are signs of struggle or hardship or challenge is a sign of not non-success or lack of achievement or what some might perceive as failure. It is not. These shortcomings, although in physical terms are very measured, being too short, for example, being too, oh my gosh, I don't want to say that. He literally says being too Asian. That's literally what he said. He said, Bruce Lee said being too Asian. There are many things that will become part of your mindset, your landscape. He says your landscape of how you view and see the world.  That is the understanding of the duality, the dual. He says the two components. There are many. There are two primary components. Actually showing me two and four. He's showing me two here and two here. So almost like a compass, like the directions, the components. I think what he's doing is taking that yin yang and he's breaking it out for me like a compass, which is how I match and respond to energetics. That's how I do it when I'm doing energy work with somebody or when I'm doing like an energetic forecast because I do monthly energetic forecast audios for people sometimes. I have some clients that I do those things for. When I do that, I use a compass to move around and organize the month so that there's a pattern and a rhythm to things. He's literally showing me that he's taking the two of the duality and making it into a balancing thing of four. The duality, and he says, when you look at the yin yang symbol, it is a lateral energetic and it is a like a moving, I want to say horizontal, but he's literally going like this. Lateral. Why is he saying lateral float? Why am I going like this? And then I'm going like this. So it's literally, it's a straight up and down like the spine, like a pillar of light, like the spine, like the as above, so below energetics, like the soul before it comes into the body and the soul as a human body or the astral plane, the etheric plane, the spiritual plane and realms and the human layers of energetics, un-understanding of the human body. That, but also then he's showing me this like this movement, this fluid movement that is like, like water. It's like the flow of water like waves, but it's also very much. Yeah, he's just showing me this. It's just kind of rocking back and forth. It's kind of rocking back and almost unit looks like an infinity sign. Yeah, it looks like an infinity sign. So the up and down and the left and the right. He's showing me the flow and the connection of things, which is interesting because if I think about this and this axis going this way, it's definitely going across. The meridian going across is definitely in the medicine wheel. It is the direction of west and east and west and that is fire and water and it balances out. It's also medicine wheel also. That's how I use my energetics with the, I overlay the compass because that's a mind thing. And I go on the, in the clockwise motion. I'm going to organize the energetics when I'm looking at a forecaster doing some energetics for somebody for a month or looking at life stuff, life cycle stuff. And then I use the Native American medicine wheel to help honor the energetics of the elements and balance the natural rhythm and the flow of life and the seasons and such like that. Okay. Anyway, so that's literally showing me like this. Like it literally rocking back and forth like this. Like it's just rocking back and forth. It's not going tipping over the edge or anything. It's very much an arrhythmic pattern, but it is moving. It's going back and forth. It's like rocking chair back and forth like that. He said it's just, it's just movement. It's movement. It's always, you are always moving. So the duality is the movement is a, what are you saying? Synced up, synchronistic. It's, it's synergy, synergetics. He says it's like synergetics. He says you are the nucleus and that energy moves back and forth. And he says it's not moving to make change or create difficulty, struggle or strife. It's moving because that is its organic state is in motion. And he's like, it's a soothing mechanic. It's like, you guys, it reminds me of like trauma informed care, rhythmic, repetitive movement is how you help to balance the energetics when you have high anxiety or trauma responses, rhythmic, repetitive movement like sitting on a rock or glider, for example. So that's kind of what it reminds me of, but it's left and right, which is also the male female energetics in the body. So that layer of being is also present here. So, okay. So the duality, the dual states, he says everything. There's always at least two choices. And then within those two choices, there's many choices below that. And he says, when you peel off the layers of the false hoods, then there's clarity. It's very simple. It's not complicated, but it's dynamic, which makes it seem complicated, but it's not, it's not. When you are at the core and you can see without obstruction, if you are at the core, and it's more of this energy he's showing me, not of seeing with the human eyes, but seeing with the heart eye and seeing with the full heart, the open heart. And that requires embodiment. That requires such a strong partnership with the physical body. He did not defy physics. He's like saying, he's saying, I partnered with my body. I knew and trusted the wisdom and the guidance. And that allowed me to conceptually transcend the matter mass piece. And he's saying in the inertia, whatever that means, I have no idea. I know that he's like a martial arts guy. I know that he's like a superhero-like and stuntman-like and trained people in Hollywood and all that. I know that. I know that. I know that about him. I know that he developed a certain type of martial arts because that's what it said on his gravestone. And I have channeled Bruce Lee before, but I don't recall with my human memory. I just don't recall stuff very easily when I'm doing channeling. But he said, it really is about feeling. And that's how you see. He's like, you see from the center, from the core. And he's not showing me the guts, my stomach. He's showing me more like my heart. And right in between my heart and my tummy, like right here in this inner healer part, I call this the inner healer part of the body. For some, it would be actually considered the solar plexus because it's kind of right here. But for me, it's the part of the heart and part of the solar plexus, which is the inner healer part of who we are. That's the place where the core is for him. And he shows me very yellow, so very soul connected, very intuitive, very intentional. And when I told, so I wrote, okay, so there's a couple of things I got to share with you about my experience today. And one is the cherry blossoms. So when I came to Washington state, it's the cherry blossom time. It's this is April 2022. I'm recording this. It's April 24, 2022, to be exact. And the cherry blossoms are blue, and it's beautiful. And so everywhere you go, there's like trees, and I'm like, oh, I gotta take a picture. I'm gonna take a picture. I've only been here since yesterday, 24 hours, you guys, 24 hours I've been here. I'm like, Oh, taking pictures and stuff everywhere we're going because they're so pretty. The trees are beautiful. They're not great for the allergies, but they're beautiful. And I have a journal which it's not close at hand. Otherwise, I'd show you that I brought and I just grabbed it and brought it because it's kind of springtime like the energy is light pink and it has cherry blossoms on it. And it's a different kind of journal than what I normally would use necessarily because I've been using lots of different kinds of journals and stuff, but the light pink one just kind of seems really light and really kind of dainty, dainty, delicate. And I actually thought I have a friend in mind that I thought, Oh, I could send this to, she's going through some stuff. And I thought maybe I could send this to her because she just so like that really kind and super compassionate and very empathetic, just so nice. I thought, Oh, that would be a good gift for so and so. And my husband even agreed. He's like, Yeah, it would be. And I'm like, but before I was leaving, I was like, No, I need I'm going to bring this with me. And this is my journal. It's got cherry blossoms on it. I did not know they were cherry blossoms. I didn't even think about it. I didn't make the connection. I just said it's very spring like and it feels good.  So I'm going to bring it with me. And it's perfect. And then I got here. I'm like, Oh, my God, these are cherry blossoms. They are. And we were at the cemetery today and I looked up and there was this big cherry blossom tree right there. Beautiful, super connected. And I'm like, Oh, wouldn't that be a beautiful tattoo? Anyway, um, just beautiful. There's just so much. Okay. So duality. Yeah. Like having peace in the middle. It's like the calm and the storm kind of thing, like the calm and the chaos. And I just did a Sunday morning coffee podcast to today and I talked to it talked about changing your perspective and about little bit about resistance and stuff. Move a little bit and then things will be different. Things are just different. The view is not as obstructed and stuff. Okay. So the duality piece is really what I'm going to talk to you about today, Bruce. Do you have anything additional? He's showing me dumplings. Oh, sorry, guys are going to hear the dogs. Guys, quiet. Hey, I'm dog sitting. That's what I'm doing for my sister. She has some training for work. So she's, she's out, but I got two little dogs. Hey, Tucker, come here. Do you want to come up and show up? Show up in my video? He just literally said dumplings. Does he like, did he like that kind of stuff? I don't know. I don't know. He just said dumplings. I haven't had dumplings. I don't even know. I don't know. There's a lot of different kinds of beautiful different kinds of food around here where I'm at. Lots of different Asian types of dishes and from all the, just, but there's all sorts of stuff. There's like, there's just a lot of different kinds. We had Vietnamese coffee yesterday. It was so good. Oh my gosh. Oh my gosh. It was good. And there's like Japanese food. There's all different kinds of Asian food. There's like, last time I was here, I had baklava and what else did I have? Baklava and the place across the street with a really good hummus. I can't think of what else I had. What is that, falafel? Yeah, falafel that.  Oh yeah. There's like Mediterranean food. There's just, there's, oh my gosh, really good sushi and pokeballs. Oh my gosh, so good. And then, I'm not a big pokeball fan though. I like sushi though. And, oh my gosh, the noodles are so good. The miso soup was amazing today that I had. And spicy noodles, spicy ramen. Oh, so good. Anyway, okay, okay, okay. I think I'm getting hungry again. I might have to eat my lunch for dinner. Okay, what else is there, Bruce? He says, we're only just beginning to talk, right? So I was writing in my journal. So I went on the rooftop deck and I was writing in my journal and really reflecting on my experience today. And one of the things he said to me was to just be still, to be still and let the wisdom rise up because it's already there. He's like, it's not necessarily you guys about answers or finding the right answer or the right thing for you or making a change or forcing a change or making, moving from one place to a next. And we're in such a time of change, you know, we're getting off of COVID now and trying to find a new way in the world. There's some world events that have happened that have transpired that have disrupted peace and been very traumatic for parts of the world and lots of people that are affected. And then there's been physical, like natural disaster kind of stuff. There's been a lot of stuff that's traumatic and really, really different. The world it seems right now is there's a lot of flipping over of changing happening. And it seems kind of abrupt and harsh and rough a little bit. And so the choice to make a change that is peaceful, which would just be spending time and quiet, just being still, like that's what he was telling me. That was his advice. That was his like, not even advice, but instruction. He was like, the wisdom, it comes from within, but it can only come out when you are still, when you are at your core place, which is at this place of peace. It's not you have to become peaceful or get peaceful.  Because literally, like I had my AirPods in, I was going to listen to like, I could listen to like, I've been listening to a couple different books and I could listen to a podcast or whatever. And I'm outside and it's, you know, urban areas. You can hear the traffic a little bit here and there, even though we're up high on the in the building and stuff on the rooftop deck. And it was a beautiful day to like 60 degrees. It was really, it was mid 60s. Hey, quiet. It was mid 60s. And it was beautiful, really sunny in the afternoon. It was gorgeous. So I had to sit outside, but he just gave me this really strong understanding instruction of just be still. And so I didn't listen to anything. I just sat. I was present. And I was just still. He said, just be still, get really still until the point when you can literally feel the blood in your body moving. And that's the rhythm, the pulsing of your blood. He's like, that's the life in your body and all the veins and all the vessels and all the things that have to happen in order for that to occur. It's a, it's a systematic pulsing movement. He said, it's always happening. You don't have to create it. It's always here. It's like the peace and the passion to create the harmonics of the existence that we have. That's the vibration of the information he brought through. And even when I talk about it in the stillness, I just feel this incredible sense of tranquil just at my heart. I don't even feel, I don't feel any separation. I just feel this wholeness at the center of my body at my core. I feel this wholeness. And I hope that you can feel that too. And it's like the heart and the soul are like the yin, yang, the balancing of the energies. Your heart so empathic, so feeling, so passionate, your gut, your soul, so beyond inspired, so filled with optimism and just the purest sense of life and understanding that transcends the human body expression and experience, but yet expresses through the human body. So the mind quiets naturally because the mind wants a break. It doesn't want to always have to be on guard. It wants the stillness. It wants the reflection in toward the body. It wants to, to allow the body to presence, the energy of the heart and the soul of what's internal and inside and organic and the rhythmic nature of life. That is what the mind does want. And so this is an opportunity to really understand that, the parts of us and how we work as humans, as spirit and our wholeness. That's the duality of the human expression and the spiritual expression of who we are. That's beautiful. It's not just a concept, Bridget. It's not just a concept. That's good. Thank you. Thank you, my friend. Thank you. Gosh, you guys. Wow, it's so great. Okay, so I do need to add some, I mean, I represented Minnesota. Let me just say, I wore my Paisley Park t-shirt today. I represented Minnesota. I totally did today. It's like my first 24 hours in Washington State. Wow. And I'm gonna be here for like three, because this is gonna be great. Hmm. So this is Bridget. Thank you so much for being here on Above Life channel. I hope that we've inspired your spirit today and filled you with some hope and encouraged you to live your life. This is your life after all and you get to live it. Live it from your core. Just live it. Thanks for being here.


d using the same so effectively if you don't want you don't want to store the key in the encryption in the file you can also provide the encryption key from the command line argument like minus minus enc dash key or minus capital key you can provide an encryption key using using when you are when you'll be starting the pg pool 2 in the command line but but i think that the best way is to use the key file and place it in some some some secure directory and yeah use the environment very variable pg pool pg pool key file to point to that directory from the terminal so so this is this is pretty very secure form of encryption and if you keep the key file secure your passwords are always secure so this is the pg pg underscore enc utility that comes with pg pool 2 you can use this utility to create and store the es encrypted passwords pool pass file so yeah this is yeah you can also provide the encryption key as a command line argument or it can read the encryption key from the file and it can also read the encryption key from pool key file environment variables path and yeah it can do pretty much everything and like for as far as passwords and if you if you give minus m option to this it will automatically go on and update the pool password file like you don't have to copy paste anything like it will automatically update a pool password file which can be used by the pg pool so yeah this is this is just an example of like working of pg enc i have just created a pool as key file i've changed it permission like we changed it to 0600 i've exported the pg pool key environment variable to point to that file then i've used just pg enc then use a dp name and username and yeah there i'll type the password and it gives me like it it is using the slash home postgres postgres key file you can see there there is encrypted password is stored in the pool key file pool password file so it's pretty much pretty easy to use the enc utility and store the encrypted passwords similarly like pg enc we have pg md5 utility it does the same thing but it stores the password in md5 password in md5 format so yeah i think i'll just skip this one because we are already short of time so this is this is this is the but pool password file is used for it is used to authenticate clients with pg pool 2 and used to authenticate sessions with postgres so so the pool password file serves to a purpose when the client comes in the pg pool 2 will use the username and password from in pool password file to authenticate that client and then if the the authentication is successful if it then it and and pg pool required to connect to the postgres using the same user it it uses the same pool password file and it depends upon the type of the configuration type of the authentication you are using in some cases it does not need the authentication pool password file to authenticate for example in case of clear text password authentication it does not require pool password file but in case of scram or more complex authentication methods the pool password file might be referred so pool password file must use the same password for user as are in the databases otherwise the authentication the backend authentication won't work the pool password file uses password type prefix in password string to identify the kind of password yeah for md5 password you have to prefix the password string with md5 for a yes and for text like from scram like these are the you need to you need to prefix the password with the appropriate type of encryption that password is using this is for the pg pool 2 to identify like what kind of password is present in the file so this is these are the configuration related to the authentication enable p pool hba this enables the pool hba setting it off will disable the hba it's pretty much obvious from the name of the name of the parameter then pool password file this sets the location the name of the pool password file to be used you can use a different name if you want to allow clear text from authentication well this is a pretty dangerous one to have but you can of course you can use that for example if if you allow pg pool to use clear clear text front authentication authentication then if some user tries to connect to pg pool 2 and pg pool 2 does not find the appropriate user a password for that particular user in pool password file which is required for the back handle authentication then if this variable is on then what pg pool 2 will do is it will ask the client side application to switch to clear clear text text authentication and if the client agrees with that then pg pool will get the password from that client in clear text format it could be ssl encrypted the whole communication channel but the the actual password will be in clear text format in store and then pg pool will use that clear text password to authenticate through the back end of course you you might not need to use that and you you need to do a proper authentication you need to provide do a proper configuration in pool password file but this is this is this pg pool does allow this clear to fall back on clear text front end authentication if if it doesn't find the one that the the appropriate password in pool password file but yeah it's you can you guess that this is the dangerous one to use okay the load balancing i think yeah so this is this is the load balancing like right queries are right requests are sent to the primary server while the read queries or read requests are routed to the standby server this is known and load balancing you can switch on the load balancing using load underscore balance mode is equal to on that is all you need to do so the load balance does work in replication and master slave mode and in this mode read statement inside the transaction block or load balance until the writing statement is issue in in this particular transaction curing curies using system tables on long tables and temporary tables are always sent to the primary node and yeah you can guess for the obvious reasons and a slack statement having a writing function called do not get load balance yeah again because we cannot execute a write function on a standby or on a hard standby because on the read transaction there are a lot there slack statement inside serializable transaction do not get load balance so yeah i'll try only try to touch on the important one so if you're using the extending extended query protocol and if the parse of a slack statement was sent to a standby node because you know that in extended query mode mode the the queue the query is divided into multiple messages and client messages so for example the parse was sent to the standby node and then the client issues are bml statement before executing the previously parsed then then as per the as per the algorithm of the pgpool to load balancer whenever a write or dml is issued in the transaction all the subsequent reads clearly must be must must not get not get load balance because then there's a chance that we that we can we can get a older version of data in that case if the replication lag is like on a higher side so in that case what pgpool does is it it resends the parse the the previously routed parse measure message to the primary again so this is this is a kind of a behavioral thing like then the and the in that case the same parse match message could be sent to multiple nodes yeah this is this is one important thing to consider then the then there are ways if you want to force a particular query to the primary node and you can you can use no load balance command at at the start of the query and this will force the query into to land on the primary server and of course the behavior depends on allow SQL commands and this is this is this does the working of this page shows the working of the no load balance command so so in the first uh like uh I've I've used the no load balance command in the circle in red and did a select inet server address to just to make sure which which server executes that query and if you see the query was executed by by the primary node and because we we we get 172.2 or 0.50 and if if we issue the same query without the node load balance command then then one of the standby executes that query so so you can you you can force any query to land on the primary server by using the command at the start of the query otherwise the internal logic of the pg pool to load balance will kicks in and decides which query needs to be sent to which server then there are black query pattern list like you can put in the query this is this is a configuration parameter and you can put in the queries there like which queries you want to you always want to send to the primary server so yeah and you can also use a regular expression so I've added an example like if I want a slacks on a table and the nlb to to always land on the primary server I can put that select static from nlb table in the black query pattern list and this query will always be served from the primary and yeah this is just showing that the working of the black query pattern list and then then how do we tell pg pool about the writing function like which functions are writing and which are harmless to be executed on the standby so we use byte function list and lag function list parameter these are two parameters they are mutually exclusive to each other like lag function parameter list it contains the function which which are writing function you can use the regular expression and all the all the select statements who have the function calls present in the black function list will always land on the on the primary server alternatively you can use byte function list to tell that these functions are these functions are reading function and all other functions other than which are present in the byte function list are writing function so this is this is depend upon the design of your database like whichever configuration parameter you know you want to use so I hope I'm making myself clear and just trying to wrap up things so again you can specify a comma separated list in the writing function and you can also use the regular expression and like the best practice is you can either design for the white function list or for the black function list and all what you can do is you can you can prefix your function name with get or set for example to use white function list all the writing for all the reading function are prefix with get and in the white function list you can just use a regular expression get underscore star this mean any function starting with get underscore that that that that that is a reading function and you can safely load balance it and all other function which does not have a get prefix in their name they they they are writing functions okay so yeah this is just a color inverse of a white function list we have just discussed yeah this this explains the same thing like we can use a particular naming scheme for writing or a reading function like we can use set underscore for all the writing functions and prefix all our writing function with with with set underscore and use a regular expression in in black function list parameter okay so this is this is to ensure like like we always get a latest version of that that's a depending on the type of replication setting and workload requirement load balancing can be configured to ensure we always get a latest data PG pool provides two configuration parameter to configure the load balancing behavior depending on the state of grand session so this the first is disable load balancing on right and the second is the lathe threshold so we can use these two parameter to fine tune the settings so disable load balancing on right it can have four possible values like off always transaction and trans transaction when set to off read queries are always load balance no matter you are inside the transaction if you are like whatever the state transaction is in and if well you this is as you know this this will give the best load load balancing performance and use for a synchronous replication because in that case you know you know your your all the replicas are same but yeah in case of asynchronous replication there's there's a possibility like you have you can read a older version of data when you set disable load balance and write and then when set to transaction and write query appears in an explicit transaction subsequent queries are not load balance until the end of the transaction yeah this is this is this is the normal mode kind of a thing like whenever a writing query appears in the transaction all the subsequent treat queries must also be sent to primary to make sure that they get the latest version of data you can also set it to the trans transaction and this is this is pretty hard one like if a write statement appears in explicit transaction subsequent read queries are not balance until the current and subsequent subsequent transaction in your session ends so theoretically it it it widens the spectrum of disabling the load balance and when set to always well it disables effectively disables the load balancing until the time the current session ends so I don't know where always can be used but yeah they we do have a this particular setting okay then the delayed threshold like we can set the specific maximum tolerance level of replication delay in number in ball bytes on the standby server like we can set the setting the delay threshold to zero this mean do not check the delay threshold but you can set it to any value in number of bytes and if if you like if the replication delay at particular time exceeds that that like exceeds that amount of bytes then stop the load balancing until the date the late threshold comes back within the acceptable range so this is this is the you can configure the threshold and yeah then it works automatically whenever the threshold is reached the load balancing will stop working and then when we come back within the acceptable nature no okay so we have already discussed sr check database sr check user sr check password and sr check period configuration parameter these are parameters which configures the database server user that is that is used for for reading the delay threshold like setting from the backend and yeah this we have already discussed that so basically pg pool provides variety of configuration to fine tune the routing of read queries to effectively distribute the load routing of these queries can be also be configured on basis of connection application name target database name backend node and load balancing rate so yeah you can I'll quickly go through these parameters like you can set the application name redirect preference rate like you can make pg pool to like to route a specific the connection from a specific application to a specific backend node for example if you want all your pcql clients to to be served from like to be served from 50 percent from standby 1 and 30 percent from standby 2 like you can specify the ratios like this is like this is for the load balancing thing the right queries will always the right statement will always be served by the primary node but you can you can set the ratio of the read queries for particular application name and this like yeah this is at month and similarly app name yeah this is the example of app name reference list like if you see on the bottom of the slide we have used pcql primary and my app this mean only route route all the queries from the pcql to the primary and then I use my app 1 ratio 1 and then my app 2 standby you can use node id like the my app 1 this mean route 30 percent of the queries to the node id 1 and my app 2 route 100 percent of the read queries to standby this is like you can use the standby as as general standby name standby like all the standby falls in the same category if you write standby here or primary you can use that and you can also use the node id so this is an example similar to the app name redirectional reference list we have a database redirect reference list we can we can make sure like the the connections to a database one should always be served from particular backend and the connection for database tool should also be should be served from primary only it it uses a similar similar format and as of application preference list but in this case the database name is used for the comparison or as a parameter rather than the application name and these these tools are quite kind of a new parameter introduced recently and the backend where this this this is as old as PG tool itself like you can set set the backend wait for each backend and for example back and wait zero and and then back and wait one for each you can set the back and wait for each node individually and you can set it to any values and when PG tool starts it just normalize all the back and wait and calculates the the ratio and then tries to try to route the queries based on the back and wait ratio ratio so if you see the the first like back and wait has the least preference and app name and database name redirects have the most preference if if some rules get satisfied by app name or database name then it will not consider the back and wait but if if there is no rule for a particular connection available in in app name or back and or database name preference list then this back and wait will get like this this rule will be used okay then then there is an another new thing in PG pool session versus statement base low statement level load balancing historically PG pool by default selects the load load balancing node at the start of each session that node is used as our destination for all load balancing queries for the lifetime of the session this is this is how people used to work until recently we have a statement level load balancing and setting this parameter to on make the PG pool tool to select load balancing node for each query whenever when the query arrives this is this is the example like for example if we have three node cluster one is primary two standby whenever you start a new session the primary node will always be there for each session but PG pool two will select one of the and one node from the available list of standby from available standby nodes to use as a as a load balancing node for this particular session and you can see the the true the last column this is this is this mean this this particular node is used as a load balancing node for this particular session and PG pool will always use this node to to route all the read queries but now now with the with this new statement level load balancing what happens is rather than selecting a node at the startup PG pool two will not select any any standby node and it will only select one one primary node and whenever the query arrives depending upon the load ratio on the current load ratio on the system it will select one of the node one of the standby available standby node and send that query to this particular node so this is this is where you can you can change this behavior okay so this is this is another thing and this is one thing I got lots of questions in the query like do we can we actually gain performance with PG pool as a load balancer so so there are a few things like we all know that PG pool is a middleware and it has its own processing and network overheads and direct connection to Postgres perform better for smaller workloads like but but as as the load increases the PG pool start out performing the direct connection well it totally depends upon the type of the server and workload so I've performed a few benchmarks and with a very small systems and just to show showcase like where the PG pool is useful so the green line here is TPS with the PG pool two and the black one is the TPS with a direct connection if we see in we have used the PG band with a hundred scale factor and then I've done the done the benchmarking with five fifteen twenty five and forty five clients and if we see with the five clients the Postgres the direct Postgres connection was performing way better than PG pool two with 15 clients again it was better but as soon as we start increasing the load with 25 clients both are performing kind of a similar PG pool two and direct connection but with 45 connections like PG pool perform way better than the direct connection to PG than than the direct connection with Postgres so effectively if we have if we have load on the server then then then deploying a PG pool two in front of it and using it there's a load benefit will always give a better performance similarly I perform another test this time with a 500 scale factor and you can see the tip of point comes way earlier than for five connection both were performing almost the same but for the 15 clients PG pool like almost double the performance and for 25 and for 45 clients the difference was huge so so this is a conclusion for the smaller database sizes and smaller workloads we don't expect any performance gains from PG pool two in fact it degrades the overall throughput because extra hop between client and Postgres and processing involved on PG pool two side performance gain happens when load on a single PG pool two server becomes significant and PG pool load bends will give better performance than standard for a single Postgres server whenever IO load on the single PG node becomes significant or a processor on a single PG reaches a maximum or a database size becomes very large compared to the RAM on the PG server so these are the conditions when you expect the PG pool will perform better I've also done a blog on the same and you can like where I've done a complete analysis of these performance and yeah this is the link of the blog so another thing is connection pooling yeah I'll just I'll just list down the key points so connection pooling is as as you all know like it is like the client connects to the PG pool two and in turn PG pool use connects to the Postgres then the client disconnect rather than disconnecting the the the backend connection PG pool basically pools that connection and a connection is identified by username user colon database name and this is this is just connection pooling and the important thing to note here is as PG pool is a multi-processed architecture so so each single child process of PG pool two maintains its own connection pool so so if you have 100 child process then effectively there are 100 small pool connection pools in the PG pool two and whichever child process gets the client connection it utilizes its own on connection pool so there's no global connection pool in PG pool and the other thing to note is template zero template one Postgres and regression database they do not get cached and they do not get pooled so these are these are some parameters which we can change to fine-tune the connection pooling and I think like I'll just skip them and you can just read them from the CD so yeah this is this is the point I need to explain the serialize accept and like this this this enables the serialization on incoming connection like you might have been familiar with the thundering her problem that thing is if you are using a large value for numb inner children and numb inner children is a parameter which like the PG pool to spawn numb inner number of children at at at the startup for example if you want to your PG pool setup to handle 1000 concurrent connection then you'll set numb inner children to 100 1000 that means at the startup 1000 child process will be spawned by PG pool two although this is a very huge number and normally we don't do that but but just to clarify the point so so so each each each one of the child process of will be listening or and will be waiting for the child for the client connection and whenever a new client connection comes in like everyone all of these 1000 connection will try to get that connection and only one of them will succeed and rest in 999 will will fail and they they'll come back and start their second listening mode again so what what happens is that if you are using a large number of connection then this will cause the single connection will cause so many like 1000 contact switches which which which effectively degrades the performance so so for for for that purpose PG pool two has this this configuration parameter called serialize accept if you set it to on then only one of those 1000 connection will wait for the connection and and once that connection once that child process gets a valid connection then another basically the child process will call will make a queue and the the top of the queue will will get the connection and then then this is how it will work so so basically what you need to but you need to you should only set the serialize accept for the large number of connection but because we have done after this parameter we have done some few benchmarks and it is known to slow down the performance for the for the smaller value of number in general for example for 100 or 200 nominal children you don't need to you don't not need to set the serialize accept but for the larger value you may need to set the serialize accept to on and the the name of the problem it is the thundering hurt problem which is solved by this variable so we are already three hours and 15 minutes marks so these are show pool node commands and yeah this is the best practice each child process manages its own connection pool so carefully select the value of max pool max pool is the number of database username pairs each child process can can cache for example if you set max pool to 2 this means each child process will will cache up to 2 connections and yeah this is this is how you will calculate the max connections for postgres backend as as i just mentioned like each child process each child process of pg pool to manage its own connection pool so so effectively we have max pools multiply number of num inner children this is the number of backend connections we would need in in in a situation of maximum load so you just multiply these max connection minus superuser reserve connection on postgres side should be less than equal to max pg pool to multiply the num inner children plus two plus two is for the health checking uh uh connection which pg pool to make so this is this is a kind of a formula you which you can use to calculate the num num uh max connection uh value on the postgres side okay for the log output yeah you can uh pg pool use the similar log error verbosity and that line mean messages this is the similar kind of protocol which postgres uses and then yeah this is i just added just in case you can enable the memory cache on the pg pool to side and then you can use the replication mode we have already touched a little bit on this and this is the GUI i've discussed about GUI tool for monitoring that configuration just stay tuned for this we are making a new better version of the GUI tool and it will be available soon so yeah that's it from my side if you have any question please okay let me read out the question we run pg pool to reset 7 and use rep manager to manually do failover and switch over pg pool to redact these events and properly recognize the new but all client can actually reset client have to reconnect and then things are okay again but we need to keep the pg pool children alive in this situation and make the failover transparent with client's agent well in case of a primary node failure there there isn't a way as of now there there is one tool item which we we're still struggling to fix that and it is to preserve the client the front end connections and only do reset the back end connection but it is still into rule list and yeah but unfortunately there's no currently there's no way available to to preserve the client connection when primary fails but we are working on that per user per database i'm sorry i'm not getting are you are you referring to the connection pooling or what briefly talk on user database connections can it be configured on per user per database no no no no no not really basically you can just set the max pool variable and then pg pool uses lru likely it removes the least recently use connection and the best practice here is if because normally the the application server they use is one or two or three users to connect to the databases so you just you set the max pool to the value like for the most number of use connection like for example if your application are using two two database username pairs you just set the max pool to two and then then even if the third one comes in then then the least use will be removed but there's no what we can call it as a pre-warm cache there's no no no kind of pre-warm cache but again yeah this this this would be a good thing to to be frank like if you want to use if you want if you want to have a only connection pooler then then i think the pg bouncer is a better choice when it's come to connection pooling performance but if you want to have a load balancer along with the connection pooling then then the pg pool comes in because because of its it's so many modules the pg pool is a bit heavier than the than the pg bouncer so so yeah it has a little less functionality when it comes to only the only the like connection pooling site but overall yeah the most use use case of pg pool is for the load balancer and yeah we do have this one in list as well to to have a pre-warm or a cache or caching something similar to the pg pg bouncer okay guys thank you very much i hope you get something useful out of this and yeah you can shoot any question if you have on the pg pool community i'm pretty much pretty active on that i'm also included my email in the slide deck so you're welcome for any question and any suggestion and i hope to see you guys soon somewhere in the world sometime and thank you lince for for for for arranging this training session and everything


You can still see me. Greetings and salutations. This is the University of Massachusetts Alumni Secret Society. We like to get together at various places around the area. One of the places is a cemetery. We like the cemeteries because there aren't any living beings over at the cemetery harassing us like you have on a bus. You go on a bus and people are using their smartphones and making a ruckus there sometimes talking in a foreign language. It's very annoying. Now I just pointed out that I used to have what was called the Sony Watchman because I grew up in the period of the television not the computer. Now I watched television from 1954 to 1994 watching quite a lot of different kinds of programs. Now I grew up with television and I actually watched programs before I went to school. 1954 I was a preschooler and my favorite program was Hopalong Cassidy. Hopalong Cassidy was a famous Cowboy series that people used to watch and that was my favorite program and during the fifties those cowboy programs were a dime a dozen. They had them all over the place especially on Saturday mornings. I could name some of the programs you know like the Lone Ranger, there were the Tales of the Texas Rangers, the Cisco Kid. There was quite a lot of TV programs revolving around the Western theme and they'd be shooting people left and right. So I was kind of accustomed to seeing that kind of stuff there because we had it on the television. I think what happened is that people complained that children were watching these shooting programs and they thought that was a bad influence and they started taking those programs off. So really you can't see too many of those programs and this day and age unless you have cable I think there's a cable network that features those old TV programs like I used to watch but you need to have cable. Now I grew up at a time when television was free you didn't have to pay for television. You know I actually watched television in my 20s quite a lot because I graduated in the early 70s and I was looking around for a job in my profession and I couldn't find a job in my profession. I won't tell you what that profession was but I did fill out resumes and go on job interviews and I was actually unemployed for two years. Now while I was at home during those two years I started watching a lot of television as a matter of fact. I had three TV sets on at the same time all on different channels. For example I would watch the Today Show on one TV, Good Morning America on another TV and the CBS Morning Show on the third TV because we just had networks at that time. We didn't have all these cable networks that they have in this day and age. So I had three TV sets on at the same time. Yes can you imagine that? And I was experiencing multi-dimensional brain activity because I would try to focus on different parts of the programs on different TV sets. So for example the Today Show might be featuring some interesting news story and I would kind of focus on that one and then Good Morning America would have another program and I'd switch and focus on that one but I actually had all three TV sets on at the same time. Now unfortunately the television was a bad influence because I started watching television more and more and more. I had got Nielsen Rating's book that they sent me and I had to list down the programs that I watched and I happened to be unemployed at the time. So I listed all the programs that I watched from early in the morning I would say like 7 a.m. and then it'd go on late at night. So I actually watched television 14 hours a day. I'd watch the morning talk shows. I'd take a nap in the afternoon because they just had those soap operas and then I'd get up and start listening to the news programs and after the news programs they'd have other types of documentary programs. I used to like the programs that had information as a matter of fact you could probably call me an infomaniac because I liked information. Now one of the things that I saw that I remember vividly was a segment on 60 Minutes and this was like about 20 years ago and they interviewed some lady that said she was talking and she was talking on a landline not a cell phone. She was talking on a landline and she was discussing her son that was in a play at school. So she was talking with somebody on the phone and she mentioned that her son bombed at the play. So she used the word bomb in the sense it was a theatrical concept that when you're in the theater and you don't have a very good program they classify it as a bomb. But she said that federal agents came over to her house and was inquiring because she used the word bomb. This was 20 years ago when we had landlines so you can imagine if they were listening to people on landlines can you imagine what they're doing nowadays. You mentioned one of these code words that now they use artificial intelligence and they'll pick up these code words and if you use one of these code words such as bomb which was used in the theatrical sense it wasn't used in the terrorist sense and they used that word and it was the FBI got notified because somebody used the word bomb on the phone. Now in this day and age people are talking all kinds of information on the phones and they're being monitored by the government. You know some of the governments are closely listening in to the population such as in Russia and in China and some of these other countries you have the government actually listening in to the people talking on the phones and they don't probably list all the information they use artificial intelligence to pick up some of these words. So if they have some kind of controversial word that's used on the phone you might get a little visit from the government they would come by and see what was going on. Now as you can see I'm a voice from the cemetery so I have experience from years ago of things that had happened. Now unfortunately the world is changing so much now it's difficult to keep up with but I showed the watchman because that was the precursor to the smartphone but that was only one way communication. I could listen in anywhere in the area and listen to my favorite TV program. I could go sit in the park and I could listen to Donahue or some kind of talk show. They would be having a discussion for an hour. Some of the topics were rather interesting but you know I can't live my life according to the TV. I did kind of schedule my life around the television when I was in my 20s and 30s and that was becoming a little bit of a problem because I would tell people I said I don't want any job to interfere with my TV viewing. I had to watch the TV program. It was really important because they had information that I wanted to listen to. Now there is a lot of things nowadays that you don't have to be listening to a specific thing at a specific time. They have podcasts now so you can listen at your leisure. You could be listening at midnight to a program that might have been aired say like during the daytime like they do on national public radio. Now national public radio has a lot of good talk shows and I appreciate the fact that they do cover a lot of different topics. Now I can't tell you about all the different topics because they do have some topics that might not be suitable for all types of people and I could give you an example about you know like this information about I think it was Prince Andrew in England having some kind of relationship with some 17 year old and it was some big story that was on the news recently but this stuff has been going on for years and years and it's really kind of old news. So you know I am part of the University of Massachusetts alumni secret society. Now the secret society has done alternative types of experiences. That's why I like to use the phrase the existentialist experience because existentialism according to the pedagogical definition an attitude and an outlook which emphasizes human existence and the qualities which are distinctive and individual persons as opposed to man in abstract nature or the world in general. Now that's kind of a really kind of a difficult concept so I like to use the idea that students in a sense are kind of like existentialists because they're not really out working and earning money unless they have a part-time job but I consider part-time workers as existentialists because their whole life does not revolve around the job. Now the job is important in the society but we have a capitalist society not an existentialist society so students and college students part-time workers unemployed people homeless people there's a whole assortment of people that could be classified as existentialists because they're not working at least they're not working full time. Now I know there are people that actually have their whole life revolves around their job yes that is true in this society and I can give you an example of some people that I know that work at UMass. Now I deliver things to UMass that's a part-time job that I have now one well at least two people work full time in the morning at one job I would say I don't know eight to three or nine to three or something like that I don't know what their hours are but they go into a morning job and work on a full time job and then they go to UMass and go work three to eleven during the same type of job. Now they're working like 16 hours a day they're totally consumed by the job. Now I'm not really saying anything that's not really too bad your whole life revolves around the job and I used to listen to the radio talk shows that kind of took the place of the television talk shows because I would have the radio talk shows on while I was delivering so one of the people that was talking on the radio was Dr. Joy Brown who passed away I think a couple of years ago she was one of those radio psychologists and I thought she had an interesting program now she mentioned that men between the ages of 25 and 55 mainly got their identity through their job that's how they identified themselves and that was the traditional way that people would get their identity through their job. Women weren't as focused as men but men worked full time and they were very into working long hours it must have been some kind of a macho attitude that they said the longer hours they had the more money they make the more they felt that they could control things but of course you know if you're not really making a lot of money every hour then you would be classified as middle income it's these other people that are kind of taking advantage of people which I like to call predatory capitalism. Predatory capitalism is people taking advantage of other people financially. Now I can give you a number of examples apple could be classified as predatory capitalism because they charge all outdoors if you want to have some of their products repaired. Now you could bring it to another repair shop and probably get it repaired for less money say if you went to Best Buy or some kind of a place like that that does some kind of repairs and they won't charge as much so places that overcharge I classify as predatory capitalism and the predatory capitalists are the ones that are exploiting the masses yes they actually exploit the masses because they overcharge and cause problems now you could even classify colleges in a sense as predatory capitalists because they're charging thousands and thousands of dollars for their educational information that they're giving to students but in my opinion if a student doesn't get a good job within five years after graduating that you know they should be able to sue the school and claim that they were victims of some kind of predatory capitalism now if you went out and bought some kind of expensive car say you went out and bought a Ferrari or something you'd spend like $250,000 or more for your sports car and the car won't work properly you could bring it back a lemon law type of thing but you can't really do that with a college education there's no guarantees in life life is just basically how you make it now I graduated from UMass that's why I'm part of the University of Massachusetts alumni secret society now this was a society that was based from years ago in the counterculture and we kind of liked to be able to have time to do other things but like I said it depends on each individual now some people were more oriented to get money and some people were not I happen to be one that did not care about working long hours and being stressed out now I got stressed out plenty of times in high school and college just to get grades and I got upset stomachs I got headaches it was very stressful just to pass a test now what good did it do I went through high school and college and didn't get any really major job now the jobs that I've had I don't really have any problems with the jobs but they're not really like really high paying jobs and that was my choice I said you know I'd rather work part time on a job that I didn't like instead of full time on a job that I didn't like but in another way you can think of it in other terms why put a square peg person into a round-hole job now that is stressful and I don't really believe in that concept but people think that it's really important to get all kinds of money at all costs even if they're a square peg person trying to go into a round-hole job now there's nothing wrong with trying to fit into the job but in this day and age I can see that there's a lot of individualists that are out and about you can see from the coloring in their hair they might be having colored fingernails they might be wearing strange clothes I saw one guy walking into McDonald's he had a kilton there was nothing wrong with a kilt but he had this great big huge bowie knife on the side there I was kind of surprised because he was walking around in public with this great big huge bowie knife and had this like a leather kilton that seemed to me a little bit unusual but you know each to his own if he wanted to carry around a great big huge bowie knife that was up to him he might have been a homeless person and he used a knife to be cutting branches to build fires or something so I don't have anything to say about that just that I'm surprised if somebody didn't call the police and said there was this strange person that was going into McDonald's with a great big huge knife now you know recently over in London there was a guy that attacked people with a knife on London Bridge now a knife could be classified as a deadly weapon but you know some people feel that they have the right to carry a knife some people feel that they have a right to carry a gun but the gun thing is a really complicated issue because all you have to do is pull a trigger with a gun but with a knife you actually have to attack somebody physically attack somebody so that's a little bit of a different kind of situation and you can't really attack a whole bunch of people with a knife it's a lot more difficult but with a gun you can do a lot of damage shooting people now I don't have any problem with people being individualists now I'm trying to explain how things used to be because I came from from the past now like I said I watched television for 40 years from 1954 to 1994 and the government actually discouraged that they changed the analog to the digital and that meant that you either need to have cable or satellite or you need one of those kind of contraptions that you'd hook up to your tv to pick up the signals unfortunately those contraptions don't really work very well so if you want to watch television and this day and age now you have to pay for either cable or satellite and some people are willing to do that and there's a lot of stuff on cable that's interesting so people are willing to spend the money to pay for television I happen to think that that's kind of predatory capitalism because we used to be able to watch television for free why are we forced to pay to watch television this is a strange world that we're living in that we can't now watch our television without paying for it now and sometimes they charge all outdoors for some of these things now I work part-time and there's nothing wrong with working part-time like I said the part-time jobs are nice because you have a change of pace I had worked on a bunch of part-time jobs and you'd have a different mindset every time you went on a different job you'd be doing one job at one place and another job in another place and another job in another place now some people do the same kinds of jobs they'll go from one place to another now I noticed one lady that works at McDonald's in the morning and then she goes next door to work at Wendy's in the evening she's probably doing the same type of work she just goes from one place to another there's nothing wrong with that and they're earning money but they're working who knows how many hours they might be working 12 14 16 hours a day like I mentioned some of these people that I know that work in the morning and then they go in the afternoon to go work on another job now we do have a society that you need to be paying bills and things but the problem is that everything has gotten to be too expensive way too expensive for people to be living now we should be able to manage on a part-time job but most people can't do that this is going to be difficult once you get to be an adult you need to try to get a full-time job according to the standards of the establishment now the university of massachusetts alumni secret society we wanted to have other types of existentialist experiences now I can give you an example of an existentialist experience that I rated very highly now this was during the 90s 20 years after the streakers were running around naked in some of the colleges during the 70s now that actually happened and I remember that distinctly but it kind of was uh one of those things that just happened to be at a certain time and it wasn't really a regular kind of a thing it was just something it was like college prank now I tried to have alternative experiences and one of the alternative experiences that I am going to classify as a 10 now if you rate have a rating system of one being the worst and 10 being the best this is what I classify as one of the best experiences that I've experienced over the years and this was during the 90s now I happen to see some poster about a full moon ceremony and I said well that sounds really interesting a full moon ceremony so I said I'm going to go over to this full moon ceremony now this was located in a location not around Amherst but it was in a place in East Hampton a famous counterculture enclave in East Hampton that I found out about that they had people from the so-called counterculture would get together over there now they had a great big huge hot tub over there and they also had a sauna now the fins use the the phrase sauna that's the Finnish pronunciation the Americans call it the sauna but it's a sauna it's a hot place that you go into and so this was a location in East Hampton now East Hampton has alternative types of people like I said because the problem with the housing is not as expensive in East Hampton as it is around Amherst and North Hampton and people like to go to places that's not going to be costing a nominal lag so they kind of went over to East Hampton and like I said this was a counterculture enclave so what happened this was over in East Hampton I went to the so-called full moon experience it was uh it was supposed to be a full moon ceremony but it was conducted by witches yes and there are witches around so you know in this day and age when you go like into a courthouse you have to go through a metal detector and if it buzzes they use a little scanner to check to see if you have any kind of metal items you can't have any keys belt buckles or anything you have to take your belt off when you go through the the metal the metal thing to check to see if you have any kind of metal items they're not going to allow it but they'll hand it back to you if it's not dangerous like keys but you can't have any kind of any kind of metal when you go into the court there this is what's going on in this day and age but when I went to East Hampton they had a similar thing you entered a inner circle but instead of a metal detector they use smoke like I guess it was sage and they had the sage going around each person to kind of cleanse them from evil spirits yes there are evil spirits out and about and so they had used the cleansing of the sage and you'd stop and you'd get cleansed with the smoke and then you'd go into the inner circle and after we had a number of people going into the inner circle people would stand around and the witches would start to conduct their full moon ceremony now the full moon ceremony they were chanting various things I don't really know what they were chanting it was it was a form of witch talk yeah so they were giving some kind of spiritual witching type of conversation towards the moon and then they'd face in each direction they'd face say like north west southeast and they'd be doing their chanting and it was a very interesting experience and I don't remember all the details about the circle but they did have this chanting it was during the full moon and the full moon was out and everybody seemed to have an enjoyable time they were having you know a little get together afterwards people would be talking and having a good time and then some people left I happened to stay there because I thought it was an interesting gathering because like I said it was an alternative experience unfortunately if you have children you may not want to listen to this because all of a sudden the witches decided to get naked yes the witches got naked and went either into the hot tub or the sauna so I said to myself I guess I'm going to be getting naked and joining the witches at the hot tub at the sauna so there was nothing wrong with that because I was from the so-called counterculture so we were sitting in the hot tub there naked people there kind of relaxing there in the hot tub and then we'd go in the sauna and maybe go back to the hot tub it was it was an interesting experience and I'm rating that experience as a 10 not only because people were it was a co-ed naked witching experience but it was an interesting experience overall because it was a full moon ceremony and they were chanting now I rated that as a 10 I've had other types of experiences because I've worked part time and I had time to go and do other types of experiences now I could kind of go on and discuss other types of experiences I don't know if I should tell you about some of the UMass experiences because they weren't really part of the University of Massachusetts alumni secret society but one of my part time jobs was working at the Mullen Center cleaning up after events it was called the post event cleanup crew so we would go in after events such as basketball games hockey games rock concerts various events that that they had at the Mullen Center and the Mullen Center at that time when I was there was was run by Ogden entertainment now I think some other companies have taken over since I was there and I was there in the 90s so that was 20 years after I graduated from UMass now after one of the events at the Mullen Center I finished my cleanup and I started to head out and what do I see they had a track and field area over there near the Mullen Center so I was wondering what that was going on I I heard a lot of hooting and hollering over there at the at the track and I went to look and men and women were running around the track naked yes they were actually running around the track naked it was dark it was probably like I don't know after 10 o'clock at night and they were making a big ruckus there so I was going over there and checking out the people doing their racing their naked racing at the track now I know that the University of Massachusetts is a bastion of the establishment and they don't like any of these types of activities they crack down on any kind of activity that's not part of the establishmentarianist mentality just like they did in the 60s because when I was there in the 60s they actually had police that were in riot gear standing around with their riot outfits on because of the student protests that was because the University of Massachusetts did not like the students protesting so they were trying to crack down on all the protests this has happened in the 60s but now this was in the 90s and people were still running around naked they were regular students but then I would say after about a half an hour the UMass police came and chased them away because they were having too much fun they didn't like it the UMass police came over and chased them away they were running around the track naked and what eventually happened is that they got rid of that track they put something else in its place they didn't want people running around naked so they got rid of the track can you imagine that because that was really out of the way you couldn't really see anything I was there because I was working at the Mullins Center and I was coming outside and the track was kind of hidden out in the back of the Mullins Center so it wasn't like out in the part of the area where the public would see it and the UMass students probably didn't even know it was going on they probably contacted each other with their phones or some sort of communication that they were going to be having a co-ed naked track and field event that's what they were probably doing now track and field was not something that I was particularly interested in but I'm sure that if people were running around naked you would probably be having more people watching it than a regular track and field event but you know everybody in the society is rather conservative and they don't really like these kind of concepts but unfortunately now with a smartphone any Tom Dick and Harry or anybody else can be watching pornography on their smartphone that's why one of the reasons I don't particularly like the smartphone because now anybody has access to these programs now I think that elementary students may actually be able to access x-rated movies now because they have smartphones they they have like little second graders walking around with a smartphone and you know once they get the information they might be able to contact somebody and they'll tell them about some of these x-rated type of things that now there was nothing like that when I had my little watch man the Sony watch man because that was the broadcasters and the broadcasters would have regular programs they wouldn't have pornography and all this other stuff that's now out and about on the internet that anybody can be checking out even elementary students can you imagine elementary students watching pornography and now you know they were probably upset when I was growing up I was watching hop along Cassidy and people shooting each other and they were all bent out of shape because they were shooting guns but now people are watching pornography instead oh my god they're actually watching all these other things they don't want to be watching westerns that's actually something that people don't even probably watch anymore they're not particularly interested in some of those kind of programs they have to actually make them extremely violent in this day and age in order for people to be interested in watching them I saw a program on cable just before I ended watching cable I had cable for a period of time and I was watching some program and boy was it violent it was it was one of the most violent programs I ever saw it was an extremely violent program and I I couldn't take it anymore and that was not the type of a cowboy program that was in the 50s and the 60s that this this program was extremely violent and I I I couldn't take it now this is what's offered on cable television and now like I said elementary students can watch these kind of programs now because you don't have the regular programs that they used to have years ago they could just watch any kind of program they want on television because they have cable and students of all ages can be watching all of these kind of programs the it's uh it's really kind of too bad that television has kind of gone so far downhill that you can't really watch some of these programs they probably have some some kind of thing that controls it so uh young people can't watch some of these programs I'm sure that they have some of these kind of electronic devices that control uh of viewing but in my opinion that some of these programs can be watched you know some kid could go over to his friend's house and watch a program he doesn't have to be watching it at his own house there he can basically just go to one of his friend's house and they'll get together and watch one of these programs it doesn't really matter what the program is it could be an x-rated program they'll say come on over we're going to be watching some pornography some nine years old nine-year-old kids they'll say let's come over here my parents are uh out bowling or something and we'll be here and we're going to be watching some porn so this is what the society has come to we can't have a little watchman and watch our little local programs now you have to be having cable satellite you got the internet you got all these things that kids are watching and it's just too bad that our society has come to the point that you can't even be leaving the house without worrying that something's going to be happening there now people do have children in this day and age but in my opinion that that's going to be uh something that people may kind of decide in the future that they may not want to be doing now i think i mentioned about ectogenesis ectogenesis is birth outside of the womb and we're now at the point that we can create life not inside a person but outside of the person's body this is called ectogenesis and you might be able to use some of these things like crisper crisper or something to manipulate genes and create some of these types of things that people think they said well we don't want these kind of diseases so we're going to try to eliminate them but you know who knows what's going to happen you know because we have these these people that are going to be trying to manipulate uh the embryos and try to create some kind of superhuman there and uh of course you know a superhuman might be in our future but uh we may not be able to deal with this they'll probably try to have laws to limit ectogenesis but it the laws can only uh control the people in your country and we have quite a number of countries around the world and people could go out and do something in some other country perhaps even china or north korea and uh they could create something over there and uh people can't really control it now north korea is an outlaw country and it's not going to subscribe to some of these things that the west subscribes to north korea has their own agenda and they want to do things their own way they don't want the outside world to control what they're doing now if north korea decides that they want to be involved with ectogenesis and they're going to create some kind of super humans that's up to them and it's going to be difficult for us to control it just like we can't control their nuclear program we try to negotiate with people like the north koreans but you know they're probably hiding somewhere underground so satellites and things like that can't keep track of what activities they are doing i'm sure that they have plenty of things going on underground underground is outside of the uh the view of satellites we have all these satellites that are going around and trying to keep track of all these outlaw countries but everybody knows that you know if you're going to be going out in public in this day and age you're probably going to be seen by a satellite that's why we don't really have much nudity anymore you'll probably have uh people that might be uh sunbathing naked somewhere thinking that you know they're out in you know somewhere some kind of isolated beach or something but satellites are probably flying over and getting pictures of them because we have so many satellites flying around so you can't even go out swimming anymore i know that uh people do have a tendency to want to get away from it all but you can't really get away from it all in this day and age now uh i'm i actually have uh some information that you know you might be interested in about ectogenesis but i'm not going to be discussing it because the government seems to probably keep keep that information as you know it's uh it's classified information they don't want people to know about it now just like some of these other things the government has things going on that the public generally doesn't know about this is what happened with uh a trump in the sense that we have a shadow government which has probably been around since the civil war because the government was concerned in case the confederacy when the war in washington dc set up a shadow government in case washington dc was overcome by confederates of course it didn't happen that way but they probably considered a shadow government and the shadow government has been a concept that's been around for a number of years like i said probably since the civil war but i would say since we had the atomic bombings in japan in the 1945 and then people started making atomic weapons i think that we started full force in the shadow government business because in case of washington dc getting nuked we needed to have a shadow government now trump did have a kind of a shadow government private lawyer being a representative of this shadow government and they were investigating you know this lawyer that trump is using but it's been going on for years and years there was a shadow government they said that oh we can't have a shadow government coming over and doing stuff with these other governments but the shadow government has been around for years on end it's just that they didn't want to discuss it trump kind of blew it by having these these kind of things and people that didn't like trump wanted to expose the fact that he was doing these other kinds of things which probably has been going on for the last 50 years but they didn't like trump so they described they decided to tell it like it is that he had juliani was doing business as part of the shadow government now the shadow government is a thing that we have because of the nuclear threat we need to have people that will be able to continue doing the government business even though we might be having a nuclear war or say we might be having cyber warfare i mentioned this on a program about cyber warfare cyber warfare is going to be happening sooner or later and it would probably be more likely than a nuclear war cyber warfare you could just stay in some country and just use your computers and destroy some other country's computer system this is what i think is the most likely thing that's going to be happening in the future now if you think that we're not going to be having cyber warfare cyber warfare is is being done by all these countries now because they're concerned that the united states because of the the information that was given out you know that the national security agency was spilling on all these things including the american people and people were bent how to shape about it but this stuff has been going on like i said 60 minutes had a program 20 years ago somebody was talking about bombing in the theater program and the government came by and wanted to see what was going on so people are now concerned that there's going to be other types of things that's going to be going on especially now that we have all types of people coming into the united states and that was why trump wanted to try to limit immigration because we're trying to keep track of who's coming into the united states it's not really uh something like discrimination in the sense because we're trying to keep track of who's coming into the united states now i know that we're being overrun by a lot of people but you know we need to have some kind of identification of all these people so they're all needing to have some kind of special id that's why i i'm kind of thinking that this new id that's going to be required now people are going to be needing this special id i guess it's a federal id the uh the uh what is it called now the uh the smart id the real id that you're going to be required to be caring like if you're going to go on an airplane or something but now my boss at my job said that i'll be required to get this new id now because i have a delivery job and i have to be having one of these new id's and my license isn't going to expire for another two years but now i have to be getting this federal id because i'm going to be making deliveries and i might get stopped by the police and the police are going to be investigating and making sure that i'm i'm a legitimate citizen so i need a legitimate id can you imagine now in this day and age we have to be having the federal government is going to be issuing our id's i'm sure that they're going to be giving these special id's the first graders now you'll be going to school and instead of being required just to have shots you'll be required to have a special federal id to go to a public school otherwise you may not be able to show up in the school until you have your federal id and what's going to happen people are not going to be able to go to school if they don't have an id oh my god they're going to have to be homeschooled can you imagine that being homeschooled boy you won't be contaminated by society when you're homeschooled you're going to be ending up getting information from your parents and from other people that are in the inner circle of your parents now your parents may be qualified to teach you but they may not be qualified to teach all subjects so you might really need to be having some access to some kind of public schooling or at least private schooling the private schooling system is is actually pretty good and they do have really good people that are teaching in private schools but some people can't afford to go to a private school those schools are fairly expensive now i i i don't want to keep going on and on and on here because i'm going to be making some more programs in the future this is just a program here because i'm kind of a voice from the past i could be uh talking from a cemetery who knows now the cemeteries do have information about people you go walking around in the cemetery and you'll see some information about people but it's not like information that the government is trying to collect on us now so we're having now the government and all the corporations everybody trying to get information on you they want to know all about your business they want to know everything about you they it's like what's going to be happening now we can't even go to school without an id you know what uh maybe that's going to apply for preschoolers i personally did not go to a preschool because i went to school in the fifties we were not required to go to a preschool or a kindergarten i went right into the first grade so i did not have that type of experience that people have nowadays like i said i grew up watching hop along castity people probably years later grew up watching you know like uh some of these other things like uh sesame street and some of these other things which uh you know the childish programs but it's not like hop along castity they were having shootouts and things you know people were kind of upset because they didn't like uh the westerns and their shootouts now they prefer to let the kids watch all kinds of stuff on the internet wow there's nothing wrong with hop along castity i think that that was a pretty wholesome program but the thing is that he used to wear black and people were concerned because hop along castity was wearing black and he was shooting people and it was a really popular program but he was a good guy wearing black he wasn't a bad guy nowadays if you walk around wearing black somebody might be suspicious and think that you might be portraying yourself as some kind of person from the university of massachusetts alumni secret society the secret society that we might be wearing black but as you know i was dressed in white because that was a representation of an alternative type of presentation you have the black and the white it's like uh you know the yin and the yang there's the opposites there we have a different point of view now nothing wrong with the university of massachusetts alumni secret society but the secret society tends to like to be involved with things like witchcraft because witchcraft has been around for years and years and then you know what happened in salem massachusetts now if you don't know what happened that's on you they attack the witches now witches can be out in the open and they can be going naked in the hot tub with their fellow followers so that's the kind of life that we should be considering we should consider witchcraft as one of the religions that should be classified as a religion that people would be able to get a discount on their taxes because it's like a church you know it'd be the church of the witches you know we could have a bunch of hot tops inside the church there and people will go to church and they'd get naked and they'd be having their ceremony there now that way then we would have an alternative religion now there's nothing wrong with alternative religions there are a lot of religions around the world and some of them are very extremist as i must as i say that some of the people get too extreme and they claim that they don't like the other person's religion so they attack them attacking somebody because of their religion seems to be a little bit out of touch with reality because we don't really know what religion is going to be the primary religion because religion is talking about people when they die now i could make a claim that you know when people die the bad people like like go to a black hole a black hole they're black holes and we know about these black holes out in space but they don't really know anything about the black hole well let's say my religion says you die and you're a bad person you go to a black hole now who's going to say that's right and who's going to say that's wrong we don't know anything about black hole we don't know what happens when you die you think that you might be going to a place called heaven or hell but we don't really know if this is real or not we real these are just concepts that we have developed over the centuries and people say that we're going to go to heaven well what does heaven mean it depends on the eye of the beholder some people might think that heaven might be people all dressed in white and some other people might say heaven might be just people sitting around and watching television watching all the people on earth doing earthly types of activities who knows what's going to be happening in heaven we are just kind of thinking that there's all kinds of things going on in heaven but we don't really know exactly what it is we're just conceiving what it is we're just thinking well there's a heaven what does heaven mean that means something to somebody and something to somebody else they might think heaven might be a place where people could be sitting around naked and sitting in a hot tub that might be heaven to them but then somebody else might say that heaven might be the idea of a creating life by means of ectogenesis that we're creating our own life well that could be a form of heavenly experience but we don't know for sure ectogenesis is right in the process of developing but the government doesn't want people to know about because ectogenesis is one of those secret government programs that the government is trying to look into and like I said people may want to instead of having an abortion they would bring their embryo to the ectogenesis clinic and they would have the person develop outside of the womb now that would mean that we would have no more abortions but you know people would probably be bent out of shape about that concept as well because everybody seems to have their own ideas about what they should have and what they should not have this is just what our society is everybody's brain is as individual as their faces can you imagine that everybody has an individual perspective now I have a picture of a cemetery here that you're looking at and as far as I know there might be spirits at the cemetery and in my opinion there are spirits amongst us now some people don't believe in that idea some people do and I do have pictures of people that have spirits in the pictures there I bought a time life magazine about mysteries and they had a picture of a couple there was a spirit in the background and I did see a book at bonds and noble that had pictures of people and you'd see a spirit in the background there and these were pictures that were taken years ago it wasn't doctored by a computer these were actual pictures that were taken say like 70 years ago years years ago and you'd see spirits in the pictures along with the real people so I have my picture here I have my picture and I have the cemetery and there's skeletons sitting around the cemetery but in my opinion the skeletons aren't actually going to be moving around I think the spirits however it will be moving around the cemetery so they might actually be coming back to the cemetery they might go have an excursion somewhere they'll go back to their final resting place because some of these spirits are probably restless and they want to get up and go see what's going on so let's let's leave it at that I'm gonna let you contemplate the meaning of life because existentialism is an attitude and an outlook which emphasizes human existence and the qualities which are distinctive in individual persons as opposed to man and abstract nature or the world in general remember that as you go through life in these troubled times now I'm going to let you go for the time being here and we're going to continue with this program I may and I may not show up like I did in the past because I'm concerned about people trying to figure out who I am am I a member of the University of Massachusetts alumni secret society or am I a part of the government well the government would allow me to be discussing these things there they would probably come over and arrest me if I was talking about ectogenesis so you need to kind of check into some of these things yourself ectogenesis is coming but there's also other things coming in the future so you may have to be dealing with some of these things here just be careful what you do with your smartphone it's not like a sony watch man and with that I'm gonna say have a good day and a good night