E-MultiSkills Database services
E-MultiSkills Database services
( 24*7) on Call Support for PostgreSQL/Open Source databases.
***********************************************************************************************
For Self Paced Learning: courses.emultiskills.com/courses/postgresql-database-administration ( Paid one-time subscription )
Online Training: [email protected] or wa.me/message/VUBG74XTU3DSM1
***********************************************************************************************
PostgreSQL support ( 24*7)
WhatsApp contact: wa.me/message/VUBG74XTU3DSM1
Email: [email protected]
***********************************************************************************************
Пікірлер
forgot password scram-sha-256 what will i do
but why am i not able to copy that data from the original directory
Is there any error?
@@EMultiSkillsDatabaseServices no actually it's solved. Although thanks for replying.
thanks I can fix it
which tool we can use to compare data after migration from Oracle to Postgres
please admin also make these videos in hindi urdu
Do you have the notepad notes for each of the videos you've posted?
Not for KZread
You have made great videos for postgresql database learning. I have learned many concepts. Kindly post more videos. Thank you.
Not everything is posted here . Just 5% only here . Remaining it's on paid subscription of courses.emultiskills.com
thank you
thank you
thank you sir
@e-multiskills Sir do you have any course for complete Oracle to Postgres migration for large and small databases? Please help me in learning the same in detail. your help will be quite helpful for me.
Yes , check the portal, it's available
@@EMultiSkillsDatabaseServices could you please share the link for oracle to postgres migration? I checked the channel, but couldn't find the same..
It's a paid course available on courses.emultiskills.com
@@EMultiSkillsDatabaseServices is it 600 dollars ?
No audio sirji
thankyou
Nice
Is it possible to like mount the data directory to a sever shared drive ?
what's the idea behind that ?
great
Promo_SM 👍
Its excellent explanation to set dr drill & read replica in cloud sql Postgres
best
14:28 show options for pgBadger.
Deus abençoe os indianos ❤
What to do if the IP address are different. I mean if they are in different network.
Use cidr in hba
thanku mate
thank you so much bro
when query lock, should add a where condition to avoid system tables: where relname not like 'pg_%';
should add "state = 'active'" in where, when query slow sql.
What if the source database is Oracle and Target is Postgesql. Can we create DB link b/w them ?
There are workaround for that.
It works. Thanks a lot!
Hi, I want to create backup from PostgreSQL 6.1 and want to restore on 7.8.Can you please let me know that is there any easy way to do so? I am struggling a lot for this.
If possible can we please get time stamp of the course, I mean at what time which topic is being covered.. It will be a great help.
very clear video thanks for clearance
thanks sir for clear tutorials with exact commands
Thanks for the video @EMultiSkill, its helpful.
Not much informational. This will be good if it will be some real time examples.
which tool you are using for migration and uploading
Thank you very much :)
on the slave status, i'm getting Last_IO_error : "The slave IO thread stops because master and slave have equal mysql server ids", However i've used different server ids in both the my.cnf files. Can you please help
Where are 2 hosts ? Cloud? Local?
@@EMultiSkillsDatabaseServices i'm performing this on cloud
you explained well. thank you so much
Good afternoon! I still have an error saying that "psql: error: connection to server at "localhost" (::1), port 5432 failed: server does not support SSL, but SSL was required", however did everythin step by step as you suggested
Solved. I need to uncomment in postgres.conf (excatly these line 5:34)
Well I am not able to get the same as your result against the system ctl status , as my PID dont show postmaster it shows as : Main PID: 11821 (code=exited, status=0/SUCCESS) Also the Cgroups are not visisble, that may be because i am using WSL
Thank you for putting this together. Now in 2024 and your video is still helpful at ver 16. Cheers from Australia - Dave
thanks for the video. is using md5 secure these days?
No, sha256 must be used in prod
thanks for ur fast reply, u mean scram-sha-256? @@EMultiSkillsDatabaseServices
connection timeout is coming. unable to connect
Check the firewall settings
DO PEOPLE THINK THEY SOUND INTELLIGENT BY SAYING "MY-SEQUEL" INSTEAD OF MY-S-Q-L???????????? DIFFERENT ISN'T ALWAYS BETTER, IF WE COULD GET MORE IDIOTS TO UNDERSTAND THIS, WE WOULD BE IN A MUCH BETTER PLACE!!!!!!!!!
Hi, first of all thanks for the videos you provide for SQL, those are really helpful. I've a query, actually while changing password for sql server, in program data it is showing "my" instead of "my.ini" file. Also, in services it is showing "MySQL" instead of "MySQL80". Could you please guide what's incorrect here?
Will there will be a demo in future ?
Not sure, hopefully I may not get time for the next several months due to writing other courses. So take it as No until Aug 2024
Thank you sir for this session. I have one question that is "what if my primary server went down ? So after coming up do we need to rebuild the replication?
No
User name is wrong
Which user
Appreciate this man
i dnt see c grops in my ubuntu machine, where its says only CPU 2ms and it end after MAIN PID