pg_restore question

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: <psql-admin(at)postgresql(dot)org>
Subject: pg_restore question
Date: 2005-02-04 21:20:28
Message-ID: 4203E71C.8060401@sermonaudio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am having an issue with postgres 7.3.4 and pg_restore.

I have a pg_dump archive that I made with the following command:
pg_dump -p <port> -h <server> -Fc -Z9 -f db.dmp -v <db>

However, when I try to do a pg_restore for a specific table, it is not
restoring the permission to the table. Is there a way to have
pg_restore restore a specific table w/ the permissions?

Here was my restore command:
pg_restore -Fc -v -p <port> -h <server> -d <db> -t <table> db.dmp

Thanks for any help,

Chris

Browse pgsql-admin by date

  From Date Subject
Next Message Werner Bohl 2005-02-04 21:39:06 PG 8 Out of memory issuing queries
Previous Message Simon Riggs 2005-02-04 20:47:20 log_duration