Thank you everybody for your help,
This problem has been resolved, in part to your insights.
All the best,
-JD
On Fri, Mar 1, 2013 at 4:31 AM, Albe Laurenz
<laurenz.albe@wien.gv.at> wrote:
JD Wong wrote:
>>> Hi Adrian, yes I completely copied the config-file and data directories
>>> over.
>> That's guaranteed to break everything badly.
> Even if I "read only style" copied the files? Do you mind elaborating on why this happens? ( or point
> me to relevant documentation )
The problem is that if you copy the files of a running database,
these files will change while they are being copied.
This can result in unusable contents.
Also, to function properly, the different files
in a PostgreSQL data directory must be consistent with each other.
If you copy one file after the other, files that are copied later
might belong to a different state of the database than earlier files.
You either have to shutdown the database before copying
(a filesystem level offline backup) or use some instantaneous
snapshotting technique that your file system might offer.
In the latter case PostgreSQL should perform crash recovery
and eventually reach a consistent state.
Yours,
Laurenz Albe