Re: I slipped up so that no existing role allows connection. Is rescue possible?
.
.
.
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?
>
>
> Stop the cluster, start a single-user session ("postgres --single"),
> re-grant superuser to the postgres user and/or whatever else you
> wish you could take back, end that session, restart the cluster.
>
> (You're not the first to mess up like this.)
>
> regards, tom lane
>
>
>
> Tom, your knowledge is vast and your advice is extremely useful. Have you
> ever considered creating a dedicated page for beginners? Something like
> AskTom.postgresql.org would probably be appropriate.
>
> Regards
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>
TF card for PGDATA
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: Would PostgreSQL 16 native transparent data encryption support database level encryption?
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 Klaver > wrote: > >> On 5/18/23 11:56, Ron wrote: >> > On 5/18/23 12:54, Rob Sargent wrote: >> >> On 5/18/23 11:49, Ron wrote: >> >> > We need to keep costs down, too. >> > >> > Oracle (I think) does it at the DB level, and so does SQL Server. Upper >> > Management hears us say "sorry, no can do" and wonders what bunch of >> > amateurs are developing PostgreSQL. >> >> Looks like you will be migrating to Oracle or SQL Server. >> >> Good luck on keeping costs down. >> >> > >> > -- >> > Born in Arizona, moved to Babylonia. >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >> >> >>
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?
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 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 Klaver >>> wrote: >>> >>>> On 5/18/23 11:56, Ron wrote: >>>> > On 5/18/23 12:54, Rob Sargent wrote: >>>> >> On 5/18/23 11:49, Ron wrote: >>>> >>>> > We need to keep costs down, too. >>>> > >>>> > Oracle (I think) does it at the DB level, and so does SQL Server. >>>> Upper >>>> > Management hears us say "sorry, no can do" and wonders what bunch of >>>> > amateurs are developing PostgreSQL. >>>> >>>> Looks like you will be migrating to Oracle or SQL Server. >>>> >>>> Good luck on keeping costs down. >>>> >>>> > >>>> > -- >>>> > Born in Arizona, moved to Babylonia. >>>> >>>> -- >>>> Adrian Klaver >>>> adrian.kla...@aklaver.com >>>> >>>> >>>> >>>>
Slick way to update multiple tables.
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 +-+ | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 | | 58209 74944[59230 78164]06286 20899 86280 +--| | 34825 34211 70679*82148 08651 32823 06647 |May the spirit | | 09384 46095 50582 23172 53594 08128 48111 | of π spread | | 74502 84102 70193 85211 05559 64462 29489 |around the world. | | 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! | | 38196 44288 10975 66593 34461 28475 64823 +-| | 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... | ++
Re: Slick way to update multiple tables.
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 key: 0xDD4276BA +-+ | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 | | 58209 74944[59230 78164]06286 20899 86280 +--| | 34825 34211 70679*82148 08651 32823 06647 |May the spirit | | 09384 46095 50582 23172 53594 08128 48111 | of π spread | | 74502 84102 70193 85211 05559 64462 29489 |around the world. | | 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! | | 38196 44288 10975 66593 34461 28475 64823 +-| | 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... | ++
Re: pgcrypto - real life examples to encrypt / decrypt
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 > https://github.com/michelp/pgsodium > > -- GnuPG/PGP key: 0xDD4276BA +-+ | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 | | 58209 74944[59230 78164]06286 20899 86280 +--| | 34825 34211 70679*82148 08651 32823 06647 |May the spirit | | 09384 46095 50582 23172 53594 08128 48111 | of π spread | | 74502 84102 70193 85211 05559 64462 29489 |around the world. | | 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! | | 38196 44288 10975 66593 34461 28475 64823 +-| | 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... | ++
Tab-completion error...?
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: Tab-completion error...?
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 pacman -Syyuu do? > > > You are correct in guessing what I did... > > > > config.log: > > a bunch of > > #define HAVE_LIBREADLINE 1 > > then > > configure:13450: checking readline/readline.h usability > > configure:13450: gcc -c -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after-statement -Werror=vla -Wendif-labels > > -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type > > -Wformat-security -fno-strict-aliasing -fwrapv > > -fexcess-precision=standard -Wno-format-truncation > > -Wno-stringop-truncation -O2 -I/home/ted/hercules-helper/rexx/include > > -D_GNU_SOURCE conftest.c >&5 > > configure:13450: $? = 0 > > > > configure:13450: result: yes > > configure:13450: checking readline/readline.h presence > > configure:13450: gcc -E -I/home/ted/hercules-helper/rexx/include > > -D_GNU_SOURCE conftest.c > > configure:13450: $? = 0 > > configure:13450: result: yes > > configure:13450: checking for readline/readline.h > > configure:13450: result: yes > > configure:13480: checking readline/history.h usability > > configure:13480: gcc -c -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after-statement -Werror=vla -Wendif-labels > > -Wmissing-format-attribute -Wimplicit-fallthrough=3 > > -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv > > -fexcess-precision=standard -Wno-format-truncation > > -Wno-stringop-truncation -O2 > > -I/home/ted/hercules-helper/rexx/include -D_GNU_SOURCE conftest.c > >&5 > > configure:13480: $? = 0 > > configure:13480: result: yes > > configure:13480: checking readline/history.h presence > > configure:13480: gcc -E -I/home/ted/hercules-helper/rexx/include > > -D_GNU_SOURCE conftest.c > > configure:13480: $? = 0 > > configure:13480: result: yes > > configure:13480: checking for readline/history.h > > configure:13480: result: yes > > configure:13602: checking zlib.h usability > > configure:13602: gcc -c -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after-statement -Werror=vla -Wendif-labels > > -Wmissing-format-attribute -Wimplicit-fallthrough=3 > > -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv > > -fexcess-precision=standard -Wno-format-truncation > > -Wno-stringop-truncation -O2 > > -I/home/ted/hercules-helper/rexx/include -D_GNU_SOURCE conftest.c > >&5 > > configure:13602: $? = 0 > > > > It looks good, doesn't it? > > N.B. v14.1 is the first version to have this problem. Another thought: > > perhaps the pacman -Syyuu update did it. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- GnuPG/PGP key: 0xDD4276BA +-+ | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 | | 58209 74944[59230 78164]06286 20899 86280 +--| | 34825 34211 70679*82148 08651 32823 06647 |May the spirit | | 09384 46095 50582 23172 53594 08128 48111 | of π spread | | 74502 84102 70193 85211 05559 64462 29489 |around the world. | | 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! | | 38196 44288 10975 66593 34461 28475 64823 +-| | 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... | ++
Re: Tab-completion error...?
ldd /usr/local/pgsql/bin/psql linux-vdso.so.1 (0xa2bef000) libpq.so.5 => /USR/local/lib/libpq.so.5 (0xa2aaf000) libreadline.so.8 => /usr/lib/libreadline.so.8 (0xa2a1d000) libpthread.so.0 => /usr/lib/libpthread.so.0 (0xa29ed000) libm.so.6 => /usr/lib/libm.so.6 (0xa2941000) libc.so.6 => /usr/lib/libc.so.6 (0xa27cd000) /lib/ld-linux-aarch64.so.1 => /usr/lib/ld-linux-aarch64.so.1 (0xa2bbe000) libncursesw.so.6 => /usr/lib/libncursesw.so.6 (0xa2748000 I'm at a loss as to where the /USR came from. It's not in config.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 might be linking > to an out-of-date copy of libpq.so provided by the OS. Linux > machines tend to do that (i.e., prefer libraries in /usr/lib[64]) > unless you mess with the dynamic loader's configuration. > > Try "ldd /path/to/psql" and see what it says about which libpq > is getting used. > > regards, tom lane > -- GnuPG/PGP key: 0xDD4276BA +-+ | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 | | 58209 74944[59230 78164]06286 20899 86280 +--| | 34825 34211 70679*82148 08651 32823 06647 |May the spirit | | 09384 46095 50582 23172 53594 08128 48111 | of π spread | | 74502 84102 70193 85211 05559 64462 29489 |around the world. | | 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! | | 38196 44288 10975 66593 34461 28475 64823 +-| | 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... | ++
Re: Tab-completion error...?
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 (0xa2bef000) > > libpq.so.5 => /USR/local/lib/libpq.so.5 (0xa2aaf000) > > libreadline.so.8 => /usr/lib/libreadline.so.8 (0xa2a1d000) > > libpthread.so.0 => /usr/lib/libpthread.so.0 (0xa29ed000) > > libm.so.6 => /usr/lib/libm.so.6 (0xa2941000) > > libc.so.6 => /usr/lib/libc.so.6 (0xa27cd000) > > /lib/ld-linux-aarch64.so.1 => /usr/lib/ld-linux-aarch64.so.1 > > (0xa2bbe000) > > libncursesw.so.6 => /usr/lib/libncursesw.so.6 (0xa2748000 > > Hm, is /USR actually in caps, or did you change that for emphasis? > > > I'm at a loss as to where the /USR came from. > > It's not in config.log (compile time) > > nor in the psql executable (run time). > > I think it came out of /etc/ld.so.conf. > > BTW, by default PG would link psql using an rpath switch pointing at > /usr/local/pgsql/lib, which I assume is where your manual build > put its libpq.so. That's evidently not having success getting that > libpq.so to be used. Did you tell configure to --disable-rpath? > Or maybe move the installation after building it? > > regards, tom lane > -- GnuPG/PGP key: 0xDD4276BA +-+ | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510 | | 58209 74944[59230 78164]06286 20899 86280 +--| | 34825 34211 70679*82148 08651 32823 06647 |May the spirit | | 09384 46095 50582 23172 53594 08128 48111 | of π spread | | 74502 84102 70193 85211 05559 64462 29489 |around the world. | | 54930 38196 44288 10975 66593 34461 28475 | PI VOBISCUM! | | 38196 44288 10975 66593 34461 28475 64823 +-| | 37867 83165 27120 19091 45648 56692 34603 48610 45432 6648... | ++
