Re: keeping images in a bytea field on AWS RDS

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: keeping images in a bytea field on AWS RDS
Date: 2020-03-31 20:52:18
Message-ID: 8dc1619c-b29e-17ae-7ae7-1dd3928c7bb6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/31/20 2:49 PM, Richard Bernstein wrote:
> I am using postgresql on RDS. I need to upload an image to the table. I
> understand that I need to set the PGDATA directory and place the image
> file in it, before setting the path in the bytea field. But how do I set
> PGDATA if I don't have the ability to set an environment variable, and
> don't have access to the following on an AWS controlled installation?
>
> $ initdb -D /usr/local/pgsql/data

> or
> pg_ctl -D /usr/local/pgsql/data initdb

initdb is definitely *not* what you want to do just to load an image into an
exiting database.

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-03-31 20:58:00 Re: keeping images in a bytea field on AWS RDS
Previous Message Alan Hodgson 2020-03-31 20:48:41 Re: keeping images in a bytea field on AWS RDS