Обсуждение: Fwd: [PERFORM] PG 9 adminstrations
Please help with below issue I am new to postgresql
Many thanks for taking the time to read my email
Cheers
Hany
---------- Forwarded message ----------
From: Shaun Thomas <sthomas@peak6.com>
Date: Thu, Sep 22, 2011 at 12:48 AM
Subject: Re: [PERFORM] PG 9 adminstrations
To: Hany ABOU-GHOURY <hghoury@gmail.com>
Cc: Derrick Rice <derrick.rice@gmail.com>, pgsql-performance@postgresql.org
Also, might I suggest using the pgsql-novice list? They're more likely to help with general issues like this.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@peak6.com
______________________________________________
See http://www.peak6.com/email-disclaimer/ for terms and conditions related to this email
From: Shaun Thomas <sthomas@peak6.com>
Date: Thu, Sep 22, 2011 at 12:48 AM
Subject: Re: [PERFORM] PG 9 adminstrations
To: Hany ABOU-GHOURY <hghoury@gmail.com>
Cc: Derrick Rice <derrick.rice@gmail.com>, pgsql-performance@postgresql.org
On 09/20/2011 11:29 PM, Hany ABOU-GHOURY wrote:
Clearly the history table already exists on your second host. This may or may not matter, if the table definitions are the same. If the table on host2 was empty, it'll be filled with the data from host1. If not, you'll need to truncate the table on host2 first. If you don't want the complaints about tables or indexes or constraints that already exist, use the -a option for data-only dumps.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
Also, might I suggest using the pgsql-novice list? They're more likely to help with general issues like this.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@peak6.com
______________________________________________
See http://www.peak6.com/email-disclaimer/ for terms and conditions related to this email
--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. ---------------------------------------------------------------
I am trying to update / refresh one table (history) only from prod. database to test environment database.
script as follows:
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@usa.net> wrote:
--As of September 23, 2011 1:17:37 PM +1200, Hany ABOU-GHOURY is alleged to have said:--As for the rest, it is mine.Please help with below issue I am new to postgresql
Many thanks for taking the time to read my email
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.
---------------------------------------------------------------