Re: Database upgrade Pg11 to Pg12 issues

2021-02-03 Thread Bruce Momjian
uld see a large value for the 11 directory and then the 12 > directory > would only show the files that weren't already counted when measuring the 11 > directory.  Running du on each version's directory separately might give > results that are more in line with expectatio

Re: Power loss test

2022-03-03 Thread Bruce Momjian
nd one, and had to hunt to find a link to add to the docs for that tool. If you find something better, please let us know. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: Looking for tips on improving full-text search quality in Postgres

2022-03-04 Thread Bruce Momjian
discussion the hackers list to see what is possible. I think it would be helpful if we just document what we _don't_ have. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres

2022-03-04 Thread Bruce Momjian
, while Solr is prioritizing terms that are earlier in the document? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres

2022-03-04 Thread Bruce Momjian
can't tell whether that > corpus-wide frequency information is taken into account in either > ranking function. > > I don't know if Solr weights earlier tokens more heavily, but I > wouldn't be surprised if it does. Sorry, I don't know what corpus

Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres

2022-03-04 Thread Bruce Momjian
ount is an interesting project that nobody's > tackled. Oh, you mean like, "pizza" is used only in this document vs it being used in every document. Should we add some documentation about this or is it already clear? -- Bruce Momjian https://momjian.us EDB

Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres

2022-03-04 Thread Bruce Momjian
reference.  Postgres can do that too. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: Fresh eyeballs needed: input into error [FIXED]

2022-04-26 Thread Bruce Momjian
curious what OS psql was using that was fixed by a re-login? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: Whole Database or Table AES encryption

2022-04-27 Thread Bruce Momjian
y is working on an implementation, perhaps for PG 16. You can also do column-level encryption on the server side via pgcrypto, or on the client side. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. In

Re: Whole Database or Table AES encryption

2022-04-28 Thread Bruce Momjian
On Thu, Apr 28, 2022 at 11:55:09PM +0100, Aaron Gray wrote: > On Wed, 27 Apr 2022 at 18:01, Bruce Momjian wrote: > > > > On Wed, Apr 27, 2022 at 05:21:41PM +0100, Aaron Gray wrote: > > > Hi, > > > > > > Is there any way to (virtually) encrypt whole d

Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure)

2022-06-01 Thread Bruce Momjian
ou should be on the most recent version of 12.X, and I do see some extended statistics change in the later releases you are missing. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: Oracle to Postgress Migration

2022-07-14 Thread Bruce Momjian
. > Please point me in the right direction. I would start here: https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: Paging through table one row at a ttime

2022-07-22 Thread Bruce Momjian
but it then sounded like you were looking for a terminal-level API, which kind of sounded like pspg, which you are using, but something much more sophisticated. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: Paging through table one row at a ttime

2022-07-22 Thread Bruce Momjian
e. I am not writing any application > code. I would ask the pspg author on something that specific. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: Postgres NOT IN vs NOT EXISTS optimization

2022-08-11 Thread Bruce Momjian
on? Couldn't we start to create the hash and just switch to always returning NULL if we see any NULLs while we are creating the hash? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: plpython questions

2022-08-16 Thread Bruce Momjian
On Tue, Aug 16, 2022 at 06:15:43PM -0500, Ted Toth wrote: > Is this the right list to ask questions about plpython? If not what > would be the best list or git repo to ask questions related to > plpython? Sure, go ahead. -- Bruce Momjian https://momjian

Postgres calendar?

2022-10-04 Thread Bruce Momjian
be done in Google Calendar, with an exported ICS file, or via a dedicated ICS file. I could even automate it by scraping our website. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an

Re: Different execution plan between PostgreSQL 8.4 and 12.11

2022-10-11 Thread Bruce Momjian
scanning > just a few rows, it does matter. We do have a correlation statistics value for each column but I am unclear if that would help here. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-11-29 Thread Bruce Momjian
eruser name > > How much time would it have taken to go to the docs?: > > https://www.postgresql.org/docs/current/app-initdb.html I know I am replying late here, but isn't it the database _cluster_ superuser? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, which you will never be.

Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-11-29 Thread Bruce Momjian
eaning of "superuser", > but otherwise plain "superuser" is fine. And we've settled on > "bootstrap superuser" as the best term for the role with OID 10. > So the present set of glossary entries looks fine to me. Thanks, agreed. I just wanted to suggest a cla

Re: Libpq linked to LibreSSL

2022-12-05 Thread Bruce Momjian
at you have to _compile_ Postgres using the LibreSSL includes --- you can't take a binary compliled for OpenSSL and link it against LibreSSL. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you

Re: snapshot question

2022-12-06 Thread Bruce Momjian
entations/internals.html#mvcc xip is a list of transaction that were open at the time the snapshot was taken. If the transaction commits after the snapshot is taken, it is still invisible. -- Bruce Momjian https://momjian.us EDB https://enterpr

Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration

2023-01-06 Thread Bruce Momjian
ata_Encryption Also, the first two patches in this email are doc patches which explain the benefits: https://www.postgresql.org/message-id/20210625212204.ga7...@momjian.us -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Em

Re: Use case for enabling log_duration other than benchmarking

2023-01-17 Thread Bruce Momjian
text when it _starts, while enabling only log_min_duration_statement prints the statement and duration when it _ends_. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, which you will never be.

Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?

2023-01-17 Thread Bruce Momjian
n wondered if we could document rules where multiple asychronous snapshots would be safe but have never gotten very far. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, which you will never be.

Re: pg_upgrade 13.6 to 15.1?

2023-01-17 Thread Bruce Momjian
On Sun, Jan 15, 2023 at 04:27:50PM -0500, p...@pfortin.com wrote: > >3) Again, read the docs multiple times there is a lot to understand. > > Agreed. But they could be a little clearer... :) Agreed the docs are complex, but how can they be clearer? -- Bruce Momjian

Re: Running pg_upgrade Version 11

2018-11-27 Thread Bruce Momjian
folder initialized correctly, so perhaps you messed up > > something in your environment? > > -- > > Michael > > > > Problem caused by my eyesight. > A colleague pointed out the typo in the argument to the -d parameter. > Working a

Re: Upgrade Standby

2018-11-27 Thread Bruce Momjian
p sr again... The pg_upgrade docs explain how to upgrade standby servers. You can use --link option for that even if you didn't use link option to upgrade the primary. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you

Re: oracle_fwd - is it safe or not?

2019-01-31 Thread Bruce Momjian
module? Uh, oracle_fwd uses a kernel module? Are you sure? That is surprising. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +

Re: Date calculation

2019-01-31 Thread Bruce Momjian
e > | >  2019-01-31 | 2019-02-03 > (1 row) Uh, this worked: SELECT date_trunc('week', CURRENT_TIMESTAMP) + '6 days'; ?column? ---- 2019-02-03 00:00:00-05 -- Bruce Momjian

Re: Date calculation

2019-01-31 Thread Bruce Momjian
On Thu, Jan 31, 2019 at 02:21:52PM -0600, Ron wrote: > On 1/31/19 2:15 PM, Bruce Momjian wrote: > >On Thu, Jan 31, 2019 at 02:11:14PM -0600, Ron wrote: > >>Hi, > >> > >>v9.6.6 > >> > >>Is there a built in function to calculate, for example

Re: Shared hosting with FDW on AWS RDS

2019-02-14 Thread Bruce Momjian
lot of tools (e.g. some GUI tools don't > know what to do if they get an error just listing the databases). Also it is > so piecemeal I wouldn't trust that I'd blocked off all avenues of getting > the information. > > I'd love to be corrected on this btw if anyone

Re: Channel binding not supported using scram-sha-256 passwords

2019-02-15 Thread Bruce Momjian
q and in interfaces not built using libpq, e.g. JDBC. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +

Re: pg_stat_statements doesn't track commit from pl/pgsql blocks

2019-02-21 Thread Bruce Momjian
'commit'? That is not a client-supplied command and is not tracked, and I am not sure we would want to do that. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. +

Re: PG Upgrade with hardlinks, when to start/stop master and replicas

2019-02-21 Thread Bruce Momjian
how it is for now. There was too much concern that users would accidentally start the old server at some later point, and its files would be hard linked to the new live server, leading to disaster. -- Bruce Momjian http://momjian.us EnterpriseDB http://e

Re: PG Upgrade with hardlinks, when to start/stop master and replicas

2019-02-21 Thread Bruce Momjian
On Thu, Feb 21, 2019 at 09:31:32PM -0500, Stephen Frost wrote: > Greetings, > > * Bruce Momjian (br...@momjian.us) wrote: > > On Tue, Feb 19, 2019 at 12:25:24PM -0500, Stephen Frost wrote: > > > Ah, right, I forgot that it did that, fair enough. > > > > &g

Re: DDL for database creation

2019-03-08 Thread Bruce Momjian
ame encoding, connection limit (if > anything was specified), etc. Is there a way to create this DDL? pg_dump --schema-only maybe? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am,

Re: Move vs. copy table between databases that share a tablespace?

2019-04-17 Thread Bruce Momjian
interesting exercise for someone to outline all the steps necessary. This is not for the faint of heart. ;-) -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +

Re: Forcing index usage

2019-04-17 Thread Bruce Momjian
coming > > changes in v12 especially changes to default behavior like this? Will there > > be a new cte_collapse_limit setting or similar? > > Check the release notes. Yes, once they are written in a few weeks. -- Bruce Momjian http://momjian.us EnterpriseDB

Re: Forcing index usage

2019-04-17 Thread Bruce Momjian
ttps://momjian.us/main/blogs/pgblog/2019.html#February_25_2019 Here is discussion about adding a GUC to set the old behavior, but was rejected: https://www.postgresql.org/message-id/flat/01d4caed%24d29b9ae0%2477d2d0a0%24%40pcorp.us -- Bruce Momjian http://momjian.us En

Re: Is it possible to store the output of EXPLAIN into a table

2019-04-22 Thread Bruce Momjian
t; > > Unfortunately, the query above does not work. I had to do this one and put the EXPLAIN in a function and then called the function and captured the output, see this and following slides: http://momjian.us/main/writings/pgsql/optimizer.pdf#page=11 -- Bruce Momjian

Re: Back Slash \ issue

2019-05-03 Thread Bruce Momjian
works in CSV mode. The Postgres COPY format is very reliable and able to dump/reload _any_ data sequence. Many commercial data dump implementations are simpler but are not able to be as reliable. The bottom line is that you are going to need to double the backslashes unles

Re: Back Slash \ issue

2019-05-03 Thread Bruce Momjian
On Fri, May 3, 2019 at 10:04:44AM -0400, Bruce Momjian wrote: > On thing the original poster might be missing is that the copy DELIMITER > is used between fields, while backslash is used as an escape before a > single character. While it might be tempting to try to redefine the

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-09 Thread Bruce Momjian
did blog posts about lockin and vendor selection strategy that might help: https://momjian.us/main/blogs/pgblog/2019.html#March_5_2019 https://momjian.us/main/blogs/pgblog/2019.html#March_7_2019 -- Bruce Momjian http://momjian.us EnterpriseDB

Re: Linked data from upgrade after VACUUM FULL not deleted.

2019-05-11 Thread Bruce Momjian
hy VACUUM FULL is not > releasing space in there. > > Is there any way how to check if anything in that folder is really not used > anymore and consider that safe to delete? > > I'll appreciate any suggestions. They is an output line of pg_upgrade which says: Running

Re: HOT update: why must ALL indexes should be update?

2023-04-28 Thread Bruce Momjian
ght, specifically the item pointer on the heap/table page can't be reused because _one_ of the indexes needs a new item pointer to point to. See the later sections of this talk for diagrams: https://momjian.us/main/presentations/internals.html#mvcc -- Bruce Momjian https

Re: RHEL repo package crc mismatches

2023-05-03 Thread Bruce Momjian
a1f176f708fa1d(sha256) > > Expected: > > 8c56cacb99771c4f06be2551988e553a70ea5e5459202e12e0e92fdeb7371621(sha256) > > > > For the pgdg12 RHEL 8 repository > > > > [MIRROR] pg_auto_failover_12-llvmjit-1.6.3-1.rhel8.x86_64.rpm: Downloadin

Re: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format?

2023-05-04 Thread Bruce Momjian
MERGE. The Query structure is converted into a Plan which is executed by the executor. It is not compiled into assembly language. See this: https://www.postgresql.org/developer/backend/ A -- Bruce Momjian https://momjian.us EDB https:

Re: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format?

2023-05-04 Thread Bruce Momjian
On Thu, May 4, 2023 at 09:16:20PM -0400, Bruce Momjian wrote: > Lex and yacc load command-specific structures, or a Query structure for > SELECT, INSERT, UPDATE, DELETE, MERGE. > > The Query structure is converted into a Plan which is executed by the > executor. It is not compile

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

2023-05-17 Thread Bruce Momjian
on keys for two databases in the > same server, respectively? How can one verify that?  It will not be in PG 16. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, wh

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

2023-05-18 Thread Bruce Momjian
eSQL. I have found it is hard to protect against the judgment of the ignorant, so I usually don't bother. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: How to make the generate_series to generate the letter series?

2023-05-30 Thread Bruce Momjian
> > Thanks in advance! > > SELECT chr(x + 96) FROM generate_series(1, 26) x A working example is: SELECT chr(x + 96) FROM generate_series(1, 26) as f(x); Here is a blog entry about more complex examples: https://momjian.us/main/blogs/pgblog/2012.html#July_24_2012 -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Pg 16: will pg_dump & pg_restore be faster?

2023-05-30 Thread Bruce Momjian
extending by a single page at a time got a good bit more scalable. Maybe just "Improve efficiency of extending relations"? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Pg 16: will pg_dump & pg_restore be faster?

2023-05-30 Thread Bruce Momjian
On Wed, May 31, 2023 at 02:05:10PM +1200, David Rowley wrote: > On Wed, 31 May 2023 at 13:13, Bruce Momjian wrote: > > There is no mention of concurrency being a requirement. Is it wrong? I > > think there was a question of whether you had to add _multiple_ blocks > > ot

Re: Pg 16: will pg_dump & pg_restore be faster?

2023-05-30 Thread Bruce Momjian
On Wed, May 31, 2023 at 02:18:25PM +1200, David Rowley wrote: > On Wed, 31 May 2023 at 14:11, Bruce Momjian wrote: > > > > On Wed, May 31, 2023 at 02:05:10PM +1200, David Rowley wrote: > > > "Relation extensions have been improved allowing faster bulk loading &g

Re: Pg 16: will pg_dump & pg_restore be faster?

2023-05-31 Thread Bruce Momjian
On Tue, May 30, 2023 at 10:28:58PM -0400, Bruce Momjian wrote: > On Wed, May 31, 2023 at 02:18:25PM +1200, David Rowley wrote: > > On Wed, 31 May 2023 at 14:11, Bruce Momjian wrote: > > > > > > On Wed, May 31, 2023 at 02:05:10PM +1200, David Rowley wrote: > > &

Re: Active Active PostgreSQL Solution

2023-06-09 Thread Bruce Momjian
On Fri, Jun 9, 2023 at 10:01:48AM -0300, Marcos Pegoraro wrote: > Postgres 16 will have origin on logical replication, so you can have Active > Active mode. Uh, I have no idea what that means and I didn't think we had active-active in PG 16. -- Bruce Momjian https://momji

Re: Active Active PostgreSQL Solution

2023-06-10 Thread Bruce Momjian
On Sat, Jun 10, 2023 at 02:18:18AM -0300, Marcos Pegoraro wrote: > > > Em sex., 9 de jun. de 2023 às 22:22, Bruce Momjian  > > > Uh, I have no idea what that means and I didn't think we had active-active > in version 16 > > https://postgrespro.com/bl

Re: Base files compatibility between PG11 and PG15

2023-08-17 Thread Bruce Momjian
compatibility provided by the PG community. > > We now experience problems with the data. > > This needs more information: > > 1) Describe the upgrade process > > 2) Describe the data problems. Plus it is Aurora, which is not community Postgre

Re: Will PostgreSQL 16 supports native transparent data encryption ?

2023-08-21 Thread Bruce Momjian
> > If not supported yet in the beta version I would like to know if PostgreSQL 16 > final version will support native transparent data encryption or not? Not, PG 16 will not support it, and I am unclear if later major versions will either. -- Bruce Momjian https://momjian.us

Re: Gradual migration from integer to bigint?

2023-09-30 Thread Bruce Momjian
that conditional is hard. > There's presumably other considerations I'm unaware of too. My core > question: are there significant technical blockers to supporting this > kind of gradual in place migration, or has it just not been enough of > a problem that it's recei

Re: Gradual migration from integer to bigint?

2023-10-06 Thread Bruce Momjian
too much. And the performance sounds terrible. ;-) -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: psql \du no more showing "member of" column

2023-10-18 Thread Bruce Momjian
ntry: s/informaion/information/ > > ciao, lele. Thanks, fix applied. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Presentation tools used ?

2023-10-23 Thread Bruce Momjian
presentations/general.html#presenting -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: REINDEX in tables

2023-10-25 Thread Bruce Momjian
> > > > > The client is now concerned about the issue that the number of > > > > > > rows in some of the above tables has increased. Is this possible? > > > no, reindex will not add rows to the table. > > But if the indexes were corrupted before the

Re: Question regarding the new SQL standard

2023-10-26 Thread Bruce Momjian
g from this comment. :-) -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: pg_checksums?

2023-10-27 Thread Bruce Momjian
on eventually made that clear. If we have more features that need this kind of dynamic ability, we might revisit this feature too. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Local postgres manual

2023-11-03 Thread Bruce Momjian
question for me. I poked though the doc makefile and it turns out that: make postgres.txt creates such a file. Here is the PG 16 version: https://momjian.us/expire/postgres-16.txt Let me know if you want a different Postgres version. -- Bruce Momjian https://momjia

Re: Local postgres manual

2023-11-03 Thread Bruce Momjian
at for me. Yes, we can do HTML too as a single file, postgres.html. What I don't see is man page output for anything but the references pages, and as separate files. It might be possible to convert the HTML to man format using something like html2man. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Finding execution plan

2023-11-03 Thread Bruce Momjian
for tracking planning and > execution statistics of all SQL statements executed by a server." Since he asked about execution plans, I was thinking auto_explain: https://www.postgresql.org/docs/current/auto-explain.html -- Bruce Momjian https://momjian.us EDB

Re: Local postgres manual

2023-11-03 Thread Bruce Momjian
l.1 && cat postgresql.1 >> /u/postgres/man/man1/postgresql.1 && rm postgresql.1 I pulled the formatting from postgres.1; without that the formatting was 80-column and poor. I think it doesn't define .TH and that makes it look bad. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: slightly unexpected result

2024-01-10 Thread Bruce Momjian
(1, 'x'); WITHx AS (UPDATE tf SET i=i+1 RETURNING *), y AS (UPDATE tf SET x=x||'yy' RETURNING *) SELECT * FROM x,y; i | x | i | x ---+---+---+--- TABLE tf; i | x ---+--- 2 | x I know you

Re: slightly unexpected result

2024-01-10 Thread Bruce Momjian
;" > > Yes, an error would be nice, but the effort put forth stops at unpredictable, > and saying just don't do it. Oh, good to know. :-) -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Parameter value in RDS

2024-01-16 Thread Bruce Momjian
ow should I calculate it? We can't answer RDS-specific questions here. I suggest you ask the vendor. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Parameter value in RDS

2024-01-16 Thread Bruce Momjian
On Tue, Jan 16, 2024 at 04:19:55PM -0500, Bruce Momjian wrote: > On Wed, Jan 17, 2024 at 02:42:16AM +0530, Atul Kumar wrote: > > Hi, > > > > I am new to RDS postgres, I have version 14 running on it with m7g.large > > > > I found that lots of parameters has DBIns

Re: Providers missing from pgdg-common for GDAL 3.7 (related to multiple missing providers from pgdg-common)

2024-01-24 Thread Bruce Momjian
res > libarmadillo.so.12()(64bit), but none of the providers can be installed >   - cannot install the best update candidate for package > gdal37-devel-3.7.2-1PGDG.rhel8.x86_64 >   - cannot install the best update candidate for package > gdal36-libs-3.6.4-5PGDG.rhel8.x86_64 -- Bruc

Re: Best practices for data buffer cache setting/tuning (v15)

2024-01-29 Thread Bruce Momjian
database systems: https://momjian.us/main/blogs/pgblog/2018.html#December_7_2018 -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Trouble with v16 new CREATEROLE semantic

2024-02-15 Thread Bruce Momjian
want to review my unreleased slide deck about users: https://momjian.us/main/writings/pgsql/user.pdf -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: v11.5- v15.3 upgrade (linux)

2024-03-06 Thread Bruce Momjian
is the most recent minor PG 15 version? https://www.postgresql.org/support/versioning/ -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation

2024-03-28 Thread Bruce Momjian
tation into Korean. I would appreciate > any > information on the details of this project and how to participate. I would look here: https://postgresql.kr/ -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: About postgres pg_upgrade

2024-04-06 Thread Bruce Momjian
gt; the old cluster into the new, but copies the table data. Your friend is thus > isn't wrong, it does use pg_restore but only for the schema, not the data. This presentation shows how it works internally: https://momjian.us/main/writings/pgsql/pg_upgrade.pd

Re: How to Build Postgres in a Portable / Relocatable fashion?

2024-05-03 Thread Bruce Momjian
company. My mistake. How did you come to that conclusion? Is there something we could do to avoid this assumption. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: How to Build Postgres in a Portable / Relocatable fashion?

2024-05-03 Thread Bruce Momjian
or another. I think it is that way because we don't have any guarantees or regular communication with "3rd party distributions". -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Bruce Momjian
ve replication are: > > * Do you really, really need it? (hint: the answer is no) > * What problem are you trying to solve? > * Are you really willing to suffer the tradeoffs? Agreed, see this: https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018 -- Bruce Momjian

Re: Planet Postgres and the curse of AI

2024-08-20 Thread Bruce Momjian
y sensible. :) Agreed. Honestly, some of the AI is so bad that if you see something you suspect is AI generated, you can just ask the author what they meant by that paragraph, and they will not be able to answer. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.

Re: WAL-G shipping to the cloud

2021-03-18 Thread Bruce Momjian
?  Well, there is Wal-E and Wal-G, which archive to the cloud. pg_backreset also supports cloud WAL storage. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
13 or do I need to > upgrade to 12 first and then to 13? > > > You can go straight to 13. We get this question often. Why do people feel they need to upgrade to intermediate releases? If we knew, maybe we could better clarify this. -- Bruce Momjian

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
to18. There are supported upgrade paths and you need to stick to > those, but they are documented. What other software needs to upgrade through all intermediate versions? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote: > On 3/30/21 8:06 AM, Bruce Momjian wrote: > > What other software needs to upgrade through all intermediate versions? > > Many variations of OS'es, though not all. One of the benefits of Ubuntu is > that you

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 03:25:06PM +, Daniel Westermann (DWE) wrote: > >On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote: > >> On 3/30/21 8:06 AM, Bruce Momjian wrote: > >> > What other software needs to upgrade through all intermediate versions? &g

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
e could better clarify this. > > I believe this is coming from the Oracle world. You can, e.g.not directly > > go from 9 to18. There are supported upgrade paths and you need to stick to > > those, but they are documented. > > Not even Postgresql allows you to jump from ancient v

Re: Is replacing transactions with CTE a good idea?

2021-04-01 Thread Bruce Momjian
ommits that happen between queries that are part of the same CTE. If you were running the queries separately in read committed mode, you would see those changes, but you would not see them in repeatable read or serializable transaction mode. -- Bruce Momjian

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
ervening versions with the need to read intervening version release notes. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion. diff --git a/templates/support/versioning.html

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
On Thu, Apr 1, 2021 at 07:26:14PM -0400, Jonathan Katz wrote: > On 4/1/21 6:06 PM, Bruce Momjian wrote: > An explicit sentence stating that major upgrades can skip major versions is > >> needed.  The document is written assuming the reading knows this, and just > >> makes

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
file: 03/03/2011 Zoster Vaccine Recombinant Adjuvanted (Shingrix) Dates on file: 10/31/2020, 08/25/2020 --- On Thu, Apr 1, 2021 at 09:18:07PM -0400, Bruce Momjian wrote: > On Thu, Apr 1, 2021 at

Re: Upgrading from 11 to 13

2021-04-01 Thread Bruce Momjian
On Thu, Apr 1, 2021 at 09:55:28PM -0400, Bruce Momjian wrote: > > Here it is with descriptions: Sorry, please ignore. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will

Re: Have I found an interval arithmetic bug?

2021-04-02 Thread Bruce Momjian
years) , > and that other stuff about adding one day to 23:00 on the day before the > “spring forward” moment taking you to 23:00 on the next day (i.w. when > intervals are added to timestamps) is downstream of simply adding two > intervals. > -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.

Re: Have I found an interval arithmetic bug?

2021-04-02 Thread Bruce Momjian
On Fri, Apr 2, 2021 at 01:20:26PM -0700, Ken Tanzer wrote: > On Fri, Apr 2, 2021 at 11:06 AM Bruce Momjian wrote: > > > Thread moved to hackers, with a patch. > > --- > > > > Here

Re: Upgrading from 11 to 13

2021-04-03 Thread Bruce Momjian
Yes you can. You run into the same issue going from 11 --> 12 --> 13, > you would just hit it in a different portion of the process. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Bruce Momjian https://momjian.us ED

Re: Is replacing transactions with CTE a good idea?

2021-04-04 Thread Bruce Momjian
On Sun, Apr 4, 2021 at 08:35:41AM -0400, Dave Cramer wrote: > > > On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote: > > On Thu, Apr  1, 2021 at 11:24:48AM -0400, Dave Cramer wrote: > > CTE's don't change the isolation level. I'm not sure what you

<    1   2   3   >