![CHENNAKESHAVA RAMESH](/img/default-banner.jpg)
- 28
- 270 432
CHENNAKESHAVA RAMESH
India
Registrace 17. 01. 2018
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.
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.
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.
postgresql 10 installation using EDB software
zhlédnutí 1,9KPřed 5 lety
postgresql 10 installation using EDB software
Sir your explaination makae a confident in my learning Thank you...
wonderful
Very informative session. Can you please upload the latest version video's as well.
hi,please i have a problem alter my iods with upgrade sent me you email i check you
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?
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.
for cluster creation before we must install postgres in system?
how to create a hidden objects in postgresql , like oracle supports ?
Hi, Ramesh gaaru. can you please send me the exact config files for postgresql version 12 if you have.
New batch epudu start chestaru sir
thank you!
Where is the second server, how do we can say the given is single host cluster? or there is another video for basic installation
thanks!
By default it will create or we need create password file later installation
Thank you so much sir 😌
good video. thanks
This video is still helping people in 2020!!
0:45 - WAL stands for Write Ahead Logs.
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.
I want complete class of postgersql If there is offline class tell me addres sir ,contact number sir
Super and Excellent video. Easy to understand. Keep It UP. Thank you
Excellent session..
Can you share your email id I need help on db side
Really enjoyed this, thank you. Most clear explanation! Loved the example with the two users side by side!
Finally what I was looking for, thank you
You’re great.
Tq ramesh
Hi bro postgresql dba online batch unda bro
I didn’t understand shit
is the above slides avalible
Thank You !🙏
Thank you !! 🙏
Clear and crisp video. Thanks!!!
Hi anna plz give me your ph no . i learn postgressql. i want postgresql material anna. and full videos anna
Well Explained.
One of the most clear videos I've seen. Had to leave a comment. How did you create two users in the first place?
thank you so much sir
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?
Sir, would you be conducting any postgres training? Anything upcoming i would like to know
h ow can i do : pg_restore: [archiver] input file appears to be a text format dump. please use psql.
I really appreciate this video
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
Thank you for your nice demo... My question, how can we restore data after doing backup..?? 🌹🌹🌹🌹🌹
Which backup ur asking pg_basebackup?
very helpfull
How to make db using existing oid folder?
Very nice video. Looking forward to more videos from you.
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
Hi sir , Do you have the document for replication streaming setup ?
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.