agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Chris Hoover <revoohc@sermonaudio.com>
To: psql-admin@postgresql.org
Subject: pg_restore question
Date: Fri, 04 Feb 2005 16:20:28 -0500
Message-ID: <4203E71C.8060401@sermonaudio.com> (raw)

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

view thread (8+ messages)  latest in thread

Message-ID: <4203E71C.8060401@sermonaudio.com>
Permalink:  ../4203E71C.8060401@sermonaudio.com/
Also on:    postgresql.org/message-id/4203E71C.8060401@sermonaudio.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: revoohc@sermonaudio.com, psql-admin@postgresql.org
  Subject: Re: pg_restore question
  In-Reply-To: <4203E71C.8060401@sermonaudio.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox