> hostname2 -U postgres DATABASENAME > db.sql
>
> Derrick
>
>
> On Tue, Sep 20, 2011 at 11:57 PM, Hany ABOU-GHOURY wrote:
>
>> Hi all,
>>
>> I am trying to update / refresh one table (history) only from prod.
>> database to my test environment data
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 -U postgres -t history DATABASENAME | psql -h
hostname2 -U postgres -t history DATABASENAME > db.sql
but I am getting the following error
psql: F
le to be loaded from a pgfouine formatted log file, or
> from another db ... but that's OK.
>
>
> --
> Anthony Presley
>
>
> On Mon, Sep 12, 2011 at 6:28 PM, Hany ABOU-GHOURY wrote:
>
>>
>> I have a production PostGres v8.2 database on luinx and a test Po
I have a production PostGres v8.2 database on luinx and a test PostGres V9.0
database on a test linux server
I am going to do migration but do not want to do that before making sure the
performance of the new test Postgres 9.0 database performance is as good as
the current production Postgres 8.2
Thanks Maciek.
I really do not know where to start or how to explain my question
I am newbie to Postgres. I will try to get more information from the
development team and SA's
Cheers
Hany
On Mon, Sep 12, 2011 at 10:22 AM, Maciek Sakrejda wrote:
> I doubt you'll get much useful feedback because
Hi,
I have a database cluster running PostgreSQL 8.2
and I have **new Linux virtualized database environment running PostgreSQL
9.0
My question is how to ensure that database schemas are always performing and
scalable and databases optimized and entirely migrated
Thanks in advance!
Hany
Hi all,
I am working on project to migrate PostgreSQL from V8.2 to 9.0 and optimise
the new DB
has any one done some thing like that before ?
my main Task is the Optimisation part so please share some thoughts
Regards
Hany
On Wed, Sep 7, 2011 at 1:03 PM, Craig Ringer wrote:
> On 7/09/2011 2:31
