Archive

Archive for the ‘BBDD’ Category

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

Enable Remote Access To MySQL Database

Categorías:BBDD, MySQL Etiquetas: , , ,

LOG pg_dump

pg_dump.exe -h my_host -p my_port -U my_user -w -Fc -b -v -f  C:\testbackup
postgres >>C:\testlog.txt 2>>C:\testlog.txt



https://www.postgresql.org/message-id/CALnrrJT3etU%3Dri%3D01fiLCr3Hn1Pix4Nzhan8-FPemhTo%3Db7oRw@mail.gmail.com

PostgreSQL Examples to Install, Create DB & Table, Insert & Select Records

MS Access Password Recovery

http://www.trisunsoft.com/access-password-recovery/

Cracks password for Microsoft Access MDB instantly

Categorías:BBDD Etiquetas: , ,

Mini Hack: Parallel Vacuuming in PostgreSQL

Categorías:BBDD, postgresql Etiquetas: ,