In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter a problem. For example, a …
Read More »Faruk Erdem
Database-Based Memory Usage Rates in SQL Server
In some cases, we may need to determine the memory rates used by databases. Because some databases using extra memory may be degrading the performance …
Read More »How To Configure postgresql.conf Using pgtune
PostgreSQL is a database management system that is bare when it is first installed. Therefore, you should make some configurations according to your system resorce. To …
Read More »How To Grant Permission On Foreign Data Wrapper
We can read data from Oracle or MSSQL with the help of PostgreSQL Foreign Data Wrapper. Please read the following articles for installation and detailed …
Read More »How To Install Docker On Centos
Docker, which is becoming increasingly popular, is in the logic of virtualization. But unlike conventional known virtualization tools(Virtualbox, Vmvare ,kvm vb.. ), it does not …
Read More »How To List Availability Group Names, Database Names, IPs, Ports, DNS Names in SQL Server
If you are using SQL Server Availability Group and you have multiple availability groups and instances; if you want to list Availability Group Names, Database Names, …
Read More »What is dead.letter?
When you search for different files while working, you can see the file named dead.letter. Why does dead.letter occur? The cause of dead.letter is to …
Read More »How To Change TimeZone on PostgreSQL
If you notice that there is an error in the PostgreSQL time when you make time-dependent queries in PostgreSQL, you can change it by following …
Read More »How To Change TimeZone on Centos 7
If your Linux server does not match the local time, you may experience problems when making date-based configurations. You can make mistakes due to these …
Read More »How To Create NFS Share and Mount Shared Directory on a Client On Centos
NFS is the abbreviation of the Network File System. NFS is a useful technology for file sharing. It works as a server and client …
Read More »