2009/7/4 Scott Marlowe <scott.marl...@gmail.com>: > On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule<pavel.steh...@gmail.com> wrote: >> 2009/7/4 Roseller A. Romanos <don2_...@yahoo.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 > > * Note that in pgsql the first TWO numbers denote a major version, so > 8.1 and 8.2 are NOT the same major version. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
