Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1599C6339EB for ; Fri, 9 Apr 2010 17:47:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 76335-03 for ; Fri, 9 Apr 2010 20:47:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gunduz.org (ns1.gunduz.org [77.79.103.58]) by mail.postgresql.org (Postfix) with ESMTP id 4EC656324A1 for ; Fri, 9 Apr 2010 17:47:23 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.gunduz.org (Postfix) with ESMTP id 92FD7400049; Fri, 9 Apr 2010 23:48:37 +0300 (EEST) X-Virus-Scanned: amavisd-new at mail.gunduz.org Received: from mail.gunduz.org ([127.0.0.1]) by localhost (mail.gunduz.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Qoon0hPRxkXO; Fri, 9 Apr 2010 23:48:02 +0300 (EEST) Received: from [188.58.140.242] (unknown [188.58.140.242]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gunduz.org (Postfix) with ESMTPSA id 56F68400046; Fri, 9 Apr 2010 23:48:02 +0300 (EEST) Subject: Re: Handling of images via Postgressql From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: robert@blogg.se Cc: s.borse@direction.biz, pgsql-admin@postgresql.org In-Reply-To: <4BBC9020.8090209@blogg.se> References: <1270644614.2390.44.camel@dss-052.dsslp.com> <4BBC9020.8090209@blogg.se> Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-sVue1Csr9pUe5P5SOU3a" Date: Fri, 09 Apr 2010 23:46:27 +0300 Message-ID: <1270845987.9084.45.camel@hp-laptop2.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 (2.28.3-1.fc12) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.01 tagged_above=-10 required=5 tests=T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/121 X-Sequence-Number: 34215 --=-sVue1Csr9pUe5P5SOU3a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, 2010-04-07 at 16:01 +0200, Robert Gravsj=C3=B6 wrote: > > Do you suggest having the images in a different database by itself? >=20 > I'd suggest storing meta information in PostgreSQL and the images in > the filesystem.=20 Is this transaction safe? --=20 Devrim G=C3=9CND=C3=9CZ PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz --=-sVue1Csr9pUe5P5SOU3a Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEABECAAYFAku/kiIACgkQtl86P3SPfQ5ObwCggu7LtdrghLjeHAp65Z4o93uM mS8AoOr4eaiTB7KWOrM97TqbSr0UxC78 =oL07 -----END PGP SIGNATURE----- --=-sVue1Csr9pUe5P5SOU3a--