Benson Yerimah
Benson Yerimah
  • 14
  • 53 324
PGBOUNCER SERVER/CLIENT TLS CONFIGURATION
Demo on how to setup TLS for pgbouncer ( server/client)
มุมมอง: 1 031

วีดีโอ

Windows LDAP with Ubuntu
มุมมอง 9952 ปีที่แล้ว
Windows LDAP with Ubuntu
OpenLDAP on Ubuntu for Postgres authentication
มุมมอง 1.7K3 ปีที่แล้ว
OpenLDAP on Ubuntu for Postgres authentication
AD LDAP SETUP WITH POSTGRES ON LINUX
มุมมอง 3.2K3 ปีที่แล้ว
Using Windows AD LDAP to authenticate postgres running on Linux
pg auto failover setup
มุมมอง 5K3 ปีที่แล้ว
This is a five node (one master, two standby, one monitor and one application) demo of pg_auto_failover .pg_auto_failover is an extension for PostgreSQL that monitors and manages failover for a postgres clusters. It is optimized for simplicity and correctness.
Installation, setup and HA on mongo dB
มุมมอง 1123 ปีที่แล้ว
- INSTALLING MONGODB - SETUP AUTHORIZATION - CREATE USERS,DBS AND COLLECTIONS - SETUP REPLICATION (REPLICASETS) - PERFORM FAILOVER - HOW TO REVERT TO FORMER PRIMARY - SETUP REPLICASETS WITH AN EXISTING MONGODB INSTANCE - INSTALLING AND USING MONGODB COMPASS
Custom Postgres Installation. I have four different methods provided
มุมมอง 4763 ปีที่แล้ว
This is just a demo to show how to install postgres on a custom location. Different methods of performing this has been provided. you can look the method that works for you. And if you have any questions or suggestions, let us know
BARMAN (Backup and Recovery Manager) rsync/ssh, incremental and geographical redundancy
มุมมอง 9643 ปีที่แล้ว
This video shows how to configure barman rsync/ssh, doing incremental backups, geographical redundancy, using barman-wal-archive and barman-wal-restore
BARMAN (Backup and Recovery Manager) EXPLAINED AND CONFIGURED
มุมมอง 3.8K3 ปีที่แล้ว
The is video walks through a couple of BARMAN features, and also a demo on BARMAN configurations. In This Demo we saw how to install, configure WAL stream and WAL archive, look at some command line tools, performed local recovery, remote recovery and point in time recovery (PITR).
INSTALLING MYSQL ON CENTOS, UBUNTU AND DEBIAN. CONNECTING USING MYSQL WORKBENCH
มุมมอง 1073 ปีที่แล้ว
INSTALLING MYSQL ON CENTOS, UBUNTU AND DEBIAN. CONNECTING USING MYSQL WORKBENCH
Kerberos Authentication Setup With Postgres on Linux
มุมมอง 2.7K3 ปีที่แล้ว
This is just a Basic introduction and setup of Kerberos authentication with postgres.
Setup and Monitoring SQL Server AG with IDERA
มุมมอง 7223 ปีที่แล้ว
This is just a follow-up video of the SQL server AG setup which i did earlier. I received some question on which tool could be used to monitor the SQL server setup. I choose to install IDERA. I know there are a lot of tools out there but i see this to easy and very helpful. So must of the configuration here are at their default.
SQL Server AlwaysOn Availability Groups step by step setup
มุมมอง 30K3 ปีที่แล้ว
This is just a video to show how to install and configure Always On availability groups. Let me know if you enjoy the video and any comments you have.
LDAP and TLS Configuration with PostgreSQL
มุมมอง 2.1K3 ปีที่แล้ว
This is just a video which shows the complete LDAP and TLS installation and configuration. It also shoes how to install and setup PostgreSQL to be used by it. Again this does not go into detail of explaining every ldap parameter and file. If you need to understand all ldap setting, then will do another video.

ความคิดเห็น

  • @shivajangam3691
    @shivajangam3691 2 หลายเดือนก่อน

    What was the linux version you have used. Please let me know

  • @jerryrafidimanana877
    @jerryrafidimanana877 4 หลายเดือนก่อน

    great thanks

  • @trevorkohlman5451
    @trevorkohlman5451 6 หลายเดือนก่อน

    Does this work for AD groups? If yes can you show that!

  • @labibchy9293
    @labibchy9293 9 หลายเดือนก่อน

    how can I connect to you bro ?

  • @ErdalCamiroglu
    @ErdalCamiroglu 10 หลายเดือนก่อน

    Thanks a lot mate.

  • @deniskirichenko1055
    @deniskirichenko1055 ปีที่แล้ว

    Man, you are a live safer thanks a lot for such detailed guide :)

  • @venum-k2p
    @venum-k2p ปีที่แล้ว

    Hello Benson, thanks for this wonderful video. Is it possible to authenticate users via LDAP groups in open source postgresql? For example if I add DBA group in pg_hba and create one role for that group in postgres, all users in DBA group should access postgres services

  • @ЙорданПарладийски
    @ЙорданПарладийски ปีที่แล้ว

    is replication works on all data bases or it work only on "autodb" in your case ?

  • @mlugrassi
    @mlugrassi ปีที่แล้ว

    Does this work for usergroups too? What about database user permissions? Do I necessarily need to apply the grants or give createdb, createrole, etc permissions necessarily in postgres? Isn't there a way to do everything on the Windows LDAP server? Imagine if I have several postgres servers with the same users, I would have to go one by one and create them, isn't there a more practical way?

  • @francisopiyo2332
    @francisopiyo2332 ปีที่แล้ว

    There is separate video on SQL server AG configuration and see you adding an additional startup parameter -T9532. Help me understand the purpose. Sorry I could not comment on the video because comments are turned off therein.

  • @carolinefotso683
    @carolinefotso683 ปีที่แล้ว

    good explanation

  • @ikhsan__8086
    @ikhsan__8086 ปีที่แล้ว

    love that troubleshoot section😁 keep it up

  • @Paulwall9696
    @Paulwall9696 ปีที่แล้ว

    Such an informational video. I will have to watch all of the videos you make.

  • @FrankieTheOne
    @FrankieTheOne ปีที่แล้ว

    the point was to not use the password in the linux server. Kills the point if u have to type it. Might as well just create the user right in postgres

  • @nikhamdel5108
    @nikhamdel5108 2 ปีที่แล้ว

    I have accidentally deleted database .I don't have any backup . could you please tell me what to do?

  • @ManishYadav-tj5jp
    @ManishYadav-tj5jp 2 ปีที่แล้ว

    Hi Benson, really great explanation and compilation of all the components. It's a great help. 👍

  • @MrAkshaygore
    @MrAkshaygore 2 ปีที่แล้ว

    Goggle drive link

  • @MrAkshaygore
    @MrAkshaygore 2 ปีที่แล้ว

    Hi, Could u please share...commands used in this video

  • @SRUJANCH21
    @SRUJANCH21 2 ปีที่แล้ว

    Thanks for making this video, it helped me lot

  • @oshari22
    @oshari22 2 ปีที่แล้ว

    Thanks for the tutorial can I use a floating ip for the database connection?

  • @charleneroot4697
    @charleneroot4697 2 ปีที่แล้ว

    Great explanation

  • @BJ-cb3ck
    @BJ-cb3ck 2 ปีที่แล้ว

    If a public user forgets the password, how do you allow that user to update his credentials ("forgot password?) (Username and/or password) using his own browser using this authentication process, assuming there are thousands of users

  • @ramakuswidyawan1046
    @ramakuswidyawan1046 3 ปีที่แล้ว

    Hi, i have followed your steps, but at the end i try to connect from windows vm, and i got error: SSPI continuation error. The specified target is unkown or unreachable (80090303) Can you help me to tell the cause and solution?

  • @rtm1717
    @rtm1717 3 ปีที่แล้ว

    Thanks man, maybe you have solution with cassandra and redis cli connect via ldap? :)

  • @telagam
    @telagam 3 ปีที่แล้ว

    Very Informative tnx for your hard work. keep doing

  • @richieoprah3491
    @richieoprah3491 3 ปีที่แล้ว

    Nice article sir, so basically you need three servers if you are using kerberos us you authentication mechinisim ? I will try it out on my test servers and see if it works for me. Can all this be done on only one server instead of three servers ?

  • @arunprasad4353
    @arunprasad4353 3 ปีที่แล้ว

    Hi Benson. Thanks for posting this video. I have a question about how the user is being authenticated via psql? Is it just verifying whether the role is available in the db? How is the postgres principle that you created is helping here?

    • @bensonyerimah2224
      @bensonyerimah2224 3 ปีที่แล้ว

      The user must be available in the KDC database and also in Postgres. this user must have gone through the authentication process in kdc and finally obtain the service ticket which will need to be validated in PostgreSQL since we have the keytab file in the postgresql.conf. Let me know if you need further explanation as there are a lot of pieces with Kerberos authentication

    • @arunprasad4353
      @arunprasad4353 3 ปีที่แล้ว

      ​@@bensonyerimah2224 , Thanks for the explanation. Now I understand how an individual user is authenticated via KDC. I will try to setup my own test environment and play around with it. Keep up your good work. :) Cheers!