Migration dans la simplicité.

Après une mise à jour de mon système je me suis retrouvé avec un postgresql 9.5 flambant neuf (et vide) ! et une version 9.3 encore en place avec toutes mes bases dedans.

Mais moi je veux toutes mes bases dans la 9.5 et pas de 9.3.

Modification du Port à 5433 dans /etc/postgresql/9.3/main/postgresql.conf et 5432 dans /etc/postgresql/9.5/main/postgresql.conf

Un petit redémarrage en tant que root

root@vault:~# pg_ctlcluster 9.3 main restart
Redirecting restart request to systemctl
root@vault:~# pg_ctlcluster 9.5 main restart
Redirecting restart request to systemctl

Une copie simplissime en tant qu'utilisateur 'postgres' :

postgres@vault:~$ pg_dumpall -p 5433 | psql -d postgres -p 5432

Un peu de nettoyage

root@vault:~# pg_ctlcluster 9.3 main stop
Redirecting stop request to systemctl
root@vault:~# pg_dropcluster 9.3 main

Et voila toutes mes bases migrées...

J'adore PostgreSQL !

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

Change your Gogs admin password

I might have missed something, but I haven't found any simple way to change my admin password (with emailing not active) in gogs. It was quite easy to find the hash location, but as I didn't know how it was generated... Luckily I eventually found the parameters used, so here it is for you if you need them embedded in a script : var pbkdf2 = require('pbkdf2-sha256'); var key = 'YourChosenPasword'; var salt = 'AnyRandomValue'; var hash = pbkdf2(key, salt, 10000, 50); console.log(hash.toString('hex')); All I had to do was then to update the table user , setting passwd to the generated value (and updating salt with the value used in the script).
Lire la suite

What is the average salary for Perl programmers in 2020?

Original article published  my new blog   blog.assad.fr If I have no definitive answer on this, the  Business Insider  has some insights: HackerRank polled 116000 developers about their salaries and got interesting results: Perl is associated with an average global salary of $84,025.50 (54.2% higher than the global average salary) Scala is associated with an average global salary of $77,159.60 Go is associated with an average global salary of $72,691.30 Python is associated with an average global salary of $56,670.90 JavaScript is associated with an average global salary of $55,690 Without more information about the polled panel it's hard to state this results as “Truth” but they seems to confirm personal beliefs: The salary is more linked to the scarsity of resources than to the trendyness of the associated technology. Perl resources are less and less available. You know what ? It's good to be a Perl programmer :-)
Lire la suite

JavaScript for Perl lovers.

Article originally published on  Hello.js This time I feel really qualified to write this article because believe me, I love Perl ! I think in Perl, I dream in Perl, and I really appreciate the whole Perl community. I’ve been in love with this language for more than a decade but I decided that I needed a change. I’ve already said in a previous article why I chose to learn JavaScript this year (instead of getting involved in Perl 6 for example) but let me tell you why you might also enjoy learning JavaScript if you love Perl. Perl developers form a very unified community that all too often, resist outside influences, but learning a second language like JavaScript can really be a very enlightening experience. It’s expressive  JavaScript, like Perl, is an expressive language. You get your work done with just a few lines of code. When talking about programming languages, I really like the tent analogy: In a tent, you have functional things (tent fabrics) whose purpose is to provi
Lire la suite