Обсуждение: Please guide me.

Поиск
Список
Период
Сортировка

Please guide me.

От
"Praveen Kumar (TUV)"
Дата:
Hello,
I have install postgresql on Redhat AS 4.Now we want to migrate data from oracle 8i to postgresql 8.1 and  want to create snapshots , materialized view,dblink,taking online backup,logical backup and establish replication  between three production server.Plz tell me which documents,links and books I should follow for getting knowledge
about above mentioned activites.
rgds
 
 

Praveen Malik
Software Engineer

Extn:1607
===========================================================================
Sobha Renaissance Information Technology Private Limited
An SEI-CMM & P-CMM Level 5 Company

World's 1st SSE-CMM Level 5 Company

BS 7799 certified by British Standards Institute

ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg

A Six Sigma Practice Company

Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80 51252222
Email : praveen.k
@renaissance-it.com; Web: www.renaissance-it.com
===========================================================================
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies from any computer.

 

 

 

 

Re: Please guide me.

От
Chris Browne
Дата:
praveen.k@renaissance-it.com ("Praveen Kumar (TUV)") writes:
> I have install postgresql on Redhat AS 4.Now we want to migrate data
> from oracle 8i to postgresql 8.1 and  want to create snapshots ,
> materialized view,dblink,taking online backup,logical backup and
> establish replication  between three production server.Plz tell me
> which documents,links and books I should follow for getting
> knowledge

For many of these things, you are using what appears to be terminology
*very* specific to Oracle.  PostgreSQL isn't Oracle, so things are not
implemented the same, and certainly don't follow Oracle's use of
terminology.

For instance, I can think of several possible meanings for
"snapshots."  And it seems obvious that no one would be such an idiot
as to ask for an "illogical backup."

There is a section in the documentation on backups; you should avail
yourself of that, immediately, as it explains various sorts of backup
"machinery" that is available.

As for replication, if you need single master to multiple slave
asynchronous replication, see <http://slony.info/>.  The 1.1.5 release
of Slony-I, which supports PostgreSQL 8.1, should be available in the
coming week.

You will find it more useful to describe what you *want*.
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/slony.html
Signs of a Klingon Programmer - 3. "This  machine is GAGH! I need dual
Pentium processors if I am to do battle with this code!"