data duplication

From: benjamin jacob <bensdenn(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: data duplication
Date: 2005-02-11 20:16:50
Message-ID: 20050211201650.83198.qmail@web53701.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello there,
Currently, we r using, Postgresql v 7.3, on RedHat 9
machines.

We provide a hot standby at all times for the Primary
server.

So, we have to maintain a duplicate of the entire
database.
The problem arises, when the standby boots.

I wanted to know, whenever the standby boots up, what
all files shud it copy frm the Primary.
All files, under the data directory??
Viz., global, base, clog and xlog?

What are those pg_internal.init, pgstat.stat files?
What's the difference between global and base
directories?
If the async feature is used on the primary, shud we
copy on the xlog and clog files onto the backup as
well?

As of now, we shut down postmaster, on the Primary
whenever the standby boots up.
Duz this ensure, all data is written onto the disk b4
postmaster shut downs?

Also, any links for me to find more abt these files
used in pgsql?

These and more...

Regards

- Benjamin Jacob.


__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-02-11 20:27:38 Re: test datatype for ANY
Previous Message Ignacio Colmenero 2005-02-11 19:49:13 Re: ERROR: control reached end of function without RETURN