CHENNAKESHAVA RAMESH (POSTGRES TRAINING)
CHENNAKESHAVA RAMESH (POSTGRES TRAINING)
  • Видео 28
  • Просмотров 273 630
size
checking sizes of objects , table , index, tablespace, database in postgres.
Просмотров: 3 238

Видео

monitoring in postgres
Просмотров 8 тыс.5 лет назад
Basic concepts of monitoring. What need to be monitored in postgres. What level monitoring has to be done.
bloat
Просмотров 3,5 тыс.5 лет назад
Bloat in postgresql. How to remove bloat. Vacuum full command purpose.
autovacuuum
Просмотров 7 тыс.5 лет назад
Autovacuum in Postgresql. Important parameters for autovacuum background process.
memory parameters in postgres
Просмотров 9 тыс.5 лет назад
Memory parameters in postgres and values to set.
build from source
Просмотров 1,8 тыс.5 лет назад
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
Просмотров 30 тыс.5 лет назад
Various replication options in postgres warm standby and streaming replication . Hot standby concept.
pg basebackup demo
Просмотров 7 тыс.5 лет назад
pg_basebackup utility demo for taking the hot backup of the cluster.
maintenance activities in postgres
Просмотров 9 тыс.5 лет назад
basic maintenance activities in postgres . vacuum, analyze , reindex.
cold and hot backup in postgres
Просмотров 11 тыс.5 лет назад
Cold and hot backup /restore in postgres
pgdump backup restore
Просмотров 35 тыс.5 лет назад
backup and restore options in postgres ( pg_dump, pg_dumpall , psql, pg_restore) with examples.
password file in postgres
Просмотров 7 тыс.5 лет назад
pgpass file demo in postgres. Password file concept. Password file description and demo of it.
folder layout and oid in postgres
Просмотров 4,3 тыс.5 лет назад
Description of folder layout and OID in postgres.
tablespace concept in postgres
Просмотров 10 тыс.5 лет назад
tablespace concept in postgres
schema in postgres
Просмотров 10 тыс.5 лет назад
Concept of schema in postgres. How to create a new schema. How to create objects in new schema.
user creation in postgres
Просмотров 5 тыс.5 лет назад
user creation in postgres
roles and privileges in postgres
Просмотров 18 тыс.5 лет назад
roles and privileges in postgres
postgresql conf demo
Просмотров 10 тыс.5 лет назад
postgresql conf demo
pg hba conf demo
Просмотров 9 тыс.5 лет назад
pg hba conf demo
background process in postgres
Просмотров 8 тыс.5 лет назад
background process in postgres
system catalog tables
Просмотров 3,9 тыс.5 лет назад
system catalog tables
postgres architecture overview
Просмотров 33 тыс.5 лет назад
postgres architecture overview
psql interface commands
Просмотров 3,2 тыс.5 лет назад
psql interface commands
connecting to cluster
Просмотров 3,8 тыс.5 лет назад
connecting to cluster
pg ctl for starting stopping cluster
Просмотров 4,9 тыс.5 лет назад
pg ctl for starting stopping cluster
creating clusters in postgres
Просмотров 16 тыс.5 лет назад
creating clusters in postgres
postgresql 10 installation using EDB software
Просмотров 1,9 тыс.5 лет назад
postgresql 10 installation using EDB software
postgres download options
Просмотров 1,4 тыс.5 лет назад
postgres download options

Комментарии

  • @PostgreSQLDBA
    @PostgreSQLDBA 25 дней назад

    Very good information. Point to point explanation

  • @RamyafromBahrain
    @RamyafromBahrain 3 месяца назад

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

  • @Truth-qe6sf
    @Truth-qe6sf 3 месяца назад

    wonderful

  • @amerkhan8411
    @amerkhan8411 3 месяца назад

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

  • @bakrabou3883
    @bakrabou3883 4 месяца назад

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

  • @afrozkhan9524
    @afrozkhan9524 5 месяцев назад

    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 10 месяцев назад

    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 Год назад

    for cluster creation before we must install postgres in system?

  • @TheAmit738
    @TheAmit738 Год назад

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

  • @durgaprasadpj
    @durgaprasadpj Год назад

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

  • @kuchipudi862
    @kuchipudi862 Год назад

    New batch epudu start chestaru sir

  • @cjbarroso
    @cjbarroso Год назад

    thank you!

  • @ABIHASHIM
    @ABIHASHIM Год назад

    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 Год назад

    thanks!

  • @Cult-Fan
    @Cult-Fan Год назад

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

  • @factology6251
    @factology6251 Год назад

    Thank you so much sir 😌

  • @jugalrajanvekar9461
    @jugalrajanvekar9461 Год назад

    good video. thanks

  • @konsole_kris1984
    @konsole_kris1984 Год назад

    This video is still helping people in 2020!!

  • @dev-skills
    @dev-skills 2 года назад

    0:45 - WAL stands for Write Ahead Logs.

  • @puneetmathur
    @puneetmathur 2 года назад

    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 2 года назад

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

  • @vikramr1329
    @vikramr1329 2 года назад

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

  • @premkumarkakarlamudi4757
    @premkumarkakarlamudi4757 2 года назад

    Excellent session..

  • @rohanekar
    @rohanekar 2 года назад

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

  • @patriciailin1369
    @patriciailin1369 2 года назад

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

  • @chiblackjesus
    @chiblackjesus 2 года назад

    Finally what I was looking for, thank you

  • @alexislychine9199
    @alexislychine9199 2 года назад

    You’re great.

  • @ravulapallivenkat8640
    @ravulapallivenkat8640 2 года назад

    Tq ramesh

  • @rajareddy3848
    @rajareddy3848 2 года назад

    Hi bro postgresql dba online batch unda bro

  • @osamamaqdam7142
    @osamamaqdam7142 2 года назад

    I didn’t understand shit

  • @majedsedky6084
    @majedsedky6084 2 года назад

    is the above slides avalible

  • @VK-fr5mc
    @VK-fr5mc 2 года назад

    Thank You !🙏

  • @VK-fr5mc
    @VK-fr5mc 2 года назад

    Thank you !! 🙏

  • @chinnu1981
    @chinnu1981 2 года назад

    Clear and crisp video. Thanks!!!

  • @kuchipudi862
    @kuchipudi862 3 года назад

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

  • @sarfarazalam6781
    @sarfarazalam6781 3 года назад

    Well Explained.

  • @adityasethi9794
    @adityasethi9794 3 года назад

    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 3 года назад

    thank you so much sir

  • @AmeerulIslam
    @AmeerulIslam 3 года назад

    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
    @parthasarathynarasimmaram8062 3 года назад

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

  • @muneert9407
    @muneert9407 3 года назад

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

  • @alexislychine9199
    @alexislychine9199 3 года назад

    I really appreciate this video

  • @sameerali4986
    @sameerali4986 3 года назад

    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

  • @عابثالأخير-ز9ي
    @عابثالأخير-ز9ي 3 года назад

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

    • @obivolgaz1661
      @obivolgaz1661 2 года назад

      Which backup ur asking pg_basebackup?

  • @MrBHASKARSOMASANI
    @MrBHASKARSOMASANI 3 года назад

    very helpfull

  • @eramkrish1
    @eramkrish1 3 года назад

    How to make db using existing oid folder?

  • @supriyakulkarni4610
    @supriyakulkarni4610 3 года назад

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

  • @tradernse7245
    @tradernse7245 3 года назад

    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 3 года назад

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

  • @portBerg
    @portBerg 3 года назад

    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.