| From: | Hany ABOU-GHOURY <hghoury(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | PG 9 adminstrations |
| Date: | 2011-09-21 03:57:44 |
| Message-ID: | CAEjHQvk31VQWAONdd_CT80ode4pr+0UvOUy9rqeWuxtX=Dh+Nw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
Hi all,
I am trying to update / refresh one table (history) only from prod. database
to my test environment database
my query as follows:
pg_dump -h <hostname1> -U postgres -t history DATABASENAME | psql -h
hostname2 -U postgres -t history DATABASENAME > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Derrick Rice | 2011-09-21 04:16:36 | Re: PG 9 adminstrations |
| Previous Message | pg noob | 2011-09-16 13:30:40 | query question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Derrick Rice | 2011-09-21 04:16:36 | Re: PG 9 adminstrations |
| Previous Message | Tom Lane | 2011-09-21 03:43:38 | Re: Prepared statements and suboptimal plans |