| From: | Sven Willenberger <sven(at)dmv(dot)com> |
|---|---|
| To: | Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_restore |
| Date: | 2005-04-05 14:05:37 |
| Message-ID: | 1112709937.12338.23.camel@lanshark.dmv.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2005-04-05 at 12:10 +0530, Nageshwar Rao wrote:
> Hi,
>
> I took a dump using the following command
>
> Pg_dump -f bk.dmp
>
>
> When I tried to restore a table from the dump it just hangs there
>
> Pg_restore -f bk.dump -t table_name
>
>
> Also tried by giving username also
>
> Any light on this.
pg_restore [OPTION]... [FILE]
in this case don't use -f (as that represents "output" file name)
try pg_restore -d db_name -t table_name -U username bk.dmp
Sven
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Lang | 2005-04-05 14:28:10 | PL/PERL: raise notice, exception ? |
| Previous Message | Robert Treat | 2005-04-05 13:38:19 | Re: [Fwd: [webmaster] in Search of free hosting with |