Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

t 12:35 PM Laurenz Albe wrote: > On Fri, 2024-03-22 at 10:56 +0530, Daulat wrote: > > We recently started seeing an error “ERROR: uncommitted xmin 3100586 > > from before xid cutoff 10339367 needs to be frozen” on our user tables. > > I’m unable to do ‘vacuum’, ‘vacuum freez

uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen CONTEXT: while scanning block 1403 offset 8 of relation "pg_catalog.pg_attribute" Thanks, Daulat

Postgres partition max limit

Hi Team, Do we have a max limit of partitions for a table in postgres? Thanks.

Re: pgBackrest Error : authentication method 10 not supported

/postgresql-14.6.tar.gz Thanks On Thu, Feb 2, 2023 at 2:57 PM Magnus Hagander wrote: > > > On Thu, Feb 2, 2023 at 7:46 AM Daulat wrote: > >> I have pgbackrest v.43 installed on the same server where we are >> running postgres v14.6 that is upgraded from postgres v.10.2 &g

Re: pgBackrest Error : authentication method 10 not supported

Tue, Jan 31, 2023 at 7:32 PM Magnus Hagander wrote: > > > On Tue, Jan 31, 2023 at 2:58 PM Daulat wrote: > >> Hello, >> >> I am getting an error message " authentication method 10 not supported" >> while trying to create stanza on postgres14 after up

pgBackrest Error : authentication method 10 not supported

Hello, I am getting an error message " authentication method 10 not supported" while trying to create stanza on postgres14 after upgrading postgres from v.10 to Postgres v.14. I am using pgbackrest version: v.43 and the scram-sha-256 for hba authentication. pgbackrest.conf entry: cat /etc/pgb

index row size 2720 exceeds btree version 4

Hello Team, We are facing an error while uploading data in a table that has two B-tree indexes. As per the Postgres documentation there is a limitation of b-tree index size but I need to know if there is any alternative to overcome this issue. Error: " index row size 2720 exceeds btree version

Re: More than one Cluster on single server (single instance)

I have resolved this issue and it's working. Thanks On Thu, Jul 21, 2022 at 1:45 PM Daulat wrote: > Thanks for your inputs. > > We are thinking about this approach to consolidate some small applications > of individual clients and to perform administration (data/log/pgbackr

Re: More than one Cluster on single server (single instance)

Thanks for your inputs. We are thinking about this approach to consolidate some small applications of individual clients and to perform administration (data/log/pgbackrest backups etc.) separately which is not possible on a single cluster. We have tried to create and start the cluster with differ

More than one Cluster on single server (single instance)

Hello Team, We are planning to create multiple clusters on a single server (single instance) with PostgreSQL V.10 to run multiple applications. I don't know if it is a good idea to use a single machine to run n clusters but we are looking to minimize the cost of servers and other resources. Plea

Re: Max_connection

On Fri, Feb 18, 2022 at 2:39 PM Daulat wrote: > As I know, each PostgreSQL connection consumes RAM for managing the > connection or the client using it. The more connections, the more RAM. > I have a machine having 124 GB RAM and 16 CPU with SSD storage. > Currently, 1200 connections

Point in time recovery

Hello Team, I want to know the best way to ensure/verify that the Point in time recovery has done successfully after the crash and the restore. Thanks,

core. files inside base directory

Hello, I have the core. Files inside the base directory of my postgres 10 setup . Would you please let me know the importance of these files . When they generate . Can we delete them ? /base/ du -sh * 24M base 8.1Gcore.26166 1.5Gcore.26258 8.1Gcore.27849 12M core.27951 4.3G

RE: Real application clustering in postgres.

switchover method for Dataguard. How we can do in Postgres. Thanks, -Original Message- From: Laurenz Albe Sent: Thursday, March 5, 2020 5:37 PM To: Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: Real application clustering in postgres. On Thu, 2020-03-05 at 07:45 +

Real application clustering in postgres.

Hi team, Is there any possibility/options to setup a real application clustering in Postgres as in Oracle we have a RAC feature. What about multi-master replication in Postgres. would you please suggest how it is useful and how can setup it. Thanks.

how to find a tablespace for the table?

Hi team, how to find a tablespace for the table? See my comments below: I have created a database with default tablespace like below: edb=# CREATE DATABASE conndb WITH TABLESPACE = conn_s_tables; After that I have created a table CREATE TABLE COMPANY_new( ID INT PRIMARY KEY NOT NULL, N

RE: Can we have multiple tablespaces with in a database.

: Daulat Ram Cc: amul sul ; pgsql-general@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. > On Feb 20, 2020, at 22:34, Daulat Ram wrote: > > You mean we can have only single default tablespace for a database but the > database objects can b

RE: Can we have multiple tablespaces with in a database.

You mean we can have only single default tablespace for a database but the database objects can be created on different-2 tablespaces? From: amul sul Sent: Friday, February 21, 2020 11:48 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject

RE: Can we have multiple tablespaces with in a database.

, February 21, 2020 11:57 AM To: Daulat Ram Cc: amul sul ; pgsql-general@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. > On Feb 20, 2020, at 22:23, Daulat Ram wrote: > > That will be great if you share any doc where it’s mentioned that we can

RE: Can we have multiple tablespaces with in a database.

, February 21, 2020 11:48 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. On Fri, Feb 21, 2020 at 11:31 AM Daulat Ram mailto:daulat@exponential.com>> wrote: Hi Amul , Please sha

RE: Can we have multiple tablespaces with in a database.

abase test tablespace ‘conn_tbs'; Can we have multiple tablespaces with in a database in postgres? Yes. From: amul sul Sent: Friday, February 21, 2020 11:16 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject: Re: Can we have multi

Can we have multiple tablespaces with in a database.

Hi Team, Can we have multiple tablespaces with in a database in postgres? Can we have a table on different tablespace same as Oracle? Thanks,

Setting up an environment of EDB Advance server

Hi team, We would need your help in setting up an environment of EDB Advance Server 11 on Dev CentOS 7 VM. 1. We need to create three database with separate table spaces : Test1 Test2 Test3 What would be the good strategy for the setup with regards to the tablespaces? Can we create a separ

Postgres streaming replication

Hello team, I have to implement the streaming replication for our prod environment. Can you please share the list of parameters to setup the PostgreSQL 11 streaming replication with continuous archiving and give clarity on the below. * Do we need to enable the archive_mode and archive_comma

Re: pg_basebackup

thanks Adrian, what about the postmaster.opts file, this file was also skipped in backup. We have single cluster running on the VM. Thanks. On 22-Dec-2019 11:19 PM, Adrian Klaver wrote: On 12/22/19 1:56 AM, Daulat Ram wrote: > Hello, > > I am taking pg_basebackup of primary d

pg_basebackup

Hello, I am taking pg_basebackup of primary db (docker container env.) using the below command : pg_basebackup -x -h vmzti -U replication -D /etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P Password: WARNING: skipping special file "./postgresql.conf" WARNING: skipping special file "./

Access privileges

Hello, Can you please describe the " =Tc/postgres + postgres=CTc/postgres +confluence=CTc/postgres". I want to give the same permissions to the different user on a new database. List of databases Name| Owner | Encoding | Collate | Ctype |Access

How to Change collate & ctype for an existing database?

llate='C.UTF-8', datctype='C.UTF-8' where datname='wwkidbt'; Is there any impact on data/corruption if we do via update command ? Thanks, Daulat

RE: Postgres Point in time Recovery (PITR),

=== Password: Thanks, -Original Message- From: Andreas Kretschmer Sent: Friday, October 18, 2019 12:38 PM To: pgsql-general@lists.postgresql.org; Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: Postgres Point in time Recovery (PITR), On

RE: Barman

Thanks Tomas for your inputs. Suppose, if we have database in TB's with OLTP applications then what will be suitable backup strategy. -Original Message- From: Tomas Vondra Sent: Friday, November 1, 2019 12:27 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-per

Barman

Hi All, We have configured postgres 11.2 in streaming replication (primary & Standby) on docker and I am looking to initiate the Postgres backup using barman. As I know there are few options for taking backup using barman. RSYNC backup Incremental Backups Streaming Backup with continuous WAL s

RE: Postgres Point in time Recovery (PITR),

Kumar Sent: Friday, October 18, 2019 5:28 PM To: David Steele Cc: Luca Ferrari ; Andreas Joseph Krogh ; Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: Postgres Point in time Recovery (PITR), Hi Daulat, PITR entirely depends on what type of backups you choose. Sometimes, to reduce

Postgres Point in time Recovery (PITR),

Hello All, Can you please share some ideas and scenarios how we can do the PITR in case of disaster. Thanks,

RE: Monitor Postgres database status on Docker

res: count --- 7 Give me suggestions. Thanks, From: Daulat Ram Sent: Tuesday, September 24, 2019 3:35 PM To: Fan Liu ; pgsql-general@lists.postgresql.org Subject: RE: Monitor Postgres database status on Docker Thanks but how we can use it for docker container. Regards, Daulat Fro

RE: Monitor Postgres database status on Docker

Thanks but how we can use it for docker container. Regards, Daulat From: Fan Liu Sent: Tuesday, September 24, 2019 3:02 PM To: Daulat Ram ; pgsql-general@lists.postgresql.org Subject: RE: Monitor Postgres database status on Docker Hi, I am not from PostgreSQL team. Just let you know that when

Monitor Postgres database status on Docker

Hi team, We want to check the postgres database status on docker container just like we monitor Postgres (up / down) via /etc/init.d/postgresql status But I am not sure how we can do that with docker. Thanks, Daulat

Exporting and importing table having blob datatype.

Hello Team, We have a large table having blob data type. Anyone please suggest how we can export it from Oracle DB in parts via ora2pg and then import it into postgres. Thanks, Daulat

RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg

Oracle NLS_NCHAR WE8MSWIN1252 Oracle NLS_TIMESTAMP_FORMAT -MM-DD HH24:MI:SS.FF6 Oracle NLS_DATE_FORMAT -MM-DD HH24:MI:SS PostgreSQL CLIENT_ENCODING WIN1252 bash-4.2$ thanks -Original Message- From: Adrian Klaver Sent: Tuesday, August 13, 2019 11:27 PM To:

RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg

ESTAMP(6) FLOAT CLOB NUMBER CHAR DATE VARCHAR2 BLOB SQL> We are getting the same issue for tables which are having blob, clob and char data types. Thanks, Daulat -Original Message- From: Luca Ferrari Sent: Tuesday, August 13, 2019 8:32 PM To: Daulat Ram Cc: pgsql-performa...@lists.pos

ORA-24345: A Truncation or null fetch error occurred -ora2pg

thought this was the cause. But, I have set LongReadLen, on the db handle, equal to 9000. Thanks, Daulat

Oracle to postgres migration via ora2pg (blob data)

Hello team, We have to migrate a schema from oracle to postgres but there is one table that is having following large lob segments. This table is taking time to export. What parameters we have to set in ora2pg.conf to speed up the data export by ora2pg. Table:CLIENT_DB_AUDIT_LOG LOBSEGME

RE: Memory settings

214501 | 99.34 kbbm | 1944006 | 157383222 | 98.78 Thanks, Daulat From: Hans Schou mailto:hans.sc...@gmail.com>> Sent: Sunday, June 30, 2019 11:35 AM To: Daulat Ram mailto:daulat@exponential.com>> Cc: pgsql-general@lists.postgresql.org<mailto:pgsql-general@list

Memory settings

your suggestions. Regards, Daulat

Memory settings

tions. Regards, Daulat

Max_connections limit

mit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 sessions integer 3024 shared_server_sessions integer SQL> Regards, Daulat

How can generate alter sequence and drop constraints statements via ora2pg

Hi All, Any one can give me an idea how we can generate the alter sequence and drop constraints scripts /statements for a schema tables using ora2pg.conf Regards, Daulat

How to connect to toad Edge with postgresql running with docker container?

Hello team, Please suggest how to connect to toad Edge with postgresql running with docker container. Regards, Daulat

Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device

Hello team, I'm getting below error while accessing postgres11 database. Please suggest the solution for this issue. Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device at com.caucho.el

no matching entries in passwd file

Hello team, I have database & users created inside the docker but we are getting connection issue while trying to connect to database using user created in postgres. docker exec -it -u test b8e7ejb1e31d bash unable to find user test: no matching entries in passwd file Regards, Daulat

FATAL: SMgrRelation hashtable corrupted

shut down Regards, Daulat

bigint out of range

key: LIST (stat_date) Thanks, Daulat

RE: CREATE EXTENSION to load the language into the database

://bugs.alpinelinux.org/"; bash-4.4$ bash-4.4$ uname -a Linux psql_primary_kbcn 3.10.0-514.16.1.el7.x86_64 #1 SMP Wed Apr 12 15:04:24 UTC 2017 x86_64 Linux bash-4.4$ How did you install Postgres? Ans: We did installation via customized docker image provided by our dev ops team. Regards,

CREATE EXTENSION to load the language into the database

Hello team, We are getting below issue while creating a function in Potsgres 11.2 nagios=# create or replace function diskf (filesystem text, warn int, err int) returns text as $BODY$ nagios$# use warnings; nagios$# use strict; nagios$# my $fs = $_[0]; nagios$# my $w = $_[1]; nagios$# my $e = $

ERROR: operator does not exist: timestamp without time zone + integer

(38) NOT NULL kbdb(# ) ; ERROR: operator does not exist: timestamp without time zone + integer HINT: No operator matches the given name and argument types. You might need to add explicit type casts. Regards, Daulat

How to execute .sql file inside a postgres schema

Hello team, I have a database name "kbdb" that is having a schema "kb" and I want to execute the test.sql file inside this schema, Please help how we can do that. Regards, Daulat

Streaming Replication

10.29.0.0/16 md5 hostnossl replication replication,postgres172.17.0.0/16 md5 hostnossl replication replication,postgres10.29.0.0/16 md5 Please suggest what I have missed. Regards, Daulat

Backup and Restore (pg_dump & pg_restore)

s -W -F c -v -f tmp/postgres/backup/backup10/ kbcn_backup19 kbcn >& tmp/postgres/backup/backup10/ kbcn_backup19.log; echo $? > tmp/postgres/backup/backup10/_'date+%Y-%m-%d.%H:%M:%S' Please advise. Regards, Daulat