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: | Raw Message | Whole Thread | 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 |