Обсуждение: flashback concept in postgres

Hello,
          can any one tell me that, oracle flashback similar concept in postgresql? and same like  oracle SQL Loader in postgresql.



Regards,
karuna karpe.

On Fri, 2011-10-14 at 11:19 +0530, Karuna Karpe wrote:
>
>           can any one tell me that, oracle flashback similar concept
> in postgresql?

We don't have exactly the same, but we have PITR -- the result is the
same, but done in a different way. Search for Point In Time Recovery in
the documentation.

>  and same like  oracle SQL Loader in postgresql.

We have pgloader:

http://pgfoundry.org/projects/pgloader
http://pgloader.projects.postgresql.org/


Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

On Oct 14, 2011, at 12:17 PM, Devrim GÜNDÜZ wrote:

> On Fri, 2011-10-14 at 11:19 +0530, Karuna Karpe wrote:
>>
>>          can any one tell me that, oracle flashback similar concept
>> in postgresql?
>
> We don't have exactly the same, but we have PITR -- the result is the
> same, but done in a different way. Search for Point In Time Recovery in
> the documentation.
>
>> and same like  oracle SQL Loader in postgresql.
>
> We have pgloader:
>
> http://pgfoundry.org/projects/pgloader
> http://pgloader.projects.postgresql.org/
>


+1
pg_bulkload
http://pgbulkload.projects.postgresql.org/

>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com