From: | Hany ABOU-GHOURY <hghoury(at)gmail(dot)com> |
---|---|
To: | PGSQL-Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Fwd: [PERFORM] PG 9 adminstrations |
Date: | 2011-09-23 03:43:04 |
Message-ID: | CAEjHQv=eHGGi2M9ZyML3m0PJqAYX8bqyig9Tz-CLUHxkC2+gLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-performance |
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.
> ------------------------------**------------------------------**---
>
From | Date | Subject | |
---|---|---|---|
Next Message | Arvind Sharma | 2011-09-26 12:35:39 | Re: PG-9.0 - XML Data in a Column |
Previous Message | Daniel Staal | 2011-09-23 01:36:59 | Re: Fwd: [PERFORM] PG 9 adminstrations |
From | Date | Subject | |
---|---|---|---|
Next Message | M. D. | 2011-09-23 17:49:45 | slow query on tables with new columns added. |
Previous Message | Daniel Staal | 2011-09-23 01:36:59 | Re: Fwd: [PERFORM] PG 9 adminstrations |