Greg Williamson writes:
> What I am I missing ? Or is pg_restore just not capable of restoring the full
> definition of a table ?
There isn't any provision for doing that automatically; it would be a
bit tough to determine exactly what the "full definition" consists of
in a way that makes everyb
Raghu Ram wrote:
>
>Try with below work-around to restore only hosts table from compressed dump
>file:
>
>
>"pg_restore
>-t hosts -Fc /var/data/pgsql/backups/prodDB/20111017_puppet.pgdump >
>hosts_plaindump" [ i.e you'll get a human-readable dump ]
>
Did you actually try this ?
This does n
On Tue, Oct 25, 2011 at 3:26 AM, Greg Williamson wrote:
> I am trying to document how to recover a table that has been dropped by
> using pg_restore.
>
> This is the table as it was originally:
> puppet=# \d hosts
> Table "public.hosts"
> Column |
