Archivo

Archive for the ‘Uncategorized’ Category

Remove all packages marked as rc by dpkg

https://linuxprograms.wordpress.com/2010/05/12/remove-packages-marked-rc/

 

dpkg –list |grep “^rc”

dpkg –list |grep “^rc” | cut -d ” ” -f 3

dpkg –list |grep “^rc” | cut -d ” ” -f 3 | xargs sudo dpkg –purge

Anuncios
Categorías:Comandos, Linux, Uncategorized Etiquetas: , , ,

Conocer la version de Debian instalada

cat /etc/*-release

cat /proc/version

lsb_release -a

Categorías:Comandos, Linux, Uncategorized Etiquetas: , ,

Biblioteca de Iconos

Categorías:Uncategorized Etiquetas: , , , , , ,

parallel pg_dump pg_restore JOBS

26 septiembre, 2017 Deja un comentario

Chequeo Mail Server

A BETTER BACKUP WITH POSTGRESQL USING PG_DUMP

Easy way to view postgresql dump files

If the dump is not plain text – try using pg_restore -l your_db_dump.file command. It will list all objects in the database dump (like tables, indexes …).

Another possible way (may not work, haven’t tried it) is to grep through the output of pg_restore your_db_dump.file command. If I understood correctly the manual – the output of pg_restore is just a sequence of SQL queries, that will rebuild the db.

Categorías:BBDD, postgresql, Uncategorized