I'm trying to verify that I am actually getting data in my
pg_dump from a PostgreSQL 9.3 server. I'm specifically running the following to get a dump of my Foreman database:
pg_dump -Fc foreman -U foreman -h foreman-db -p 5432 > foreman.sql
I am reading the dump using
pg_restore -l foreman.sql but when I search for known fqdns of hosts that should be in the
hosts table, I can not find them.
I'm no DBA, but it seems I'm doing something very wrong or I don't know how to search well enough yet to find data within pg_dump's.
Any assistance is much appreciated.