agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Eugene Yin <eugeneymail@ymail.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: BLOBs
Date: Sun, 10 Jan 2016 06:20:02 +0000 (UTC)
Message-ID: <21791464.2842310.1452406802668.JavaMail.yahoo@mail.yahoo.com> (raw)
References: <21791464.2842310.1452406802668.JavaMail.yahoo.ref@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
The following statement is excerpted from the
"Oracle to Postgres Conversion"
https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion#Grammar_Differences
on Postgres 8.4.
BLOBs
Binary large object support in Postgres is very poor and unsuitable for use in a 24/7 environment, because you can't dump them with pg_dump. Backing up a database that makes use of Postgres large objects requires one to knock down the RDBMS and dump the files in the database directory.Don Baccus put together a hack that extends AOLserver's postgres driver with BLOB-like support, by uuencoding/decoding binary files before stuffing them into or extracting them from the database. The resulting objects can be consistently dumped by "pg_dump" while the RDBMS is up and running. There is no need to interrupt service while making your backup.To get around the one-block limit on the size of a tuple imposed by Postgres, the driver segments the encoded data into 8K chunks.Postgres large objects are scheduled for a major overhaul in summer 2000. Because of this, only the BLOB functionality used by the ACS was implemented.
Now for Postgres 9.4.5, is backup of the BLOB still an issue as described above, OR, it now works equivalent to that of Oracle?
Thanks
Eugene
view thread (20+ messages) latest in thread
Message-ID: <21791464.2842310.1452406802668.JavaMail.yahoo@mail.yahoo.com>
Permalink: ../21791464.2842310.1452406802668.JavaMail.yahoo@mail.yahoo.com/
Also on: postgresql.org/message-id/21791464.2842310.1452406802668.JavaMail.yahoo@mail.yahoo.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: eugeneymail@ymail.com
Subject: Re: BLOBs
In-Reply-To: <21791464.2842310.1452406802668.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox