CHENNAKESHAVA RAMESH
CHENNAKESHAVA RAMESH
  • 28
  • 270 432
size
checking sizes of objects , table , index, tablespace, database in postgres.
zhlédnutí: 3 208

Video

monitoring in postgres
zhlédnutí 8KPřed 5 lety
Basic concepts of monitoring. What need to be monitored in postgres. What level monitoring has to be done.
bloat
zhlédnutí 3,5KPřed 5 lety
Bloat in postgresql. How to remove bloat. Vacuum full command purpose.
autovacuuum
zhlédnutí 7KPřed 5 lety
Autovacuum in Postgresql. Important parameters for autovacuum background process.
memory parameters in postgres
zhlédnutí 9KPřed 5 lety
Memory parameters in postgres and values to set.
build from source
zhlédnutí 1,8KPřed 5 lety
Installing the postgres from source code. Build from source option. Custom installation. Customizing the postgres parameters during installation. Changing the default behavior of postgres during installation.
replication concepts in postgres
zhlédnutí 30KPřed 5 lety
Various replication options in postgres warm standby and streaming replication . Hot standby concept.
pg basebackup demo
zhlédnutí 7KPřed 5 lety
pg_basebackup utility demo for taking the hot backup of the cluster.
maintenance activities in postgres
zhlédnutí 9KPřed 5 lety
basic maintenance activities in postgres . vacuum, analyze , reindex.
cold and hot backup in postgres
zhlédnutí 11KPřed 5 lety
Cold and hot backup /restore in postgres
pgdump backup restore
zhlédnutí 34KPřed 5 lety
backup and restore options in postgres ( pg_dump, pg_dumpall , psql, pg_restore) with examples.
password file in postgres
zhlédnutí 7KPřed 5 lety
pgpass file demo in postgres. Password file concept. Password file description and demo of it.
folder layout and oid in postgres
zhlédnutí 4,3KPřed 5 lety
Description of folder layout and OID in postgres.
tablespace concept in postgres
zhlédnutí 10KPřed 5 lety
tablespace concept in postgres
schema in postgres
zhlédnutí 10KPřed 5 lety
Concept of schema in postgres. How to create a new schema. How to create objects in new schema.
user creation in postgres
zhlédnutí 5KPřed 5 lety
user creation in postgres
roles and privileges in postgres
zhlédnutí 17KPřed 5 lety
roles and privileges in postgres
postgresql conf demo
zhlédnutí 10KPřed 5 lety
postgresql conf demo
pg hba conf demo
zhlédnutí 9KPřed 5 lety
pg hba conf demo
background process in postgres
zhlédnutí 7KPřed 5 lety
background process in postgres
system catalog tables
zhlédnutí 3,9KPřed 5 lety
system catalog tables
postgres architecture overview
zhlédnutí 33KPřed 5 lety
postgres architecture overview
psql interface commands
zhlédnutí 3,1KPřed 5 lety
psql interface commands
connecting to cluster
zhlédnutí 3,7KPřed 5 lety
connecting to cluster
pg ctl for starting stopping cluster
zhlédnutí 4,8KPřed 5 lety
pg ctl for starting stopping cluster
creating clusters in postgres
zhlédnutí 15KPřed 5 lety
creating clusters in postgres
postgresql 10 installation using EDB software
zhlédnutí 1,9KPřed 5 lety
postgresql 10 installation using EDB software
postgres download options
zhlédnutí 1,4KPřed 5 lety
postgres download options

Komentáře

  • @RamyafromBahrain
    @RamyafromBahrain Před měsícem

    Sir your explaination makae a confident in my learning Thank you...

  • @Truth-qe6sf
    @Truth-qe6sf Před měsícem

    wonderful

  • @amerkhan8411
    @amerkhan8411 Před měsícem

    Very informative session. Can you please upload the latest version video's as well.

  • @bakrabou3883
    @bakrabou3883 Před měsícem

    hi,please i have a problem alter my iods with upgrade sent me you email i check you

  • @afrozkhan9524
    @afrozkhan9524 Před 3 měsíci

    what if i need to append the data only? because client ask us to restore the database again and again. then which parameter we must use?

  • @VTS_99
    @VTS_99 Před 8 měsíci

    Even in 2023 , these Video's are GEM.. Excellent training... very precise and to the point. Just sheer quality , but even after researching a lot about RAMESH ji couldn't find him anywhere .. LN etc.

  • @ajaypattni5921
    @ajaypattni5921 Před 10 měsíci

    for cluster creation before we must install postgres in system?

  • @TheAmit738
    @TheAmit738 Před 11 měsíci

    how to create a hidden objects in postgresql , like oracle supports ?

  • @durgaprasadpj
    @durgaprasadpj Před rokem

    Hi, Ramesh gaaru. can you please send me the exact config files for postgresql version 12 if you have.

  • @kuchipudi862
    @kuchipudi862 Před rokem

    New batch epudu start chestaru sir

  • @cjbarroso
    @cjbarroso Před rokem

    thank you!

  • @ABIHASHIM
    @ABIHASHIM Před rokem

    Where is the second server, how do we can say the given is single host cluster? or there is another video for basic installation

  • @xopen20
    @xopen20 Před rokem

    thanks!

  • @Cult-Fan
    @Cult-Fan Před rokem

    By default it will create or we need create password file later installation

  • @factology6251
    @factology6251 Před rokem

    Thank you so much sir 😌

  • @jugalrajanvekar9461

    good video. thanks

  • @konsole_kris1984
    @konsole_kris1984 Před rokem

    This video is still helping people in 2020!!

  • @dev-skills
    @dev-skills Před rokem

    0:45 - WAL stands for Write Ahead Logs.

  • @puneetmathur
    @puneetmathur Před rokem

    Hi Ramesh. Very nice video series. Extremely helpful. May I ask - once a client authenticates through postmaster, does the newly spawned postgres process listen on a different port? On my firewall between client/app & db server, would I need to enable a range of ports or just the postmaster port? Thanks in advance.

  • @mohammedghouse751
    @mohammedghouse751 Před rokem

    I want complete class of postgersql If there is offline class tell me addres sir ,contact number sir

  • @vikramr1329
    @vikramr1329 Před rokem

    Super and Excellent video. Easy to understand. Keep It UP. Thank you

  • @premkumarkakarlamudi4757

    Excellent session..

  • @rohanekar
    @rohanekar Před 2 lety

    Can you share your email id I need help on db side

  • @patriciailin1369
    @patriciailin1369 Před 2 lety

    Really enjoyed this, thank you. Most clear explanation! Loved the example with the two users side by side!

  • @chiblackjesus
    @chiblackjesus Před 2 lety

    Finally what I was looking for, thank you

  • @alexislychine9199
    @alexislychine9199 Před 2 lety

    You’re great.

  • @ravulapallivenkat8640

    Tq ramesh

  • @rajareddy3848
    @rajareddy3848 Před 2 lety

    Hi bro postgresql dba online batch unda bro

  • @osamamaqdam7142
    @osamamaqdam7142 Před 2 lety

    I didn’t understand shit

  • @majedsedky6084
    @majedsedky6084 Před 2 lety

    is the above slides avalible

  • @VK-fr5mc
    @VK-fr5mc Před 2 lety

    Thank You !🙏

  • @VK-fr5mc
    @VK-fr5mc Před 2 lety

    Thank you !! 🙏

  • @chinnu1981
    @chinnu1981 Před 2 lety

    Clear and crisp video. Thanks!!!

  • @kuchipudi862
    @kuchipudi862 Před 2 lety

    Hi anna plz give me your ph no . i learn postgressql. i want postgresql material anna. and full videos anna

  • @sarfarazalam6781
    @sarfarazalam6781 Před 2 lety

    Well Explained.

  • @adityasethi9794
    @adityasethi9794 Před 2 lety

    One of the most clear videos I've seen. Had to leave a comment. How did you create two users in the first place?

  • @aviroxi
    @aviroxi Před 2 lety

    thank you so much sir

  • @AmeerulIslam
    @AmeerulIslam Před 2 lety

    I'm trying to increase the speed of madlib (you can say it's ML functions pg libraries) functions in my postgres db. My functions are in postgres itself. How do I improve the speed?

  • @parthasarathynarasimmaram8062

    Sir, would you be conducting any postgres training? Anything upcoming i would like to know

  • @muneert9407
    @muneert9407 Před 2 lety

    h ow can i do : pg_restore: [archiver] input file appears to be a text format dump. please use psql.

  • @alexislychine9199
    @alexislychine9199 Před 2 lety

    I really appreciate this video

  • @sameerali4986
    @sameerali4986 Před 3 lety

    pg_restore: error: could not find header for file "toc.dat" in tar archive , Im getting this error when restore to postgresql using both commandline or pgadmin 4

  • @user-ih7ot7vl8u
    @user-ih7ot7vl8u Před 3 lety

    Thank you for your nice demo... My question, how can we restore data after doing backup..?? 🌹🌹🌹🌹🌹

  • @MrBHASKARSOMASANI
    @MrBHASKARSOMASANI Před 3 lety

    very helpfull

  • @eramkrish1
    @eramkrish1 Před 3 lety

    How to make db using existing oid folder?

  • @supriyakulkarni4610
    @supriyakulkarni4610 Před 3 lety

    Very nice video. Looking forward to more videos from you.

  • @tradernse7245
    @tradernse7245 Před 3 lety

    Gone through most of the videos. I can bet all in on your teaching skills.. No one can explain postgresql as simple as you did. Regards, Ami

  • @sajeevguru7151
    @sajeevguru7151 Před 3 lety

    Hi sir , Do you have the document for replication streaming setup ?

  • @portBerg
    @portBerg Před 3 lety

    Hi in which folder (the full path )should I exactly place the pgpass.conf file. I have placed it in c:\users\myname\AppData\Roaming\postgresql\pgpass.conf. but still I got the error psql: fe_sendauth no password supplied.