Re: PG 14 pg_basebackup accepts --compress=server-zst option

Ron Johnson writes: > On Fri, Jun 7, 2024 at 12:32 AM David G. Johnston < > david.g.johns...@gmail.com> wrote: >> I don’t see us adding an error message at this point. > Me neither. It just seemed odd. v14 thinks the argument of --compress must be an integer, and doesn't really bother with any

Re: Questions on logical replication

On 6/6/24 15:19, Koen De Groote wrote: I'll give them a read, though it might take a few weekends Meanwhile, this seems to be what I'm looking for: From https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS

PG16.1 security breach?

On Friday, June 7, 2024, Laurenz Albe wrote: > On Fri, 2024-06-07 at 13:54 +, Zwettler Markus (OIZ) wrote: > > > Another point to keep in mind is that by default, execute privilege is > granted to > > > PUBLIC for newly created functions (see Section 5.7 for more > information). > > > >

Re: AW: [Extern] Re: PG16.1 security breach?

On 6/7/24 06:54, Zwettler Markus (OIZ) wrote: -Ursprüngliche Nachricht- Von: Joe Conway Gesendet: Freitag, 7. Juni 2024 15:22 An: Zwettler Markus (OIZ) ; pgsql- gene...@lists.postgresql.org Betreff: [Extern] Re: PG16.1 security breach? On 6/7/24 07:04, Zwettler Markus (OIZ) wrote:

Re: AW: [Extern] Re: PG16.1 security breach?

On Fri, 2024-06-07 at 13:54 +, Zwettler Markus (OIZ) wrote: > > Another point to keep in mind is that by default, execute privilege is > > granted to > > PUBLIC for newly created functions (see Section 5.7 for more information). > > Argh. No! What a bad habit! > > Might be good idea for an

Re: PG16.1 security breach?

On Friday, June 7, 2024, Zwettler Markus (OIZ) wrote: > > grant usage on schema oiz to public; > > > > The role is also able to execute the function even I revoke any execute > privilege explicitly: > > > > revoke execute on function oiz.f_set_dbowner (p_dbowner text, p_dbname > text) from

AW: [Extern] Re: PG16.1 security breach?

> -Ursprüngliche Nachricht- > Von: Joe Conway > Gesendet: Freitag, 7. Juni 2024 15:22 > An: Zwettler Markus (OIZ) ; pgsql- > gene...@lists.postgresql.org > Betreff: [Extern] Re: PG16.1 security breach? > > On 6/7/24 07:04, Zwettler Markus (OIZ) wrote: > > I am running the following on

Re: PG16.1 security breach?

On 6/7/24 07:04, Zwettler Markus (OIZ) wrote: I am running the following on Postgres 16.1 in database "postgres" as a superuser: create or replace function oiz.f_set_dbowner (p_dbowner text, p_dbname text) create role testuser with password 'testuser' login; than this new role is

Re: Poor performance after restoring database from snapshot on AWS RDS

On Fri, Jun 7, 2024 at 4:36 AM Sam Kidman wrote: > > This is due to the way that RDS restores snapshots. > > Thanks, I never would have guessed. Would vacuum analyze be sufficient > to defeat the lazy loading or would we need to do something more > specific to our application? (for example.

Re: PG 14 pg_basebackup accepts --compress=server-zst option

On Fri, Jun 7, 2024 at 12:32 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, June 6, 2024, Kashif Zeeshan wrote: > >> Hi >> >> On Fri, Jun 7, 2024 at 6:54 AM Ron Johnson >> wrote: >> >>> >>> https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't >>> mention

PG16.1 security breach?

I am running the following on Postgres 16.1 in database "postgres" as a superuser: revoke create on schema public from public; revoke create on database postgres from public; create schema if not exists oiz; revoke create on schema oiz from public; grant usage on schema oiz to public; create or

Re: Poor performance after restoring database from snapshot on AWS RDS

> This is due to the way that RDS restores snapshots. Thanks, I never would have guessed. Would vacuum analyze be sufficient to defeat the lazy loading or would we need to do something more specific to our application? (for example. select(*) on some commonly used tables) I think vacuum full

RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

Hi Laurenz, Thanks a lot! Regards, Meera -Original Message- From: Laurenz Albe Sent: Wednesday, June 5, 2024 3:56 PM To: Meera Nair ; pgsql-general@lists.postgresql.org Cc: Punit Pranesh Koujalgi ; B Ganesh Kishan Subject: Re: Logical replication type- WAL recovery fails and

RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

Hi Ron, We do have our own solution. We work for Commvault, a data protection company. We support backup of PostgreSQL in different ways - streaming, snapshot, block level, backup from standby server. PostgreSQL (commvault.com)

Re: Oracle to Postgres - Transform Hash Partition

On Thu, 2024-06-06 at 11:28 -0500, David Barbour wrote: > Been an Oracle DBA for quite a while and we're moving from Oracle to Postgres. > > I have a table that I need to transform into a hash partitioned table. > I've gone through all the steps to create a hash partitioned table, with 8 >

Re: Oracle to Postgres - Transform Hash Partition

Hi David, Here is another approach. See if it serves your purpose postgres=# create schema idev; CREATE SCHEMA postgres=# postgres=# postgres=# CREATE TABLE idev.assessment_result_2023_dab ( district_oid int, -- other columns go here column1 numeric, column2 numeric ); CREATE

Re: PG 14 pg_basebackup accepts --compress=server-zst option

On Thursday, June 6, 2024, Kashif Zeeshan wrote: > Hi > > On Fri, Jun 7, 2024 at 6:54 AM Ron Johnson > wrote: > >> >> https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't mention >> "--compress=[{client|server}-]method". That first appears in the v15 >> docs. >> >> And yet

Re: PG 14 pg_basebackup accepts --compress=server-zst option

Hi On Fri, Jun 7, 2024 at 6:54 AM Ron Johnson wrote: > > https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't mention > "--compress=[{client|server}-]method". That first appears in the v15 docs. > > And yet pg_basebackup doesn't complain about an invalid option. > (Technically,

Re: Questions on logical replication

On Fri, Jun 7, 2024 at 3:19 AM Koen De Groote wrote: > I'll give them a read, though it might take a few weekends > > Meanwhile, this seems to be what I'm looking for: > > From > https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS > > " Replication slots provide

PG 14 pg_basebackup accepts --compress=server-zst option

https://www.postgresql.org/docs/14/app-pgbasebackup.html doesn't mention "--compress=[{client|server}-]method". That first appears in the v15 docs. And yet pg_basebackup doesn't complain about an invalid option. (Technically, this is a bug; I first noticed it a week after copying a script from a

Re: Questions on logical replication

I'll give them a read, though it might take a few weekends Meanwhile, this seems to be what I'm looking for: From https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS " Replication slots provide an automated way to ensure that the primary does not remove WAL

Re: Can't Remote connection by IpV6

On 6/6/24 10:37, Marcelo Marloch wrote: Reply to list also. Ccing list Hi Adrian thanks for your help, Server is running on windows and I set open 5432 port on windows firewall, I did not see any options regarding if ipv4 or v6. client also uses windows  and connects through odbc driver.

Re: Can't Remote connection by IpV6

On Thu, 2024-06-06 at 11:46 -0300, Marcelo Marloch wrote: > Hi everyone, is it possible to remote connect through IpV6? IpV4 > works fine but I cant connect through V6 > > postgresql.conf is to listen all address and pg_hba.conf is set > with host all all :: md5 i've tried ::/0 and ::0/0 but had

Re: Oracle to Postgres - Transform Hash Partition

## David Barbour (dbarb...@istation.com): > Now I need to 'attach' the original table. The problem I'm running into is > there are no good examples of how to define the values. The syntax is the same as with CREATE TABLE ... PARTITION OF, e.g. ALTER TABLE parent ATTACH TABLE part FOR VALUES

Tables get stuck at srsubstate = f

Hi all, I'm using logical replication with Postgres 15.2. When creating logical replication on multiple tables, sometimes the initial sync get stuck for few tables at state srsubstate = f. If I recreate the logical replication again, it may get stuck at srsubstate = f for other tables, so

Oracle to Postgres - Transform Hash Partition

Hi, New to this list and to Postgres. Been an Oracle DBA for quite a while and we're moving from Oracle to Postgres. I have a table that I need to transform into a hash partitioned table. I've gone through all the steps to create a hash partitioned table, with 8 partitions such as create table

Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

On Wed, Jun 5, 2024 at 6:26 AM Laurenz Albe wrote: > On Wed, 2024-06-05 at 06:36 +, Meera Nair wrote: > > 2024-06-05 11:41:32.369 IST [54369] LOG: restored log file > "00050001006A" from archive > > 2024-06-05 11:41:33.112 IST [54369] LOG: restored log file >

Re: Can't Remote connection by IpV6

On Thu, Jun 6, 2024 at 11:03 AM Adrian Klaver wrote: > On 6/6/24 07:46, Marcelo Marloch wrote: > > Hi everyone, is it possible to remote connect through IpV6? IpV4 works > > fine but I cant connect through V6 > > > > postgresql.conf is to listen all address and pg_hba.conf is set with > > host

Re: Can't Remote connection by IpV6

On 6/6/24 07:46, Marcelo Marloch wrote: Hi everyone, is it possible to remote connect through IpV6? IpV4 works fine but I cant connect through V6 postgresql.conf is to listen all address and pg_hba.conf is set with host all all :: md5 i've tried ::/0 and ::0/0 but had no success Is the

Re: Can't Remote connection by IpV6

Hi Marcelo Yes it's possible to connect remotely with postgres with ipv6 e.g. with psql. If you are facing issues then you need to make sure that you have done the required configurations. Please refer to the following links for more details.

Can't Remote connection by IpV6

Hi everyone, is it possible to remote connect through IpV6? IpV4 works fine but I cant connect through V6 postgresql.conf is to listen all address and pg_hba.conf is set with host all all :: md5 i've tried ::/0 and ::0/0 but had no success my provider is out of ipv4 and they're sending ips by

Re: how to tell if a pg version supports a linux distribution

On Wed, 2024-06-05 at 16:24 -0400, bruno vieira da silva wrote: > Hello, if a pg version has been tested on the buildfarm but the pg yum > repository doesn't have packages for a linux distribution that means > that distribution isn't supported by pg? how can I find if linux > distributions for a

Re: Questions on logical replication

On 6/5/24 14:54, Koen De Groote wrote: https://www.postgresql.org/docs/current/wal-configuration.html "Checkpoints are points in the sequence of transactions at which it is guaranteed that the heap and index data

Re: Questions on logical replication

> > https://www.postgresql.org/docs/current/wal-configuration.html > > "Checkpoints are points in the sequence of transactions at which it is > guaranteed that the heap and index data files have been updated with all > information written before that checkpoint. At checkpoint time, all > dirty

Re: how to tell if a pg version supports a linux distribution

On 6/5/24 1:24 PM, bruno vieira da silva wrote: Hello, if a pg version has been tested on the buildfarm but the pg yum repository doesn't have packages for a linux distribution that means that distribution isn't supported by pg? how can I find if linux distributions for a pg version have 

Re: how to tell if a pg version supports a linux distribution

On 6/5/24 1:24 PM, bruno vieira da silva wrote: Hello, if a pg version has been tested on the buildfarm but the pg yum repository doesn't have packages for a linux distribution that means that distribution isn't supported by pg? how can I find if linux distributions for a pg version have 

how to tell if a pg version supports a linux distribution

Hello, if a pg version has been tested on the buildfarm but the pg yum repository doesn't have packages for a linux distribution that means that distribution isn't supported by pg? how can I find if linux distributions for a pg version have regression tests executed against. e.g. : postgresql 16

Re: Long running query causing XID limit breach

On Wed, Jun 5, 2024 at 3:52 PM Laurenz Albe wrote: > > There should never be a restart unless you perform one or the standby > crashes. > If you mean that you want to avoid a crash caused by a full disk on the > standby, > the answer is probably "no". Make sure that you have enough disk space

Re: Length returns NULL ?

On 2024-06-05 19:50 +0200, Marcos Pegoraro wrote: > There are some functions called ...length, but only array_length returns > NULL on empty array, why ? Because the empty array has zero dimensions[1]. But now I'm wondering why array_ndims returns NULL instead of zero for empty arrays. [1]

Length returns NULL ?

There are some functions called ...length, but only array_length returns NULL on empty array, why ? select array_length('{}'::text[],1), -->NULL jsonb_array_length('[]'), -->0 bit_length(''), -->0 octet_length(''), -->0 length(''), -->0 char_length(''), -->0

Re: Variant (Untyped) parameter for function/procedure

On 6/5/24 01:34, Durumdara wrote: Dear Members! As I experienced, the functions/procedures extremely depend on parameters (very typed). So if I have to restructure the input parameters, I can't modify the function, because I have to recreate the dependents too. For example: I have a type. If

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 7:36 PM Ron Johnson wrote: > On Tue, Jun 4, 2024 at 3:47 PM Gavin Roy wrote: > >> >> On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson >> wrote: >> >>> >>> But why tar instead of custom? That was part of my original question. >>> >> >> I've found it pretty useful for

Re: Poor performance after restoring database from snapshot on AWS RDS

On Wed, Jun 5, 2024 at 4:23 AM Sam Kidman wrote: > We get very poor performance in the staging environment after this > restore takes place - after some usage it seems to get better perhaps > because of caching. > This is due to the way that RDS restores snapshots. >From the docs

Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

On Wed, 2024-06-05 at 06:36 +, Meera Nair wrote: > 2024-06-05 11:41:32.369 IST [54369] LOG:  restored log file > "00050001006A" from archive > 2024-06-05 11:41:33.112 IST [54369] LOG:  restored log file > "00050001006B" from archive > cp: cannot stat

Re: Long running query causing XID limit breach

On Wed, 2024-06-05 at 13:09 +0530, sud wrote: > > > One follow up question i have , as we are setting one of the > > > standby/replica > > > with value idle_in_transaction_session_timeout=-1 which can cause the > > > WAL's > > > to be heavily backlogged in a scenario where we have a query

Re: Unable to connect to any data source for foreign server

Hi, Getting back to this after a bit.  I am still having no luck.  I checked the settings for the postgres windows user between the new and old servers, and ensure they are matching.  The user has full control over the directory the file I want to connect to is located in. Here are the

Variant (Untyped) parameter for function/procedure

Dear Members! As I experienced, the functions/procedures extremely depend on parameters (very typed). So if I have to restructure the input parameters, I can't modify the function, because I have to recreate the dependents too. For example: I have a type. If I pass this type to a function, I

Re: Poor performance after restoring database from snapshot on AWS RDS

Sam Kidman schrieb am 03.06.2024 um 10:06: > We get very poor performance in the staging environment after this > restore takes place - after some usage it seems to get better perhaps > because of caching. > > The staging RDS instance is a smaller size than production (it has > 32GB ram and 8

Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

Hi team, With wal_level = 'logical', backup was taken using non-exclusive backup method. Following procedure here for restore and recovery - PostgreSQL: Documentation: 16: 26.3. Continuous Archiving and Point-in-Time Recovery

Poor performance after restoring database from snapshot on AWS RDS

We keep the staging environment of our application up to date with respect to production data by creating a new RDS instance for the staging environment and restoring the most recent production snapshot into it. We get very poor performance in the staging environment after this restore takes

Re: Postgresql 16.3 Out Of Memory

It looks like I did not copy the list. I did run VACUUM ANALYZE after the upgrade. I've even run it now > before getting a new explain plan that is very similar (just the costs > differ): > Gather Merge (cost=12336145.92..16111570.23 rows=31531596 width=66) >Workers Planned: 4 >-> Sort

Re: Long running query causing XID limit breach

On Wed, 5 Jun, 2024, 12:39 pm Simon Elbaz, wrote: > Hi, > > I am following this very interesting thread. > > From the documentation > https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT, > the 0 value will disable the timeout (not -1). > > >

Re: Long running query causing XID limit breach

Hi, I am following this very interesting thread. >From the documentation https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT, the 0 value will disable the timeout (not -1). On Wed, Jun 5, 2024 at 8:25 AM sud wrote: > Hello Laurenz, > >

Re: Long running query causing XID limit breach

Hello Laurenz, Thank you so much.This information was really helpful for us understanding the working of these parameters. One follow up question i have , as we are setting one of the standby/replica with value idle_in_transaction_session_timeout=-1 which can cause the WAL's to be heavily

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 3:47 PM Gavin Roy wrote: > > On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson > wrote: > >> >> But why tar instead of custom? That was part of my original question. >> > > I've found it pretty useful for programmatically accessing data in a dump > for large databases outside of

Re: Questions on logical replication

On 6/4/24 15:55, Koen De Groote wrote: I recently read the entire documentation on logical replication, but am left with a question on the buildup of WAL On this page: https://www.postgresql.org/docs/current/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRIPTION-SLOT

Re: Questions on logical replication

Reading this: https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS " Replication slots provide an automated way to ensure that the primary does not remove WAL segments until they have been received by all standbys, and that the primary does not remove rows which

Questions on logical replication

I recently read the entire documentation on logical replication, but am left with a question on the buildup of WAL On this page: https://www.postgresql.org/docs/current/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRIPTION-SLOT It is written: " When dropping a subscription, the

Re: Purpose of pg_dump tar archive format?

On Tue, 4 Jun 2024 at 20:47, Gavin Roy wrote: > > On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson > wrote: > >> >> But why tar instead of custom? That was part of my original question. >> > > I've found it pretty useful for programmatically accessing data in a dump > for large databases outside of

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson wrote: > > But why tar instead of custom? That was part of my original question. > I've found it pretty useful for programmatically accessing data in a dump for large databases outside of the normal pg_dump/pg_restore workflow. You don't have to seek

Re: Purpose of pg_dump tar archive format?

On 6/4/24 13:15, Ron Johnson wrote: On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent wrote: On 6/4/24 11:40, Shaheed Haque wrote: > > We use it. I bet lots of others do too. > > Of course.  There are lots of small, real, useful databases in the wild. But why tar

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent wrote: > > > On 6/4/24 11:40, Shaheed Haque wrote: > > > > We use it. I bet lots of others do too. > > > > > > Of course. There are lots of small, real, useful databases in the wild. > But why tar instead of custom? That was part of my original

Re: Purpose of pg_dump tar archive format?

On 6/4/24 11:40, Shaheed Haque wrote: We use it. I bet lots of others do too. Of course.  There are lots of small, real, useful databases in the wild.

Re: Bugs details.

On 2024-06-04 19:55 +0200, Muhammad Salahuddin Manzoor wrote: > I need to get detailed information about PG bugs and fixes. > > I can get the information about new features and Fixes in the release > document but I find only descriptions for each fix. I need detailed > information about these

Bugs details.

Greetings, I need to get detailed information about PG bugs and fixes. I can get the information about new features and Fixes in the release document but I find only descriptions for each fix. I need detailed information about these fixes. How can I get details about the fix. Suppose the

Re: Purpose of pg_dump tar archive format?

We use it. I bet lots of others do too. On Tue, 4 Jun 2024, 18:06 Adrian Klaver, wrote: > Reply to list also. > Ccing list > > On 6/4/24 10:03 AM, Ron Johnson wrote: > > > > > If you don't need the tar format then don't use it. > > > > > > That's neither the purpose nor the point of my

Re: Purpose of pg_dump tar archive format?

Reply to list also. Ccing list On 6/4/24 10:03 AM, Ron Johnson wrote: If you don't need the tar format then don't use it. That's neither the purpose nor the point of my question. I think that a note in the docs mentioning that it's obsolete would be helpful for new users who recognize

Re: Purpose of pg_dump tar archive format?

Adrian Klaver writes: > If you don't need the tar format then don't use it. Indeed. FTR, I think the original motivation for tar format was to have a "standard" structured output format that could be manipulated with tools other than pg_restore. Years later, we added the directory format which

Re: Purpose of pg_dump tar archive format?

On 6/4/24 08:25, Ron Johnson wrote: On Tue, Jun 4, 2024 at 10:43 AM Adrian Klaver > wrote: On 6/4/24 05:13, Ron Johnson wrote: > It doesn't support compression nor restore reordering like the custom > format, so I'm having trouble seeing why

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 10:43 AM Adrian Klaver wrote: > On 6/4/24 05:13, Ron Johnson wrote: > > It doesn't support compression nor restore reordering like the custom > > format, so I'm having trouble seeing why it still exists (at least > > without a doc warning that it's obsolete). > > pg_dump

Re: Purpose of pg_dump tar archive format?

On 6/4/24 05:13, Ron Johnson wrote: It doesn't support compression nor restore reordering like the custom format, so I'm having trouble seeing why it still exists (at least without a doc warning that it's obsolete). pg_dump -d test -U postgres -Ft | gzip --stdout > test.tgz -- Adrian Klaver

Re: Purpose of pg_dump tar archive format?

On 2024-06-04 14:13 +0200, Ron Johnson wrote: > It doesn't support compression nor restore reordering like the custom > format, so I'm having trouble seeing why it still exists (at least without > a doc warning that it's obsolete). Maybe because of this: > * The tar format also includes a

Purpose of pg_dump tar archive format?

It doesn't support compression nor restore reordering like the custom format, so I'm having trouble seeing why it still exists (at least without a doc warning that it's obsolete).

Re: Unexpected results from CALL and AUTOCOMMIT=off

Victor Yegorov writes: > пн, 3 июн. 2024 г. в 20:40, Pierre Forstmann : >> If you remove stable from function declaration, it works as expected: > ... therefore I assume STABLE should work in this case. Well, it seems not > to. I agree that this looks like a bug, since your example shows that

Re: Unexpected results from CALL and AUTOCOMMIT=off

пн, 3 июн. 2024 г. в 20:40, Pierre Forstmann : > You declared function f_get_x as stable which means: > > … > > If you remove stable from function declaration, it works as expected: > Well, I checked https://www.postgresql.org/docs/current/xfunc-volatility.html There's a paragraph describing why

Re: Unexpected results from CALL and AUTOCOMMIT=off

You declared function f_get_x as stable which means: https://www.postgresql.org/docs/15/sql-createfunction.html STABLE indicates that the function cannot modify the database, and that within a single table scan it will consistently return the same result for the same argument values, but that

Unexpected results from CALL and AUTOCOMMIT=off

Greetings. I am observing the following results on PostgreSQL 15.7 First, setup: create table t_test(x bigint); insert into t_test values(0); create or replace function f_get_x() returns bigint language plpgsql stable as $function$ declare l_result bigint; begin select x into l_result

Re: Postgresql 16.3 Out Of Memory

On Mon, Jun 3, 2024 at 9:12 AM Greg Sabino Mullane wrote: > On Mon, Jun 3, 2024 at 6:19 AM Radu Radutiu wrote: > >> Do you have any idea how to further debug the problem? >> > > Putting aside the issue of non-reclaimed memory for now, can you show us > the actual query? The explain analyze you

Re: Postgresql 16.3 Out Of Memory

On Mon, Jun 3, 2024 at 6:19 AM Radu Radutiu wrote: > Do you have any idea how to further debug the problem? > Putting aside the issue of non-reclaimed memory for now, can you show us the actual query? The explain analyze you provided shows it doing an awful lot of joins and then returning 14+

Postgresql 16.3 Out Of Memory

Hello, I have an out of memory problem after upgrading from postgresql 12 to 16.3. I have identified one query that can reproduce the error on demand. Once the query starts, it will eventually exhaust all RAM and swap until the OOM killer will stop postgresql. The setup is as follows: - One

Proposing a PostgreSQL Independent Professionals Network

Hi everyone, At Pgconf.dev I had a number of conversations around improving support and diversity in the community, as well as discussions of interest groups within the community. Out of this has come an idea I would like to float for improving both support for independent professionals in the

Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

On Fri, May 31, 2024 at 1:25 PM Alanoly Andrews wrote: > Yes, and I know that upgrading the Postgres version is the stock answer > for situations like this. The upgrade is in the works. > *Patching *was the solution. It takes *five minutes*. Here's how I did it (since our RHEL systems are

Re: Issue with PostgreSQL Installer on Windows and Special Characters in the superuser password

On 5/31/24 14:18, Timo Schwaak wrote: Dear PostgreSQL community, I hope this is the right place for my concern. Today I discovered a strange behaviour of the Windows Installer of PostgreSQL. While migrating an application database from MSSQL, the Postgres setup did not seem to complete

Issue with PostgreSQL Installer on Windows and Special Characters in the superuser password

Dear PostgreSQL community, I hope this is the right place for my concern. Today I discovered a strange behaviour of the Windows Installer of PostgreSQL. While migrating an application database from MSSQL, the Postgres setup did not seem to complete correctly and had problems starting the

Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

Thanks, Thom. I understand from your response that there is really no way to repair the current damage. Yes, we do take daily backups and we have, in fact, restored the database cluster to a point in time before the corruption, suffering some loss of data in the process. I'm now working with

Re: Rules and Command Status - update/insert/delete rule with series of commands in action

On 5/30/24 15:34, johnlu...@hotmail.com wrote: On 5/30/24 4:56 PM, David G. Johnston wrote: Very little interest exists in working on user-specified rules.  They are practically deprecated. Ah  -   pity  -   see my last comment to Adrian's Any interest in perhaps providing a

Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

On Fri, May 31, 2024, 09:29 Laurenz Albe wrote: > On Thu, 2024-05-30 at 14:58 +, Alanoly Andrews wrote: > > We have a postgres 10.7 database which reports a number of issues on > user-created > > tables as well as system tables. Most errors are one of the following: > > -- ERROR: found xmin

Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

On Thu, 2024-05-30 at 14:58 +, Alanoly Andrews wrote: > We have a postgres 10.7 database which reports a number of issues on > user-created > tables as well as system tables. Most errors are one of the following: > -- ERROR:  found xmin 1888159934 from before relfrozenxid 1998177448 > --

Re: Rules and Command Status - update/insert/delete rule with series of commands in action

> On 31 May 2024, at 00:34, johnlu...@hotmail.com wrote: > > On 5/30/24 4:56 PM, David G. Johnston wrote: (…) >> If anything is done it would have to be new syntax. >> >> > A much bigger task surely. > > On 5/30/24 5:19 PM, Adrian Klaver wrote: >> >> 2) Use INSTEAD OF triggers: >>

Re: [pgpool-general: 9106] Postgres/pgpool HA failover process

BTW here is the network configuration we set as UTOCONNECT_PRIORITY=120 BOOTPROTO=dhcp DEVICE=eth0 DHCPV6C=yes HWADDR= IPV6INIT=yes ONBOOT=yes TYPE=Ethernet USERCTL=no Regards Mukesh Tanuku On Wed, May 29, 2024 at 12:53 PM Mukesh Tanuku wrote: > Thanks Bo for your response to my email. > >

Re: [EXT] Re: How to delete column level Stats/Histogram

(please keep communication on the list) On Fri, 31 May 2024 at 13:43, Wong, Kam Fook (TR Technology) wrote: > > Silly question why did I run into this problem below? Will the autovacuum > analyze abc reset it back which I don't want it to. > > DELETE FROM pg_statistic WHERE starelid =

Re: Rules and Command Status - update/insert/delete rule with series of commands in action

"johnlu...@hotmail.com" writes: > But I suppose that my next question,   given what you both say about the > RULE system being a dead-end,  is whether there is any likelihood of > supporting an INSTEAD OF trigger on a view at statement level?   Maybe > that stands more chance of going

Re: Dll libpq.dll 32 bits

What type of project are you developing at Windev? As a proof of concept, maybe using libpq.lib we can do something Atte JRBM El jue, 30 may 2024 a las 16:37, José Mello Júnior (< jose.mello.jun...@gmail.com>) escribió: > Don't have more? > > Em qui., 30 de mai. de 2024, 16:14, Juan Rodrigo

Re: How to delete column level Stats/Histogram

On Fri, 31 May 2024 at 09:28, Wong, Kam Fook (TR Technology) wrote: > Is there a way to delete a specific column level stats/histogram. The > following approach does not work. > > alter table abc alter column bg_org_partner set statistics 0; > analyze abc; You'd have to: DELETE FROM

Re: Rules and Command Status - update/insert/delete rule with series of commands in action

On 5/30/24 4:56 PM, David G. Johnston wrote: Very little interest exists in working on user-specified rules.  They are practically deprecated. Ah  -   pity  -   see my last comment to Adrian's Any interest in perhaps providing a choice via a configuration parameter?  If

How to delete column level Stats/Histogram

1. Is there a way to delete a specific column level stats/histogram. The following approach does not work. alter table abc alter column bg_org_partner set statistics 0; analyze abc; select * FROM pg_stats where tablename in ('abc' ) and attname = 'bg_org_partner'; the

Re: Rules and Command Status - update/insert/delete rule with series of commands in action

On 5/30/24 11:32, johnlu...@hotmail.com wrote: Any thoughts?  Any rationales one way or the other?    Any interest in perhaps providing a choice via a configuration parameter? 1) As to using rules, stop now before you invest the time to find out is a road you don't want to go down. 2)

Re: Rules and Command Status - update/insert/delete rule with series of commands in action

On Thu, May 30, 2024, 12:32 johnlu...@hotmail.com wrote: > Any thoughts? > Very little interest exists in working on user-specified rules. They are practically deprecated. > > Any interest in perhaps providing a choice via a configuration > parameter? > Almost certainly not.

Re: Dll libpq.dll 32 bits

Don't have more? Em qui., 30 de mai. de 2024, 16:14, Juan Rodrigo Alejandro Burgos Mella < rodrigoburgosme...@gmail.com> escreveu: > postgresql odbc has 32 and 64 bits, and you make a System DSN and that's it > I have made implementations for PHP, .Net, C#, Python; even ASP Classic. > > Atte. >

ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

Hi, We have a postgres 10.7 database which reports a number of issues on user-created tables as well as system tables. Most errors are one of the following: -- ERROR: found xmin 1888159934 from before relfrozenxid 1998177448 -- ERROR: MultiXactId 613819197 does no longer exist -- apparent

  1   2   3   4   5   6   7   8   9   10   >