Re: Fwd: [PERFORM] PG 9 adminstrations

I am trying to update / refresh one table (history) only from prod. database
to test environment database.
script as follows:

pg_dump -h host1 -U postgres -t history DB1 | psql -h host2 -U postgres -t
history DB2 > db.sql

but I am getting the following error

psql: FATAL: database "history" does not exist

Can you help please?

what would be the script if I want more than one table (3 tables to refresh)

Kind regards

On Fri, Sep 23, 2011 at 1:36 PM, Daniel Staal <DStaal(at)usa(dot)net> wrote:

> --As of September 23, 2011 1:17:37 PM +1200, Hany ABOU-GHOURY is alleged to
> have said:
>
> Please help with below issue I am new to postgresql
>>
>>
>> Many thanks for taking the time to read my email
>>
>
> --As for the rest, it is mine.
>
> I'm sure we'd be glad to help, but I think we're going to need you to start
> at the beginning. What's the problem you are having? What are you trying
> to do?
>
> You sent an output of an error, saying that it was a 'different error'.
> What did you try? What were you trying originally? This is a different
> group than you were sending to before, so we don't have the history.
>
> We'll help as soon as we can. But we have to know what the problem is. ;)
>
> Daniel T. Staal
>
> ------------------------------**------------------------------**---
> This email copyright the author. Unless otherwise noted, you
> are expressly allowed to retransmit, quote, or otherwise use
> the contents for non-commercial purposes. This copyright will
> expire 5 years after the author's death, or in 30 years,
> whichever is longer, unless such a period is in excess of
> local copyright law.
> ------------------------------**------------------------------**---
>