Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id E9C1FB5DCEB
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 17 Oct 2011 07:54:24 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 39814-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 17 Oct 2011 10:54:18 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from mail-pz0-f44.google.com (mail-pz0-f44.google.com
	[209.85.210.44])
	by mail.postgresql.org (Postfix) with ESMTP id 6ACD5B5DC32
	for <pgsql-admin@postgresql.org>; Mon, 17 Oct 2011 07:54:13 -0300 (ADT)
Received: by pzk4 with SMTP id 4so16012338pzk.3
	for <pgsql-admin@postgresql.org>; Mon, 17 Oct 2011 03:54:13 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	bh=0p0lWWM+lDN+2VVatjGaog960je+/uHrasRnTHeUvgA=;
	b=RdfO1CAMD34WufP3+RU1aCjnky9ByaRX6UHGF1uOoQhpNJCuvMWAaGpgnlhKxX4Zwe
	2Fz5D5v1ImSUJj0qBZHVl1TxlztoJzFCOaufzLvDHwFGdgbg83souA5/qlospNIp+Jiy
	GlOWZW7IouwtO2pgN9x/dGfDHKdGcACNaIn00=
Received: by 10.68.36.6 with SMTP id m6mr37421372pbj.111.1318848852851;
	Mon, 17 Oct 2011 03:54:12 -0700 (PDT)
Received: from [192.168.1.2] ([122.170.17.103])
	by mx.google.com with ESMTPS id v8sm57621401pbf.8.2011.10.17.03.54.07
	(version=TLSv1/SSLv3 cipher=OTHER);
	Mon, 17 Oct 2011 03:54:09 -0700 (PDT)
Subject: Re: flashback concept in postgres
Mime-Version: 1.0 (Apple Message framework v1244.3)
Content-Type: text/plain; charset=utf-8
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <1318574865.2086.1.camel@lenovo01-laptop03.gunduz.org>
Date: Mon, 17 Oct 2011 16:24:02 +0530
Cc: Karuna Karpe <karuna.karpe@os3infotech.com>,
 pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <3D76D0A1-F69E-48EE-B7BE-B097FBF39200@gmail.com>
References: 
 <CAC-LqbpWVs=ztDjdCasyOcJgaNv9cBGL98zLmUr6Nc9ypTue5Q@mail.gmail.com>
	<1318574865.2086.1.camel@lenovo01-laptop03.gunduz.org>
To: =?iso-8859-1?Q?Devrim_G=DCND=DCZ?= <devrim@gunduz.org>
X-Mailer: Apple Mail (2.1244.3)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001
X-Spam-Level: 
X-Archive-Number: 201110/83
X-Sequence-Number: 38535


On Oct 14, 2011, at 12:17 PM, Devrim G=C3=9CND=C3=9CZ wrote:

> On Fri, 2011-10-14 at 11:19 +0530, Karuna Karpe wrote:
>>=20
>>          can any one tell me that, oracle flashback similar concept
>> in postgresql?
>=20
> 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.
>=20
>> and same like  oracle SQL Loader in postgresql.
>=20
> We have pgloader:
>=20
> http://pgfoundry.org/projects/pgloader
> http://pgloader.projects.postgresql.org/
>=20


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

>=20
> Regards,
> --=20
> Devrim G=C3=9CND=C3=9CZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/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