Home > mailing lists

PG 9 adminstrations - Mailing list pgsql-performance

From	Hany ABOU-GHOURY
Subject	PG 9 adminstrations
Date	September 21, 2011 03:57:52
Msg-id	CAEjHQvk31VQWAONdd_CT80ode4pr+0UvOUy9rqeWuxtX=Dh+Nw@mail.gmail.com Whole thread Raw
Responses	Re: PG 9 adminstrations
List	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: Tom Lane
Date: 21 September 2011, 03:43:51
Subject: Re: Prepared statements and suboptimal plans

From: Derrick Rice
Date: 21 September 2011, 04:16:45
Subject: Re: PG 9 adminstrations