Re: PG 9 adminstrations
| От | Hany ABOU-GHOURY |
|---|---|
| Тема | Re: PG 9 adminstrations |
| Дата | |
| Msg-id | CAEjHQvnosXN+RJ5567DynPk+y0-n5fOqcSv0GnjEcBBC=0w2mA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PG 9 adminstrations (Derrick Rice <derrick.rice@gmail.com>) |
| Ответы |
Re: PG 9 adminstrations
|
| Список | pgsql-performance |
Thanks but...did not work different error though
ERROR: relation "history" already exists
ERROR: relation "idx_history_pagegroupid" already exists
ERROR: constraint "cdocumentid" for relation "history" already exists
On Wed, Sep 21, 2011 at 4:16 PM, Derrick Rice <derrick.rice@gmail.com> wrote:
You don't need "-t history" on the psql part. It doesn't do what you think it does, and it's reading the next part ("history") as the database name.
try:
pg_dump -h <hostname1> -U postgres -t history DATABASENAME | psql -h hostname2 -U postgres DATABASENAME > db.sql
DerrickOn Tue, Sep 20, 2011 at 11:57 PM, Hany ABOU-GHOURY <hghoury@gmail.com> wrote:Hi all,I am trying to update / refresh one table (history) only from prod. database to my test environment databasemy query as follows:pg_dump -h <hostname1> -U postgres -t history DATABASENAME | psql -h hostname2 -U postgres -t history DATABASENAME > db.sqlbut I am getting the following errorpsql: FATAL: database "history" does not existCan you help please?what would be the script if I want more than one table (3 tables to refresh)Kind regards
В списке pgsql-performance по дате отправления: