Re: Standard of data storage and transformation

On Tue, Aug 6, 2024 at 5:07 PM yudhi s wrote: > Hi All, > We are having a use case in which we are having transaction data for > multiple customers in one of the Postgres databases(version 15.4) and we > are consuming it from multiple sources(batch file processing, kafka event > processing etc).

Re: data checksums

On Wed, Aug 7, 2024 at 3:41 AM Daniel Gustafsson wrote: > > On 6 Aug 2024, at 18:29, Christophe Pettus wrote: > >> On Aug 6, 2024, at 08:11, bruno vieira da silva > wrote: > > >> the pg doc > >> mentions a considerable performance penality, how considerable it is? > > > > That line is probably

Re: Vacuum full connection exhaustion

On Thu, Aug 8, 2024 at 5:18 AM Costa Alexoglou wrote: > Hey folks, > > I noticed something weird, and not sure if this is the expected behaviour > or not in PostgreSQL. > > So I am running Benchbase (a benchmark framework) with 50 terminals (50 > concurrent connections). > There are 2-3 additiona

Re: Vacuum full connection exhaustion

On Thu, Aug 8, 2024 at 10:12 AM Christophe Pettus wrote: > > > > On Aug 7, 2024, at 10:34, Costa Alexoglou wrote: > > > > Hey folks, > > > > I noticed something weird, and not sure if this is the expected > behaviour or not in PostgreSQL. > > > > So I am running Benchbase (a benchmark framework)

Re: Getting specific partition from the partition name

On Thu, Aug 8, 2024 at 4:46 PM Greg Sabino Mullane wrote: > _MM_DD is already setup for sorting, so just do: > > SELECT table_name FROM information_schema.tables WHERE table_name ~ > 'table_part_p' ORDER BY 1 DESC; > > If you need to grab the numbers: > > SELECT substring('table_part_p2022_03

Re: Re: searching for libpq5-14.1-42PGDG.rhel8.x86_64

On Sat, Aug 10, 2024 at 5:45 AM 王瞿 wrote: > > Hi Laurenz Albe > > Thank you! > > > >The client libraries for this version are in > >https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-8-x86_64/postgresql14-14.1-1PGDG.rhel8.x86_64.rpm > > But My project was specified to use the package >

Re: PG Dump on 11 - Restore on 16 - is possible?

On Tue, Aug 13, 2024 at 5:47 AM Durumdara wrote: > Hello! > > We have to upgrade our server. The PG upgrade is impossible because of too > much data. > So we will create a new server with PG 16, and we have to migrate the > databases one by one (from a PG 11 server). > > Is it possible? > > Does

Re: PG Dump on 11 - Restore on 16 - is possible?

On Tue, Aug 13, 2024 at 5:47 AM Durumdara wrote: > Hello! > > We have to upgrade our server. The PG upgrade is impossible because of too > much data. > So we will create a new server with PG 16, and we have to migrate the > databases one by one (from a PG 11 server). > I'd also recommend that yo

Re: Novice with Postgresql - trying simple Stored Procedure

On Tue, Aug 13, 2024 at 11:32 AM wrote: > I have a simple 3 column table. The Table is a Month Name to number table > which also includes an effective date column. So 12 rows, 3 columns each. > > > > Here is the Stored Procedure I constructed to get the number if given the > name (3 parameters fo

Re: PG Dump on 11 - Restore on 16 - is possible?

On Tue, Aug 13, 2024 at 2:21 PM Tomas Vondra wrote: > On 8/13/24 11:47, Durumdara wrote: > > Hello! > > > > We have to upgrade our server. The PG upgrade is impossible because of > > too much data. > > I'm not sure I understand. What exactly is the problem with the amount > of data? > OP has a p

Re: What is the best way to upgrade pgAdmin on Windows?

On Thu, Aug 15, 2024 at 2:35 AM 毛毛 wrote: > Hey there, > > I just found out my pgAdmin is version 7.6, while the current version is > 8.6. Looks like it's time for an upgrade! > https://www.pgadmin.org/download/pgadmin-4-windows/ The latest is 8.10. > The notification I got had a link to the

Re: Looking for pg_config for postgresql 13.16

On Tue, Aug 20, 2024 at 11:56 AM H wrote: > I am looking for pg_config for postgresql 13.16 that I run under Rocky > Linux 9. It seems RL appstream latest version is pg_config in > libpq-devel-13.11-1.el9.x86_64 but dnf complains: > installed package postgresql13-"devel-13.16-2PGDG.rhel9.x86_64 o

Re: How to validate restore of backup?

On Thu, Aug 22, 2024 at 7:06 AM Vince McMahon wrote: > Hi, > > I have some questions When doing pg_restore of backup of a database to a > NEW server. > > Is there a way to ensure the data integrity is in tact, and user ID and > access works liked how it was in the old server? > pg_restore is jus

Re: How to validate restore of backup?

That's great on small databases. Not so practical when they're big. On Thu, Aug 22, 2024 at 7:10 AM Muhammad Usman Khan wrote: > Hi Vince, > For validation of databases, you can use the following approach > > /usr/pgsql-16/bin/pg_dump -d postgres -h localhost -p 5428 | md5sum > > /var/lib/pgsql

Re: How to validate restore of backup?

On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor wrote: > > > On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson > wrote: > >> That's great on small databases. Not so practical when they're big. >> >> So - - - - what is the recommended procedure for '

Re: How to validate restore of backup?

On Thu, Aug 22, 2024 at 10:22 AM Greg Sabino Mullane wrote: > On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor wrote: > >> >> >> On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson >> wrote: >> >>> That's great on small databases. Not so practica

Re: How to validate restore of backup?

On Thu, Aug 22, 2024 at 9:59 AM o1bigtenor wrote: > On Thu, Aug 22, 2024 at 8:03 AM Ron Johnson > wrote: > >> On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor wrote: >> >>> On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson >>> wrote: >>> >>>

Re: where is postres installed?

On Thu, Aug 22, 2024 at 8:36 PM Arbol One wrote: > After installing PostgreSQL on my Debian-12 machine, I typed 'postgres > --version' and got this msg: > *bash: postgres: command not found* > > 'psql --version', however, does work and gives me this message : > > *psql (PostgreSQL) 16.3 (Debian 1

Re: ERROR: could not open relation with OID XXXX

On Sun, Aug 25, 2024 at 9:42 AM Marcelo Zabani wrote: > Hi all, > > I can reproduce the error in the subject from time to time when querying > catalog tables while DDL is happening concurrently. Here's a bash script > that reproduces it (not always, you might have to run it many times until > you

Re: Problem with a Query

Aggressive autoanalyze and autovacuum settings solve most query problems. These are my settings: default_statistics_target = 5000 autovacuum_vacuum_scale_factor = 0.015 autovacuum_vacuum_threshold = 250 autovacuum_analyze_scale_factor = 0.015 autovacuum_analyze_threshold = 250 Such a high default_

Re: PgBackRest client_loop: send disconnect: Connection reset

On Thu, Aug 29, 2024 at 10:12 AM Greg Sabino Mullane wrote: > On Thu, Aug 29, 2024 at 9:31 AM KK CHN wrote: > >> "Unable to acquire lock on file '/tmp/pgbackrest/Repo-backup.lock' >> > > When this happens, take a look inside this file. If there is another > pgbackrest process running, the pid wi

Re: PgBackRest Full backup and N/W reliability

On Thu, Aug 29, 2024 at 12:08 PM KK CHN wrote: > > On Thu, Aug 29, 2024 at 6:54 PM Greg Sabino Mullane > wrote: > >> On Thu, Aug 29, 2024 at 2:21 AM KK CHN wrote: >> >>> I am doing a full backup using PgBackRest from a production server to >>> Reposerver. >>> >> ... >> >>> If so, does the back

Re: Table and data comparison

postgres_fdw will be required if the tables are in separate databases. On Tue, Sep 3, 2024 at 12:36 PM David Mullineux wrote: > Yes, PostgreSQL. > Why not just do this via SQL join ? > > On Tue, 3 Sept 2024, 17:34 arun chirappurath, > wrote: > >> Hi All, >> >> Do we have any open-source utility

Re: question on audit columns

On Wed, Sep 4, 2024 at 9:10 AM yudhi s wrote: > > On Wed, Sep 4, 2024 at 6:29 PM Muhammad Usman Khan > wrote: > >> Hi, >> >> In your scenario, triggers can add some overhead since they require extra >> processing after each update operation. Considering the size of your table >> and the high tra

Re: Faster data load

On Thu, Sep 5, 2024 at 4:14 PM Lok P wrote: > Hi, > > We are having a requirement to create approx 50 billion rows in a > partition table(~1 billion rows per partition, 200+gb size daily > partitions) for a performance test. We are currently using ' insert into > select.. From or transformed q

Re: Faster data load

On Fri, Sep 6, 2024 at 12:43 AM Lok P wrote: > Also during index creation we are trying to do it multiple partitions at > same time from multiple sessions.But seeing out of memory error in 5th or > 6th session. > Had that same problem during pg_restore. Reduced maintenance_work_mem and the prob

Better way to process records in bash?

(This might be a bash question instead of a PG question, or it might be an A/B question.) I need to process table records in a bash script. Currently, I read them using a while loop and redirection. The table isn't that big (30ish thousand rows), and performance is adequate, but am always lookin

Re: Better way to process records in bash?

On Thu, Sep 12, 2024 at 11:43 AM Thiemo Kellner wrote: > Hi > > What is this "something" that it cannot be calculated within the dB? > It's an external program that can't read a csv input file. -- Death to America, and butter sauce. Iraq lobster!

Re: Better way to process records in bash?

On Thu, Sep 12, 2024 at 3:30 PM Christoph Moench-Tegeder wrote: > ## Ron Johnson (ronljohnso...@gmail.com): > > > I need to process table records in a bash script. Currently, I read them > > using a while loop and redirection. The table isn't that big (30ish > > th

Re: update faster way

On Fri, Sep 13, 2024 at 11:59 PM yudhi s wrote: > >> >> Do you have any indexes? >> If not - you should, if yes - what are they? >> >> >> > Yes we have a primary key on this table which is on a UUID type column and > also we have other indexes in other timestamp columns . But how is this > going

Re: Reg: Size difference

On Sat, Sep 14, 2024 at 1:19 PM Vinay Oli wrote: > Hi Team > > I have been using PostgreSQL for the past 6 years. PostgreSQL has > significantly impacted my life, providing me with great opportunities for > knowledge and self-development. > > I'm currently facing a strange issue with PostgreSQL 1

Re: load fom csv

On Mon, Sep 16, 2024 at 11:36 AM Andy Hartman wrote: > I'm trying to run this piece of code from Powershell and it just sits > there and never comes back. There are only 131 records in the csv. > > $connectionString = > "Host=$pgServer;Database=$pgDatabase;Username=$pgUser;Password=$pgPassword" >

Re: question on plain pg_dump file usage

On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ) < markus.zwett...@zuerich.ch> wrote: > I have to do an out-of-place Postgres migration from PG12 to PG16 using: > > > > pg_dump -F p -f dump.sql … > > sed -i "s/old_name/new_name/g" > > psql -f dump.sql … > > > > Both databases are on UTF-8. >

More than one UNIQUE key when matching items..

/* I'm trying to port a system from SQL server, and at the same time better learn postgreSQL. I've come across a problem that is easily solved in that world, but I am struggling to find an approach in postgres that works. We have 2 sets of events A and B (sets), they have a shared number (ncode),

Re: More than one UNIQUE key when matching items..

Thank you, simple, and effective. Got sucked into trying to use a named constraint. Best regards Ron On Sat, 20 Mar 2021 at 20:00, Laurenz Albe wrote: > On Sat, 2021-03-20 at 15:51 +0000, Ron Clarke wrote: > > In SQL Server this is easy, we insert the records into a temporary tab

Re: More than one UNIQUE key when matching items..

Hey thanks for working out a solution to this deceptive problem. One of those you expect to be simple, but then all of a sudden it isn't. Best regards Ron On Sat, 20 Mar 2021 at 19:01, Allan Kamau wrote: > > > > > > > On Sat, Mar 20, 2021 at 6:52 PM Ron Cla

Installing 9.6.6 to a RHEL 6.7 server with no Internet access

Hi. According to https://www.postgresql.org/download/linux/redhat/ I must first install the repository.  However, since that system doesn't have Internet access, I need to manually copy the files from my Windows laptop to the RHEL 6.7 server and then localinstall them. So, the question: what

Re: Installing 9.6.6 to a RHEL 6.7 server with no Internet access

ww.ocs.pe - Original Message - From: "Ron Johnson" To: "PostgreSql-general" Sent: Wednesday, 21 February, 2018 10:49:00 Subject: Installing 9.6.6 to a RHEL 6.7 server with no Internet access Hi. According to https://www.postgresql.org/download/linux/redhat/ I must

initdb when data/ folder has mount points

Hi, v9.6.6 Apparently, initdb assumes that data/ is one big mount point. However, we have four mount points: /var/lib/pgsql/9.6/data/backup /var/lib/pgsql/9.6/data/base /var/lib/pgsql/9.6/data/pg_log /var/lib/pgsql/9.6/data/pg_xlog They are all empty.  How do I convince it to ignore the fact

Re: initdb when data/ folder has mount points

On 02/21/2018 06:01 PM, Tom Lane wrote: Ron Johnson writes: Apparently, initdb assumes that data/ is one big mount point. However, we have four mount points: /var/lib/pgsql/9.6/data/backup /var/lib/pgsql/9.6/data/base /var/lib/pgsql/9.6/data/pg_log /var/lib/pgsql/9.6/data/pg_xlog Don'

Re: initdb when data/ folder has mount points

On 02/22/2018 07:22 AM, David Steele wrote: On 2/22/18 1:16 AM, Michael Paquier wrote: On Wed, Feb 21, 2018 at 07:56:38PM -0500, David Steele wrote: On 2/21/18 7:01 PM, Tom Lane wrote: For pg_log, just put it somewhere else and set the appropriate configuration option to say where to write the

pg_update to a new machine?

The 2.8TB database must be moved to a new server in a new Data Center, and upgraded from 8.4.17 to 9.6.6 Will this work? pg_upgrade --old-datadir "CURSERVER://var/lib/pgsql/data" --new-datadir "NEWSERVER://var/lib/pgsql/data" --old-bindir "CURSERVER://usr/bin" --

Re: pg_update to a new machine?

On 02/24/2018 08:18 AM, Stephen Frost wrote: Greetings, * Ron Johnson (ron.l.john...@cox.net) wrote: The 2.8TB database must be moved to a new server in a new Data Center, and upgraded from 8.4.17 to 9.6.6 Will this work? pg_upgrade --old-datadir "CURSERVER://var/lib/pgsql

Re: pg_update to a new machine?

On 02/24/2018 03:10 PM, Stephen Frost wrote: [snip] To set up log shipping on 8.4, I do this, which works well: select pg_start_backup('some_meaningful_tag'); nohup rsync -avz /var/lib/pgsql/data/* postgres@${DESTIP}:/var/lib/pgsql/data/ & select pg_stop_backup(); That's not log shipping, for l

Re: pg_update to a new machine?

On 02/24/2018 06:40 PM, Stephen Frost wrote: Ron, * Ron Johnson (ron.l.john...@cox.net) wrote: On 02/24/2018 03:10 PM, Stephen Frost wrote: [snip] To set up log shipping on 8.4, I do this, which works well: select pg_start_backup('some_meaningful_tag'); nohup rsync -avz /var/lib/

Re: pg_dump throwing segfault error during backup

On Wed, Oct 9, 2024 at 4:08 AM Cassandra Thrift wrote: > Hello Team, > > We are facing a segfault issue while initiating backup with pg_dump. > This is for Postgresql community version 12.5 and rhel 7.4 (PostgreSQL > 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat > 4.8

Re: Disk is filling up with large files. How can I clean?

On Wed, Oct 9, 2024 at 9:02 AM Philip Semanchuk < phi...@americanefficient.com> wrote: > > > On Oct 9, 2024, at 5:52 AM, Torsten Förtsch > wrote: > > > > Filenames like 16665, 16665.1, 16665.2 etc all represent the same table > (or similar). The number 16665 is called the file node. > > > > To ge

Re: Failing GSSAPI TCP when connecting to server

On Sun, Sep 29, 2024 at 2:00 PM Peter wrote: > My application is trying to connect the database server, and meanwhile > tries to talk to the KDC server for a service ticket. > Earlier these TCP connections did run like this, and were successful: > > [snip] > > A configuration problem on the mach

Re: backup

On Mon, Oct 7, 2024 at 11:48 AM Andy Hartman wrote: > anyone use Powershell in an automated fashion to do DB backup? Would you > share your example? > PS can execute utilities, so using it as a wrapper for pg_dump and pg_restore (just like a bash script) is perfectly viable. -- Death to , and

Re: Load balancing of write queries among health-checked nodes

On Mon, Oct 7, 2024 at 11:04 PM wrote: > Hello. I have a PostgreSQL high availability cluster with Pgpool-II, but I > don't use the virtual IP feature so my clients don't know which node to > send queries to. DNS round-robin is not a solution because it can't > distinguish between healthy and dea

Re: Backup

On Wed, Oct 16, 2024 at 3:52 PM Tomas Vondra wrote: [snip] > You didn't specify the Postgres version - that matters, because older > pg_dump versions (before PG 16) do not support compression. Since PG 16 > you can use either -Fc or -Fd (instead of the tar format), and it'll > compress the output

Re: Backup

On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios < a.mantz...@cloud.gatewaynet.com> wrote: > Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε: > > On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman > wrote: > >> I am very new to Postgres and have always worked in the mssq

Re: Backup

On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman wrote: > I am very new to Postgres and have always worked in the mssql world. I'm > looking for suggestions on DB backups. I currently have a DB used to store > Historical information that has images it's currently around 100gig. > > I'm looking to tak

Re: Query performance issue

On Tue, Oct 22, 2024 at 3:02 PM Greg Sabino Mullane wrote: [snip] > * Don't use the "FROM table1, table2, table3" syntax but use "FROM table1 > JOIN table2 ON (...) JOIN table3 ON (...) > Why? -- Death to , and butter sauce. Don't boil me, I'm still alive. crustacean!

Re: repmgr 5.4.1 dependend package on RHEL9

On Mon, Oct 14, 2024 at 2:06 AM Mukesh Tanuku wrote: > Hello everyone, > > Question: We are installing *repmgr 5.4.1* along with postgres 15.6 on > RHEL 9 and facing an issue with the dependent development package json-c > *-devel-0.14-11.el9.x86_64**. *This package is not available on > RHEL re

Re: Postgres listens on random port

On Tue, Nov 5, 2024 at 9:22 AM Kal wrote: > > On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mullane > wrote: > >> Start by seeing where the port is actually being set by running this: >> >> select setting, source, sourcefile, sourceline from pg_settings where >> name = 'port'; >> Cheers, >> Greg >>

Re: adsrc

On Tue, Nov 5, 2024 at 4:45 PM Matt Zagrabelny wrote: > Greetings Pg folk, > > I've got a legacy app connecting to a legacy Pg database (9.4). > > I'd like to upgrade the database to Pg 15, but when I connect and perform > some tasks in the app, I get: > > ERROR: column d.adsrc does not exist at

Re: What to do with a PAAS-pg server

Settings, like "SELECT * FROM pg_settings;" On Wed, Oct 30, 2024 at 11:32 AM alexander al (leiden) wrote: > Hi, > > we have a supplier (via our client) who has an self build PAAS-version > of postgresql. Ok, you would say, that's fine. But, there is always an > but, we think the settings are not

Re: Setting "ucs_basic" as the default database collation

On Sun, Oct 27, 2024 at 5:32 AM Christophe Pettus wrote: > Is there a way to specify "ucs_basic" (or the other "standard collations" > [1]) collation as the default database collation at database creation time, > rather than on a per-column or per-operation basis? > > [1] > https://www.postgresql

Re: pgsql_tmp consuming most of the space.

On Fri, Nov 8, 2024 at 11:51 PM jayesh thakare wrote: > Hi all, > > In one of our production environment.. > > pgsql_tmp is taking about half of the space in FS. > And temp files are from Jan 2024. > > Our data fs is about to reach 98% percent.. > > Kindly suggest us what should be done to resolv

Re: PostgreSQL logical replication

The documentation tells you, down in the Notes section. https://www.postgresql.org/docs/16/sql-createpublication.html On Tue, Nov 12, 2024 at 5:46 AM Jayadevan M wrote: > Hello all, > > I am using PostgreSQL 16.4. I tried to set up logical replication with > "postgres" user and all worked fine.

Re: glibc updarte 2.31 to 2.38

Shaheed, How often do you sort words in text editors? How often do you have your text editor care whether the word you just typed is the *only* instance of that word in the document? Not too often. So... yes, we ignore the problem. The real question is why nobody notices it in other RDBMSs like

Re: Repeatable Read Isolation Level "transaction start time"

On Wed, Sep 25, 2024 at 4:23 PM Greg Sabino Mullane wrote: > On Wed, Sep 25, 2024 at 1:53 PM Tom Lane wrote: > >> Because we're not going to analyze the statement in the amount of depth >> needed to make that distinction before we crank up the >> transactional machinery. If it says SELECT, it g

Re: Repeatable Read Isolation Level "transaction start time"

On Wed, Sep 25, 2024 at 4:50 PM Greg Sabino Mullane wrote: > Since transactions should be "as short as possible, without being too >>> short", how much time is there between when you run "BEGIN;" and the first >>> "work statement"? >>> >> > I don't know that it really matters. For something autom

Re: Repeatable Read Isolation Level "transaction start time"

On Tue, Sep 24, 2024 at 8:29 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, September 23, 2024, Wizard Brony wrote: > >> >> https://www.postgresql.org/docs/16/transaction-iso.html#XACT-REPEATABLE-READ >> >> The PostgreSQL documentation for the Repeatable Read Isolation Lev

Re: Repeatable Read Isolation Level "transaction start time"

On Tue, Sep 24, 2024 at 12:06 PM Adrian Klaver wrote: > On 9/24/24 05:59, Ron Johnson wrote: > > On Tue, Sep 24, 2024 at 8:29 AM David G. Johnston > > mailto:david.g.johns...@gmail.com>> wrote: > > > > On Monday, September 23, 2024, Wizard Brony > &

Re: Regarding use of single column as primary key on partitioned table

On Sat, Sep 28, 2024 at 12:39 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Friday, September 27, 2024, Durgamahesh Manne < > maheshpostgr...@gmail.com> wrote: > >> >> ERROR: unique constraint on partitioned table must include all >> partitioning columns >> DETAIL: PRIMARY KEY c

Re: Regarding use of single column as primary key on partitioned table

On Sat, Sep 28, 2024 at 12:55 AM Tom Lane wrote: > Ron Johnson writes: > > On Sat, Sep 28, 2024 at 12:39 AM David G. Johnston < > > david.g.johns...@gmail.com> wrote: > >> On Friday, September 27, 2024, Durgamahesh Manne < > >>> Can't we use

Re: Dependencies on the system view

On Fri, Sep 20, 2024 at 7:32 AM Olleg wrote: > Hi all. > > One of our programmer created a view based on the system view. I tried > to explain him, that he created a dependency from the ordinary database > to the system object and this is a bad idea. But he is not smart enough. > So I need a guru

Re: How batch processing works

On Thu, Sep 19, 2024 at 1:31 AM Lok P wrote: > Hello, > Saw multiple threads around the same , so I want some clarification. As we > know row by row is slow by slow processing , so in heavy write systems(say > the client app is in Java) , people asked to do DMLS in batches rather in a > row by ro

Re: IO related waits

On Fri, Sep 20, 2024 at 4:47 PM Tom Lane wrote: > veem v writes: > > Able to reproduce this deadlock graph as below. Now my question is , > this > > is a legitimate scenario in which the same ID can get inserted from > > multiple sessions and in such cases it's expected to skip that (thus "On >

Re: How batch processing works

On Thu, Sep 19, 2024 at 5:24 AM Lok P wrote: > > On Thu, Sep 19, 2024 at 11:31 AM Ron Johnson > wrote: > >> >> [snip] >> >>> >>> Method-4 >>> >>> INSERT INTO parent_table VALUES (1, 'a'), (2, 'a'); >&g

Re: Repeatable Read Isolation Level "transaction start time"

On Wed, Sep 25, 2024 at 1:45 PM Adrian Klaver wrote: > > > On 9/25/24 10:22 AM, Greg Sabino Mullane wrote: > > On Tue, Sep 24, 2024 at 10:28 AM Tom Lane > > wrote: > > > > It's even looser than that, really: it's the first statement that > > requires an MVCC sn

Re: Repeatable Read Isolation Level "transaction start time"

On Wed, Sep 25, 2024 at 1:53 PM Tom Lane wrote: > Ron Johnson writes: > > But why does "SELECT 1;" need a snapshot? Heck, why does "SELECT > > ;" need a snapshot? > > Because we're not going to analyze the statement in the amount of > depth n

Re: Download of v16.1 for Windows 64B

On Thu, Oct 17, 2024 at 11:21 AM Carlos Oliva wrote: > Thank you, Erik. > > That download installed fine. I must use v16.1 because I will be working > with a legacy application. > What does that have to do with whether you use 16.1 or 16.4? (Note that PG point releases only fix bugs.) -- Deat

Re: Why plpython functions increase transaction counter much more then plpgsql functions?

Because the plpython function is executing dynamic SQL? On Fri, Nov 8, 2024 at 2:59 AM Michał Albrycht wrote: > I'm trying to understand why plpython function has much bigger impact on > transaction counter in Postgres than plpgSQL function. Below is example > which uses 2 functions: > > Version

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

On Sun, Nov 24, 2024 at 12:06 PM Christophe Pettus wrote: > > On Nov 24, 2024, at 09:03, Subhash Udata wrote: > > When we shut down the standby, upgrade it, and then start it back up, > will the replication automatically resume from the primary to the standby? > > Assuming that the standby has a

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

On Sun, Nov 24, 2024 at 4:58 PM Adrian Klaver wrote: > On 11/24/24 13:00, Ron Johnson wrote: > > On Sun, Nov 24, 2024 at 2:55 PM Christophe Pettus > <mailto:x...@thebuild.com>> wrote: > > > > > On Nov 24, 2024, at 09:15, Ron Johnson >

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

On Sun, Nov 24, 2024 at 11:05 AM Subhash Udata wrote: > Dear PostgreSQL Community, > > I have a production database setup with a primary server and a standby > server. The database is currently running on *PostgreSQL 15.0*, and I > plan to upgrade both servers to *15.9*. > > I have the following

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

On Sun, Nov 24, 2024 at 11:41 AM Adrian Klaver wrote: > On 11/24/24 08:36, Subhash Udata wrote: > > The reason to upgrade from 15.0 to 15.9 is this > > https://www.postgresql.org/support/security/CVE-2024-10979/ > > > > > > Here it is

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

On Sun, Nov 24, 2024 at 2:55 PM Christophe Pettus wrote: > > On Nov 24, 2024, at 09:15, Ron Johnson wrote: > > > > Doesn't the existence of a replication slot force PG to retain WAL files > when replication is broken? > > It does. I don't recall if the OP s

Re: PostgreSQL Log Info

Isn't "I need the query returned values" the purpose of the client application? On Fri, Nov 22, 2024 at 2:32 AM Jethish Jethish wrote: > Hi David, > > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. > > > For example if a select query

Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10

On Fri, Nov 22, 2024 at 4:01 AM Achilleas Mantzios - cloud < a.mantz...@cloud.gatewaynet.com> wrote: > > On 11/22/24 10:00, Matthias Apitz wrote: > [snip] > > Why not decouple client libs from the server ? i.e. psql works great > with many versions greater than its own. And certainly with same ma

Specifying columns returned by a function, when the function is in a SELECT column list?

It's trivial to specify columns when a table-returning function is the FROM clause, but how does one specify columns when the table-returning function is a column in a SELECT clause? I don't have the proper vocabulary to know what to Google for. Examples below: Easy: cdsbmop=# select downstream_

Re: Help with restoring database from old version of PostgreSQL

ue, Nov 19, 2024 at 5:13 PM Catherine Frock wrote: > Do you know what versions of PG and pgAdmin4 I need? Also, I don't know > where to get a different version of PG. > > -- > Arden > > > On Tue, Nov 19, 2024 at 5:01 PM Ron Johnson > wrote: > >> Ah, so

Re: Help with restoring database from old version of PostgreSQL

am trying to restore a previously backed up database .sql file that was > created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was > using). > > In response to Ron: Do I need to use PG16 instead of pgAdmin4? And if so, > can you please provide a website where I c

Re: Help with restoring database from old version of PostgreSQL

1. PG16 will read a PG 9.6 backup file, so there's no need to install PG 9.6. 2. Installing PG on a OneDrive share is certainly a Very Bad Idea. 3. PG is not the same as PgAdmin. On Thu, Nov 14, 2024 at 10:00 AM Catherine Frock wrote: > Yes, I still have the backup file. I tried to open pgAdmin4

Re: Help with restoring database from old version of PostgreSQL

On Wed, Nov 13, 2024 at 1:50 PM Catherine Frock wrote: > I'm seeking help in restoring a database that was created with PostgreSQL > 9.6. I backed it up successfully and have restored it before, but that was > when PostgreSQL 9.6 was still supported. After going through the > installation of Post

Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10

On Sat, Nov 23, 2024 at 4:39 PM Bruce Momjian wrote: > On Sat, Nov 23, 2024 at 03:24:47PM -0500, Ron Johnson wrote: > > On Sat, Nov 23, 2024 at 1:10 PM Bruce Momjian wrote: > > [snip] > > > > I have to admit, for this question, we just point people to

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum wrote: > Team > Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver > 15.X > > Env = EC2 based Community PostgreSQL Ver 13.16.2 > > we will be performing upgrade of our EC2 server too along with new OS. > > Need help in vetting

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

On Sun, Nov 24, 2024 at 11:52 AM Subhash Udata wrote: > I understand your point and appreciate the clarification. > > I have reviewed the references and now have a better understanding of the > minor upgrade process. > > However, my concern lies in the fact that we are working with production > s

Re: License question

On Mon, Nov 25, 2024 at 5:47 PM Clay Jackson (cjackson) < clay.jack...@quest.com> wrote: [snip] > Are you willing to sign up for "maintaining" PostgreSQL in your > environment, INCLUDING things like patching, finding and fixing bugs, > upgrades, backup and recovery, and off-hours support? Azure'

Re: Errors when restoring backup created by pg_dumpall

On Fri, Nov 29, 2024 at 8:35 PM PopeRigby wrote: > My HDD recently failed so I'm trying to restore my backup, but I'm > running into some errors. > > I've been using a systemd service that periodically backs up my cluster > with pg_dumpall, and I'm using this command to restore: > > sudo psql -f

Re: Help with syntax error

On Sun, Dec 1, 2024 at 7:14 PM Arbol One wrote: > I have these tables: > > > > > > > > > > > > > > > > > > > > *CREATE TABLE IF NOT EXISTS registrar ( index SERIAL, registrar_id TEXT, > day TEXT NOT NULL, month TEXT NOT NULL, year TEXT NOT NULL, hour TEXT NOT > NULL, minute TEXT NOT NULL, second

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

Adrian, OP is moving to a new VM when migrating to PG 15. When was the "cross-server" feature added to pg_upgrade? On Mon, Dec 2, 2024 at 5:48 PM Adrian Klaver wrote: > On 12/2/24 14:46, Adrian Klaver wrote: > > On 12/2/24 14:31, Ron Johnson wrote: > >> On Mon, De

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

On Wed, Dec 4, 2024 at 7:42 AM Bharani SV-forum wrote: > Team /Ron/Adrian > > Wann to reconfirm > we have an setup with > > new server will be with > > will be following the following suggestion > > *On old VM* [ existing server with OS "Amazon Linux release 2

Re: Errors when restoring backup created by pg_dumpall

On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston wrote: > On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson > wrote: > >> Another alternative is to open the .sql file in Notepad++, then add >> "public." before all the unqualified "earth" and "ll_to_earth&

Re: Questions about the Debian Package version of pgAdmin

On Sun, Jan 5, 2025 at 7:27 PM Nick wrote: > > I sent this to the PgAdmin list but didn't get any replies. Not sure > how many people are on that list, but since these questions are general > enough, I figure someone on the main list will know: > > I'm using the apt repository version for Debian

Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org

On Tue, Dec 24, 2024 at 4:28 AM Matthias Leisi wrote: > I installed Postgres 16/17 from apt.postgresql.org (with the intent of > using version 17) on Debian 12/Bookworm. Both have the same version of > repmgr: > > postgres@dev-pgcl01:~$ /usr/lib/postgresql/17/bin/repmgr --version > repmgr 5.5.0

Re: Using psql's \prompt command

On Thu, Jan 30, 2025 at 5:28 PM Rich Shepard wrote: > On Thu, 30 Jan 2025, David G. Johnston wrote: > > > Prompt isn’t your issue. Prompt stores the value into a variable. Read > how > > to reference variables in a psql script. > > David, > > Thank you. I'll look into using the \set command. > I

<    10   11   12   13   14   15   16   17   >