Power Architect
In my search for a data modeling tool that is similar to MySQL Workbench, but works for PostgreSQL databases, I found out about Power Architect. What is Power Architect? Power Architect is a cross-platform, open-source visual data modeling and profiling tool with a GUI and an embeddable API designed for data architects, DBAs, analysts, and [...]
pg_restore: [tar archiver] could not find header for file in tar archive
From my old notes, I posted the way I create PostgreSQL dumps. It turns out that when you’re trying to dump a huge database (20+GB), the dump would continue and finish, but pg_restore-ing it will not work flawlessly as expected and might show an error message like this one: pg_restore: [tar archiver] could not find [...]
PostgreSQL notes
This is just another one of my notes. I often encounter these errors after a fresh install of Fedora. After executing psql -U postgres and getting this message: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket “/tmp/.s.PGSQL.5432″?
PostgreSQL restore and dump
This is just a note to myself. This is how I create backup and restore backup of postgresql databases right now: pg_dump -U postgres -F t -b -v -f ".backup" "" -F : –format=format Selects the format of the output. t : Output a tar archive suitable for input into pg_restore. Using this archive format [...]
