[ADMIN] Some Postgresql Concepts

[Karuna Karpe]

Hello,

Can any one please tell me the following postgresql concepts?

1. Flashback fundamental
2. Compression, encryption and decryption
3. DB Link and Heterogeneous Concept
4. Storage Management

Regards,
karuna karpe.

[Craig Ringer]

Post by Karuna Karpe
1. Flashback fundamental

Flashback? I think you might be confusing this:

http://oracle.com/

with this:

http://postgresql.org/

Post by Karuna Karpe
2. Compression, encryption and decryption

Check out TOAST and pgcrypto in the *MANUAL*.

http://lmgtfy.com/?q=postgresql+manual

(The above too grumpy? Google is a key skill as a DBA, and asking people
to do your basic research for you for free and hand the answers to you
on a platter is a bit much.)

Post by Karuna Karpe
3. DB Link and Heterogeneous Concept

"Hetrogenous Concept"?

dblink is, again, something best learned about using the documentation
and Google.

Post by Karuna Karpe
4. Storage Management

Details?

What do you want to know? "Storage management" is kind of a broad
category. You probably want to read the manual first, then look into
things like tablespaces, TOAST, vacuum and autovacuum, etc.

--
Craig Ringer