Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Nathan Courtine

PASS SUMMIT 2017 – SQL Server Security

By | Database Administration & Monitoring | No Comments

Today is the first day of the PASS SUMMIT 2017 in Seattle (WA). The weather is cloudy and we have only 11°C… but where is the problem? Everything happens inside! (at the Convention Center). In this blog, I will make a summary of main attack vectors against MSSQL environments, based on Argenis FERANDEZ’s session called “Modern Security Attack Vectors Against SQL Server Environments”. METASPLOIT Metasploit is a penetration testing framework to exploit known security vulnerabilities….

 
Read More
Daniel Westermann

Are temporary tables auto vacuumed in PostgreSQL?

By | Database Administration & Monitoring | No Comments

While doing the EDB quiz at their booth last week at pgconfeu one of the questions was: Are temporary tables auto vacuumed? What do you think? My first thought was yes, but lets see. The first question we need to answer is: How can we check if a table (no matter if temporary or not for now) was auto vacuumed or not? PostgreSQL comes with many views that expose statistical information and one of those…

 
Read More
Daniel Westermann

2017.pgconf.eu, some impressions

By | Database Administration & Monitoring | No Comments

After we survived the EDB Postgres Rocks cafe on Tuesday, Wednesday was packed with interesting sessions. Especially listening to Robert Haas is always fun and interesting. Getting information directly from the people who work on the core code is one of the beauties of the PostgreSQL community. Several other core developers had sessions as well, and all of them were great. Thanks for all of that.  

 
Read More
Mouhamadou Diaw

StandbyFileManagement is set to MANUAL : Don’t panic

By | Database Administration & Monitoring | No Comments

As you may know the parameter STANDBY_FILE_MANAGEMENT enables or disables automatic standby file management. When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. It is generally recommended to set this parameter to AUTO, but it can happen that this parameter is set to MANUAL for x reasons. If this parameter is set to MANUAL, the replication will stop if we create…

 
Read More
Daniel Westermann

2017.pgconf.eu started, and look who is there …

By | Database Administration & Monitoring | No Comments

So, finally 2017.pgconf.eu started today and while checking the schedule I noticed something that I could not even imagine some years ago. There is a session from Microsoft: Latest update on Azure managed service for PostgreSQL. Personally I really like to see that Microsoft is more and more present at Open Source conferences and starts engaging in the community. But, of course this is not the only session that will be interesting. There is an…

 
Read More
Franck Pachot

VirtualBox 5.2 exports the VM to the Oracle Cloud

By | Database Administration & Monitoring | No Comments

The new release of Oracle VM VirtualBox (aka VirtualBox) is there with a new functionality to export a VM to the Oracle Cloud Compute (aka Oracle Cloud Infrastructure). That can be interesting to prepare a VM on my laptop and move it to the Cloud to get it accessible from everywhere. Here’s my first try. In my opinion, it’s idea but probably need further evolution.  

 
Read More
Mouhamadou Diaw

PostgreSQL Index Suggestion With Powa

By | Database Administration & Monitoring | No Comments

A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present article I am going to show how this powerful tool can help by suggesting indexes which can optimize our queries. I am using postgeSQL 9.6 [root@pgservertools extension]# yum install postgresql96-server.x86_64 [root@pgservertools extension]# yum install postgresql96-contrib.x86_64 And Then I initialize a cluster [root@pgservertools extension]# /usr/pgsql-9.6/bin/postgresql96-setup…

 
Read More
Eric Simbozel

SQL Server Management Studio 17.3 New Features

By | Database Administration & Monitoring | No Comments

Regularly, Microsoft SQL Server comes up with its new features, and in particular SSMS 2017 17.3 in this post, i present you a new feature : Import flat files Wizard How does it works : Open SSMS, and right click on a selected database Choose Import Flat File   Click Next   Tip the Path of your file to import and the new target table’s name this is a preview of the file content Click Next…

 
Read More
Daniel Westermann

Changing the LOCALE in CentOS/RedHat 7

By | Database Administration & Monitoring | No Comments

What I really don’t like is this: Someone wants me to work on a Linux system for whatever purpose and then I get messages like this: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permission non accordée or: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permiso denegado It is not that I don’t like French or Spanish but usually (well, not in that simple case) I am not able to translate that without the help from others. So…

 
Read More