Re: Backup

From: Andy Hartman <hartman60home(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Backup
Date: 2024-10-16 22:59:32
Message-ID: CAEZv3cr3bgvmCWD_JEctbSDBHdBe6f-XmECSrEaC=n5zVLjv7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm on Ver16 and yes Our database has image in a bytea field.

Running on Win22 box...

On Wed, Oct 16, 2024 at 5:49 PM Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:

> On 2024-10-16 16:02:24 -0400, Ron Johnson wrote:
> > On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios <
> > a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
> > Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε:
> > On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman <
> hartman60home(at)gmail(dot)com>
> > wrote:
> [...]
> >
> > Step 1: redesign your DB to NOT use large objects. It's an old,
> slow
> > and unmaintained data type. The data type is what you should
> use.
> >
> > You mean bytea I guess. As a side note, (not a fan of LOs), I had the
> > impression that certain drivers such as the JDBC support streaming
> for LOs
> > but not for bytea? It's been a while I haven't hit the docs tho.
> >
> >
> > Our database is stuffed with images in bytea fields. The Java
> application uses
> > JDBC and handles them just fine.
>
> Images are usually small enough (a few MB) that they don't need to be
> streamed.
>
> I don't think bytea can be streamed in general. It's just like text, you
> write and read the whole thing at once.
>
> If you have data which is too large for that and want to store it in
> bytea fields, you'll probably have to chunk it yourself (which you
> probably have to anyway because for me "so large it has to be streamed"
> implies "at least possibly larger than 1 GB").
>
> hp
>
> --
> _ | Peter J. Holzer | Story must make more sense than reality.
> |_|_) | |
> | | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
> __/ | http://www.hjp.at/ | challenge!"
>

In response to

  • Re: Backup at 2024-10-16 21:48:47 from Peter J. Holzer

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2024-10-17 00:17:01 Re: Support for dates before 4713 BC
Previous Message Tom Lane 2024-10-16 22:03:15 Re: What are best practices wrt passwords?