Re: Pls help

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Roseller A(dot) Romanos" <don2_907(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pls help
Date: 2009-07-04 06:22:49
Message-ID: 162867790907032322v371c8a30q916b0ae6242a200a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/7/4 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
> On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehule<pavel(dot)stehule(at)gmail(dot)com> wrote:
>> 2009/7/4 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
>>> On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule<pavel(dot)stehule(at)gmail(dot)com> wrote:
>>>> 2009/7/4 Roseller A. Romanos <don2_907(at)yahoo(dot)com>:
>>>>>  Hi,
>>>>>
>>>>> I really have a serious problem with this.  I hope you could give me some
>>>>> insights on how to possibly solve this problem. I have installed a new copy
>>>>> of postgres in my PC using Windows XP OS and I have copy the data folder in
>>>>> my previous installation from the other PC, my problem is that I cannot
>>>>> access the records that I have copied from the other PC.
>>>>
>>>> you cannot copy postgres data files from one computer to second.
>>>> PostgreSQL is not MySQL. Use pg_dump instead or copy statement.
>>>
>>> Well, strictly speaking, if they're from the same architecture, with
>>> the same compile time options and the same major version of pgsql*
>>> then you can.  But you need to shut down the source and destination
>>> servers while doing it.
>>
>> and all your DDL operation are same and executed in same order too
>
> I'm not sure what you mean.  If you shut down both db instances, and
> copy the files over, there's no DDL involved really.
>

When you copy all files, then ok. But when you copy only one data
file, then you have a problem.

Problem should be different oid of pg_class table

Pavel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-07-04 06:27:04 Re: Pls help
Previous Message Scott Marlowe 2009-07-04 06:13:47 Re: Pls help