Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

2023-05-21 Thread Theodore M Rolle, Jr.
Yes, the SQLite thing. On Sun, May 21, 2023, 15:11 Marc Millas wrote: > ?? the sqlite thing ?? > > Marc MILLAS > Senior Architect > +33607850334 > www.mokadb.com > > > > On Sun, May 21, 2023 at 7:15 PM Theodore M Rolle, Jr. > wrote: > >> What about sq

Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?

2023-05-21 Thread Theodore M Rolle, Jr.
What about sqlcipher? On Sun, May 21, 2023, 07:16 Marc Millas wrote: > Oracle have One (1) DB per instance (in Oracle its not named a cluster > as...there is only one !). So ... > > Marc MILLAS > Senior Architect > +33607850334 > www.mokadb.com > > > > On Thu, May 18, 2023 at 9:30 PM Adrian

TF card for PGDATA

2022-10-08 Thread Theodore M Rolle, Jr.
What are the pros and cons of using a TF card to store data? It seems like a good idea, because there are no moving parts, but are there other points of failure that make this a bad idea?

Re: I slipped up so that no existing role allows connection. Is rescue possible?

2022-09-20 Thread Theodore M Rolle, Jr.
. . . And Tom’s English is excellent! On Tue, Sep 20, 2022, 18:29 Mladen Gogala wrote: > On 9/19/22 18:15, Tom Lane wrote: > > Bryn Llewellyn writes: > > Is rescue possible? Or must I simply remove my cluster and use "pg_ctl" to > create a new one within my existing PG 14.5 software env? > >

Re: Tab-completion error...?

2022-01-07 Thread Theodore M Rolle, Jr.
Fixed. Turned out to be LD_LIBRARY_PATH had a /USR/local/lib. Changed it to /usr/local/lib and everything's hunky-dory. On Tue, Jan 4, 2022 at 6:15 PM Tom Lane wrote: > "Theodore M Rolle, Jr." writes: > > ldd /usr/local/pgsql/bin/psql > > linux-vdso.so.1 (0xfff

Re: Tab-completion error...?

2022-01-04 Thread Theodore M Rolle, Jr.
fig.log (compile time) nor in the psql executable (run time). On Tue, Jan 4, 2022 at 1:32 PM Tom Lane wrote: > "Theodore M Rolle, Jr." writes: > > I don't use pacman for PostgreSQL. > > I compile from source. > > The point is that your from-source build of psql m

Re: Tab-completion error...?

2022-01-04 Thread Theodore M Rolle, Jr.
I don't use pacman for PostgreSQL. I compile from source. Seems as though this error shouldn't happen. On Wed, Dec 22, 2021 at 5:24 PM Adrian Klaver wrote: > On 12/22/21 2:14 PM, Theodore M Rolle, Jr. wrote: > Please reply to list also. > Ccing list. > > From below, what did p

Tab-completion error...?

2021-12-22 Thread Theodore M Rolle, Jr.
I'm having a problem with v14.1 on my Raspberry Pi 4[8Gb] After a clean download and compile, when using psql, using tab completion psql -U postgres postgres=# \i my_databases\tpsql: symbol lookup error: psql: undefined symbol: PQmblenBounded

Re: pgcrypto - real life examples to encrypt / decrypt

2021-08-06 Thread Theodore M Rolle, Jr.
How do those of us who compile PostgreSQL from source get libsodium into the mix? On Fri, Aug 6, 2021 at 2:27 PM Reid Thompson wrote: > someone mentioned an alternative earlier that they couldn't remember -- i > think it may have been pgsodium that they were thinking of >

Re: Slick way to update multiple tables.

2021-04-01 Thread Theodore M Rolle, Jr.
On Thu, Apr 1, 2021 at 12:43 PM Michael Lewis wrote: > You can have an updatable view. > *Show-stopper?* The defining query of the view must have exactly one entry in the FROM clause, which can be a table or another updatable view. Or multiple VIEWs? I've never done VIEWs... -- GnuPG/PGP

Slick way to update multiple tables.

2021-04-01 Thread Theodore M Rolle, Jr.
I SELECT items from three tables. It seems that the only way to put updated fields into their proper table is to query *each* field, then UPDATE *each* table. Am I missing something here? Is there a way to do this automatically? -- GnuPG/PGP key: 0xDD4276BA