How to backup a PostgreSQL database

In the following article you will find a few basic command for backups on PostgreSQL databases.

You can simply dump a database into a SQL file by using pg_dump

pg_dump db_name > /var/backups/db_name.sql

If you want to compress the output you can pipe the stream to gzip and the save it in a file:

pg_dump db_name | gzip > /var/backups/db_name.sql.gz

 

Weekly Bulletin 12

Hack 30xTUES hackathon

We were happy to join as a hosting partner at the most inspiring hackathon, organized by students.

Read more…

Debian 9.4 is now available for Cloud Servers

Debian 9.4 was publicly realeased. and a few days it was made available for Cloud Servers. The new version focuses primarily on security improvements and fixes.

Let’s Encrypt enables wildcard certificates

The free certificate authority Let’s Encrypt announced the long expected wildcard certificate support.

Hack30XTUES

We are proud to take part in one specifically awesome and inspiring event this week. Hack30xTUES is a school hackathon organized by the students from the Technological School Electronic Systems in Sofia, but this years fourth edition is even a bigger event. Sharing the year of the 30th anniversary of the school and promoting three equally interesting topics for the projects, Hack30XTUES is an extraordinary gathering of the best young IT talents.

Read More

Enable remote access to MySQL database

Sometimes you might need to remotely access a MySQL database. As a security measure, by default that is prohibitted, but on your own responsibility we’ll show you how you can make it work.

There are two changes you should make on a clean MySQL installation – first enable the MySQL server to listen on all networks and second to create an user allowed to connect from any client.

Read More

Hack 30xTUES – the best hackathon, organized by students – for students

This years fourth edition of HackTUES is just a few days away. The event gathers more than 200 students in four days of variety of technologies, awesome ideas, brilliant solutions and tons of fun. Hack 30xTUES will be open on March 15th and will immerse you in an astonishing fusion between the “Old school – New technologies” as the theme says. On Sunday, 45 teams of students from the Technological School Electronic systems in Sofia, will present their vision on the past, present and most of all the future of technologies.

CloudBalkan is proud to join again as hosting partner on the event, and this year will provide a few bits, byte or maybe terabytes of support for the teams.

Read More