data duplication - Mailing list pgsql-general

From benjamin jacob
Subject data duplication
Date
Msg-id 20050211201650.83198.qmail@web53701.mail.yahoo.com
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Anton Berezin
Date:
Subject: Re: databases/p5-postgresql-plperl links to wrong libperl.so
Next
From: Palle Girgensohn
Date:
Subject: Re: databases/p5-postgresql-plperl links to wrong