Part 10 - PostgreSQL : What is a Tablespace in PostgreSQL.

( 24*7) on Call Support for PostgreSQL/Open Source databases.
***********************************************************************************************
For Self Paced Learning: courses.emulti... ( Paid one-time subscription )
Online Training: [e-mail] or wa.me/message/...
***********************************************************************************************
PostgreSQL support starting from 100 USD/Hr ( 24*7)
WhatsApp contact: wa.me/message/...
Email: [e-mail]
***********************************************************************************************

[@proudindian3697]

Thank you very much..!! Very crisp and clear..!!

[@EMultiSkillsDatabaseServices]

Glad it was helpful!

[@obivolgaz1661]

Thank you so much sir . You explanation was awesome

[@EMultiSkillsDatabaseServices]

Thanks and welcome

[@ajeshpantula3169]

is an instance and the database are same , it could be better to understand if you could shown is the status before and after doing the below commands , actually i did not understood what it dose and why we did it .
pg_ctl -D initdb
pg_ctl -D data initdb
ls -IF data
pg_ctl -D data start

[@artiagrawal4483]

I have to create tablespace monitoring alarm(for ex. if it gets more than 96% , it will raise an alarm saying it has been near to full), so it would be ok If I take the path as /data/pg_tblspc ?

[@EMultiSkillsDatabaseServices]

Best way is to have fs level monitoring

[@yetendrashakya1269]

Have you created a tablespace on the network drive? If yes, please suggest to me how. Because I have created the tablespace but am not able to use the tablespace.
Error creating "Cannot create directory" while creating a new database in that tablespace.

[@EMultiSkillsDatabaseServices]

I am curious to know why network drive has been used ?
Are you trying on a personal system??
Can you try with local disk??

[@sebastianotrovato1800]

Troppo confusionario

[@EMultiSkillsDatabaseServices]

controllare dall'inizio che può aiutare