pg_restore question - Mailing list pgsql-admin

From Chris Hoover
Subject pg_restore question
Date
Msg-id 4203E71C.8060401@sermonaudio.com
Whole thread Raw
List 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


pgsql-admin by date:

Previous
From: Michael Klatt
Date:
Subject: Re: Recovery using Online Backup+WAL and broken passwords
Next
From: "Andrei Bintintan"
Date:
Subject: Win32 Postgresql Command Line Password Specification