pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPlease guide me.
5+ messages / 5 participants
[nested] [flat]
* Please guide me.
@ 2005-12-14 09:23 Praveen Kumar (TUV) <praveen.k@renaissance-it.com>
0 siblings, 1 reply; 5+ messages in thread
From: Praveen Kumar (TUV) @ 2005-12-14 09:23 UTC (permalink / raw)
To: sandhyar@amiindia.co.in; devrim@commandprompt.com; +Cc: pgsql-admin
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<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Fw: Please guide me.
@ 2005-12-15 09:54 sandhya <sandhyar@amiindia.co.in>
0 siblings, 1 reply; 5+ messages in thread
From: sandhya @ 2005-12-15 09:54 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Fw: Please guide me.
@ 2005-12-15 10:32 Peter Eisentraut <peter_e@gmx.net>
parent: sandhya <sandhyar@amiindia.co.in>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2005-12-15 10:32 UTC (permalink / raw)
To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin
Am Donnerstag, 15. Dezember 2005 10:54 schrieb sandhya:
> 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.
http://www.postgresql.org/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Fw: Please guide me.
@ 2005-12-15 21:57 Jim C. Nasby <jnasby@pervasive.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 5+ messages in thread
From: Jim C. Nasby @ 2005-12-15 21:57 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: sandhya <sandhyar@amiindia.co.in>; pgsql-admin
On Thu, Dec 15, 2005 at 11:32:45AM +0100, Peter Eisentraut wrote:
> Am Donnerstag, 15. Dezember 2005 10:54 schrieb sandhya:
> > 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.
>
> http://www.postgresql.org/
In other words, if you're going to use a free database plan on either
doing some research on things yourself (such as reading the
documentation), or hire a commercial company to do the work for you.
Most of what you asked about is in the docs already.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Please guide me.
@ 2005-12-17 21:16 Chris Browne <cbbrowne@acm.org>
parent: Praveen Kumar (TUV) <praveen.k@renaissance-it.com>
0 siblings, 0 replies; 5+ messages in thread
From: Chris Browne @ 2005-12-17 21:16 UTC (permalink / raw)
To: pgsql-admin
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!"
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-12-17 21:16 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-14 09:23 Please guide me. Praveen Kumar (TUV) <praveen.k@renaissance-it.com>
2005-12-17 21:16 ` Chris Browne <cbbrowne@acm.org>
2005-12-15 09:54 Fw: Please guide me. sandhya <sandhyar@amiindia.co.in>
2005-12-15 10:32 ` Peter Eisentraut <peter_e@gmx.net>
2005-12-15 21:57 ` Jim C. Nasby <jnasby@pervasive.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox