Re: What linux version to install ?

On Thu, Apr 25, 2024 at 12:45 PM Adrian Klaver wrote: > On 4/2/24 16:53, David Gauthier wrote: > > This is what we are running... > > Red Hat Enterprise Linux Server release 7.9 (Maipo) > > > > In our pandora distrib, I see PG v15.3. I was wondering if there is > > something even better. Can't s

Re: best migration solution

ext >- exclude all schemas not needed > > edit this dump file and > >- exclude any "create extension" command for not existing extensions >- change all required role names on permissions and ownerships > > > > > > any missings? > any be

Re: could not open file "global/pg_filenode.map": Operation not permitted

pens, the server is no longer accessible, and we need to > restart the service (pg_ctl restart). > Once restarted, Popstgres runs fine again for a couple of days. > Hi This issue seems to be related to the permission issue, please check your script if it's changing the permissions. Regards Kashif Zeeshan Bitnine Global > > We are running PostgreSQL 16.2 on macOS 14.3.1. > > Any idea what might be causing this issue, or how to resolve it? > > > Best regards, > > Nick Renders > > > > >

Re: Need help to make space on my database

Please run VACUUM with ANALYZE option that will also update the DB Stats. Regards Kashif Zeeshan Bitnine Global On Mon, Apr 29, 2024 at 7:19 PM Adrian Klaver wrote: > On 4/29/24 06:45, Cocam' server wrote: > > Hello. > > > > I need help to make space on my databa

Re: Table data migration from single server to Flexi server

Hi Please use pg_dump for taking the backup, you can find the details on the link below. https://www.postgresql.org/docs/current/app-pgdump.html Regards Kashif Zeeshan On Thu, May 2, 2024 at 8:24 AM Bagesh kamar singh wrote: > > Hi team, >> >> I need help. Recently we migra

Re: Prevent users from executing pg_dump against tables

Hi RAJAMOHAN There is not a direct way to restrict a table not to be allowed to be backed up by pg_dump. But you can use the RLS (ROW LEVEL SECURITY) policy to restrict access. Regards Kashif Zeeshan Bitnine Global On Thu, May 2, 2024 at 10:47 AM RAJAMOHAN wrote: > Hello all, > &g

Re: Listing only the user defined types (with owners)

p for a pseudo-type, or r for a range type. See also typrelid and typbasetype. Regards Kashif Zeeshan Bitnine Global On Thu, May 2, 2024 at 4:40 PM Durumdara wrote: > Hello! > > I have a script which can change the table owners to the database owner. > > I select the tables like th

Re: I have ansible for postgres-etcd-patroni

Hi Iman It's a great help, thanks for sharing. Regards Kashif Zeeshan On Sun, May 5, 2024 at 1:12 AM Iman Bakhtiari wrote: > Hi i have written this ansible with https://github/sudoix together > https://github.com/imanbakhtiari/postgres-ansible.git > This ansible needs 5 virtua

Re: Postgresql active-active nodes in cluster

Hi You can use BDR, you can have a look on the following link. https://wiki.postgresql.org/wiki/Multimaster Thanks Kashif Zeeshan Bitnine Global On Thu, May 9, 2024 at 3:28 PM Vidyashree H S wrote: > Hi, > > I'm using Postgresql 15.4 version on RISCV architecture > I'

Re: pg_stat_io clarifications: background worker, writes and reads

tatus . Regards Kashif Zeeshan Bitnine On Wed, May 15, 2024 at 1:26 AM Dimitrios Apostolou wrote: > Hello list, > > what is the "background worker" in the pg_stat_io statistics view? I'm > reading the documentation but can't figure this one out knowing that it is > not a

Re: pg_stat_io clarifications: background worker, writes and reads

max_parallel_workers = 6 The limit of concurrent parallel workers for the whole cluster is max_parallel_workers, which must be ≤ max_worker_processes. The limit of parallel workers per query is max_parallel_workers_per_gather. Thanks Kashif Zeeshan Bitnine Global On Wed, May 15, 2024 at 5:59 PM Dimitrios

Re: How to update upper-bound of tstzrange ?

Hi Try this one. UPDATE foo SET bar_times = bar_times + INTERVAL '1 hour' WHERE bar_id = 'abc'; Regards Kashif Zeeshan Bitnine Global On Mon, May 20, 2024 at 3:30 PM Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> wrote: > Could someone kindly help me out wit

Re: Pgpool with high availability

Hi Vijay Can you please share the error log, as from the description its hard to figure out the issue causing this problem. Regards Kashif Zeeshan Bitnine Global On Tue, May 28, 2024 at 9:42 PM vijay patil wrote: > > HI Team, > > "I'm encountering challenges while config

Re: Pgpool with high availability

Hi Vijay The log shows that all the nodes are able to communicate now (master, standby and standby1) and now what are the issue you are facing? Regards Kashif Zeeshan On Thu, May 30, 2024 at 2:00 AM vijay patil wrote: > Thanks Muhammad ! > > Here i uploaded details. > > Thanks

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Hi Sumit Please make sure Developer Toolset Repo is enable, the package is not getting installed as its not being found due to the missing Repo. Regards Kashif Zeeshan Bitnine Global On Wed, May 29, 2024 at 10:10 PM Sumit Kochar wrote: > Hi Muhammad, > > > > Tried to insta

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Please refer to the following links for help https://access.redhat.com/solutions/3500401 https://stackoverflow.com/questions/72778135/install-llvm-toolset-10-0-or-newer-in-centos7 Regards Kashif Zeeshan Bitnine Global On Thu, May 30, 2024 at 8:50 AM Kashif Zeeshan wrote: > Hi Su

Re: Can't Remote connection by IpV6

gards Kashif Zeeshan Bitnine Global On Thu, Jun 6, 2024 at 7:46 PM 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 a

Re: Questions on logical replication

that sounds like it > could slowly but surely fill up disk space. > Hi Yes that is a consideration with logical replication but the possible cast out weight the benefit. The kept WAL file size will only increase if the standby is offline. Regards Kashif Zeeshan Bitnine Global > >

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

t an invalid option. > (Technically, this is a bug; I first noticed it a week after copying a > script from a PG 15 server to five PG 14 servers, and running it quite a > few times without fail.) > If the support is removed then it should be mentioned in the official docume

Re: lost master password

Hi Do following Stop pg service Open pg_hba.conf Put trust for authentication e.g. "local all all trust" Start the service Log in using psql e.g psql -U postgres Change the password e.g ALTER USER postgres WITH PASSWORD 'new_password

Re: Vacuum backend with backend_xmin?

agree on the visibility of tuples. This is for example relevant for VACUUM: it cannot remove any dead tuples that contain a transaction ID that is not older than any backend's Regards Kashif Zeeshan Bitnine Global > > Thanks, > Torsten >

Re: TOAST Table / Dead Tuples / Free Pages

Kashif Zeeshan On Thu, Jun 13, 2024 at 12:55 PM Shenavai, Manuel wrote: > Hi everyone, > > > > I created a simple scenario to understand the handling of TOASTs > <https://www.postgresql.org/docs/current/storage-toast.html>: There is an > empty database with a single t

Re: Stack Smashing Detected When Executing initdb

Hi Xu To pinpoint the issue, please use gdb debugger to get the backtrace to exactly find out where the error is occurring and you can then do the required setups. For Reference : https://stackoverflow.com/questions/50093327/how-do-i-solve-postgresql-aborted-core-dumped-error Thanks Kashif

Re: Stack Smashing Detected When Executing initdb

Hi Xu You need to enable some settings for the code dump to generated. For the settings you can use following link. https://access.redhat.com/solutions/4896 Regards Kashif Zeeshan On Sun, Jun 23, 2024 at 7:07 PM Xu Haorong wrote: > Hi Zeeshan, > > Thank you for helping me. I tried t

Re: Stack Smashing Detected When Executing initdb

Thats great, it also gave us a learning opportunity as well. On Mon, Jun 24, 2024 at 10:18 AM Xu Haorong wrote: > Hi Lane, > > Thank you for your advice. The problem did disappear after running git > clean, and I'm sorry for not providing enough context at first. > > Regards, > Haorong Xu >

Re: Issue with pgstattuple on Sequences in PostgreSQL

Hi I dont think Sequences are support, please refer to the following documentation. https://www.postgresql.org/docs/current/pgstattuple.html Regards Kashif Zeeshan On Mon, Jun 24, 2024 at 4:09 PM Ayush Vatsa wrote: > Hi PostgreSQL Community, > > I was recently exploring the pgstatt

Re: PostgreSQL Community Enquire !

rces or mailing lists that would be beneficial for > someone looking to learn and troubleshoot PostgreSQL? > There are a lot of mail lists available, you need to subscribe to the desired ones, the mostly used ones are 1. pgsql-general 2. pgsql-hackers 3. pgsql-admin You can go to the following l

Re: Dropping connections

Hi Tarras Please refer to the following guide where connection was working fine with PG and EPAS. https://www.enterprisedb.com/docs/partner_docs/EsriArcGISProandEsriArcGISEnterprise/04-ConfiguringEsriArcGISProandEsriArcGISEnterprise/ Regards Kashif Zeeshan On Wed, Jun 26, 2024 at 10:45 PM

Re: --frokbackend process

Hi It's hard to figure out the issue by just looking on the process list, to figure out the issue you need to share the DB Server Logs and thats the why to figure out the exac issue. Regards Kashif Zeeshan On Wed, Jun 26, 2024 at 10:06 PM satyajit patra < satyajit.pa...@sunknowledge.co

Re: Load a csv or a avro?

Hi There are different data formats available, following are few points for there performance implications 1. CSV : It's easy to use and widely supported but it can be slower due to parsing overload. 2. Binary : Its faster to load but not human understandable. Hope this helps. Regards K

Re: Postgres :- Could not open R2DBC Connection

Hi Can you check the following. 1. The machine 10.0.202.121 is accessible. 2. Check the firewall settings. 3. Check the pg_hha.conf Settings. Regards Kashif Zeeshan On Wed, Jul 10, 2024 at 12:48 PM vimal va wrote: > Dear team , > > This is Vimal from WIpro. We are using Postgres 1

Re: Semantic cache capability for Postgresql db

Hi Pradeep pgprewarm Extension is available for Postgres https://www.postgresql.org/docs/current/pgprewarm.html On Tue, Jul 16, 2024 at 7:05 PM pradeep t wrote: > Hi, > > Shall I use the Postgresql database for a* semantic cache *like the Redis > semantic cache? > Are we currently supporting

Re: PgbackRest and EDB Query

Hi On Wed, Jul 17, 2024 at 5:21 PM KK CHN wrote: > Hi , > > I am trying pgbackrest(2.52.1) with postgresql( version 16) on a lab > setup on RHEL-9. Both PostgreSQL server and a remote Repository host > configured with pgbackrest and everything working fine as specified in the > documentation

Re: Planet Postgres and the curse of AI

while suggesting solutions for real world problems. Regards Kashif Zeeshan On Wed, Jul 17, 2024 at 10:22 PM Greg Sabino Mullane wrote: > I've been noticing a growing trend of blog posts written mostly, if not > entirely, with AI (aka LLMs, ChatGPT, etc.). I'm not sure where to raise

Re: Regarding vacuum freeze locking mechanism

Hi On Thu, Jul 18, 2024 at 10:26 AM Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > Hi > > Do new inserts block while performing vacuum freeze operations ? > Generally, VACUUM FREEZE does not block inserts as PG uses Multi-Version Concurrency Control (MVCC) which allows multiple transacti

Re: Re. Select with where condition times out

Hi It can be caused due to Table Bloat, table bloat can slow down queries. Use the pg_repack extension or VACUUM FULL to try ti fix this table bloat issue. You can refer to following link https://supabase.com/blog/postgres-bloat Regards Kashif Zeeshan On Thu, Jul 18, 2024 at 2:38 PM sivapostg

Re: PgbackRest and EDB Query

make sure that the passwordless connection is made between both from EDB Server to Repo Server and from Repo Server to EDB Server. For this you need to generate the ssh keys on both EDB server abd Repo Servers and copy the id_rsa.pub from EDB Server to Repo Server and vise versa. I hope this helps.

Re: PgbackRest and EDB Query

gt; Query > How can I make the Reposerver to host more than one EPAS-16 server > instance's running on multiple nodes ? > Yes, You have to add different stanzas for different servers. Regards Kashif Zeeshan > > Having only one /etg/pgbakrest/pgbackrest.conf file on the Repo

Re: pgBackRest for multiple production servers

repo1, repo2 > and repon N declarations ? > > Please correct me if I am wrong .. > Yes , normally there is one repo server which contains the configuration of all DB Servers in form of stanzas. Regards Kashif Zeeshan > > Thank you > Krishane > > > Please fi

Re: PgBackRest PTR recovery: After table drop to get dropped state

Hi On Thu, Aug 1, 2024 at 2:54 PM KK CHN wrote: > List, > > *Not working (start EPAS server always fails):* > > 1. Testing PTR using PgBackRest(2.52.1) on RHEL9 EPAS-16, and RHEL9 ( > Repo Server) > > When I do a PTR > > 1. After doing a table drop and then > 2. Noting down the time

Re: PgBackRest PTR recovery: After table drop to get dropped state

u take a backup (full/incremental) 2. Make changes in the data 3. Note down all the timestamps per the transactions as you need them 4. Now if you want to restore,what you will do is to give the required timestamp with the required backup This will restore the backup and then replay the WAL files

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

Hi On Tue, Aug 13, 2024 at 2:47 PM 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? > > D

Re: where is postres installed?

Hi Arbol Use this command and it will show all the files installed by the package. dpkg-query -L postgresql-16 Regards Kashif Zeeshan On Fri, Aug 23, 2024 at 9:50 AM Muhammad Ikram wrote: > Hi Arbol, > > Hope above response from Usman must have resolved your issue. You may also

Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy)

ng apt-get update then execute the following command and it shd install the latest version of PG in this case PG17. sudo apt -y install postgresql Regards Kashif Zeeshan On Mon, Aug 26, 2024 at 11:52 AM Jyoti Saxena wrote: > Hi, > > I’m encountering an issue while trying to install Po

Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy)

sistance. > > Best regards, > Jyoti > > On Mon, Aug 26, 2024 at 12:35 PM Kashif Zeeshan > wrote: > >> Hi Jyoti >> >> Make sure you have done the following repo setup >> >> sudo apt install curl ca-certificates >> sudo install -d

Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy)

To compile PG from code follow the below instructions. https://www.postgresql.org/docs/current/install-make.html Thanks Kashif Zeeshan On Mon, Aug 26, 2024 at 3:30 PM Kashif Zeeshan wrote: > > > On Mon, Aug 26, 2024 at 3:19 PM Jyoti Saxena > wrote: > >> Hi Kashif, &g

Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy)

a 3 is released, maybe someone else can guide on how to install it. Regards Kashif Zeeshan > Also, could you please provide information on where I can find the binary > installation packages for PostgreSQL 17 for Windows? This would be > extremely helpful for setting up PostgreSQL on m

Re: After DB upgrade from PG13 to PG15 showing error

84 IST [702937] HINT: Close open transactions soon > to avoid wraparound problems.* > > *You might also need to commit or roll back old prepared > transactions, or drop stale replication slots.* > These are warnings not error, can you please share the error you are getting. Thanks Kashif Zeeshan > > > *DB OS -RHEL8.* > > > > > > Regards, > > Ram Pratap. >

Re: Wal file query

-sequuence-numbers Thanks Kashif Zeeshan On Tue, Apr 8, 2025 at 4:44 PM Atul Kumar wrote: > In streaming replication What is the way to check which "WAL file" is > currently in use in primary and in standby ? > > > Regards. >

Re: EDB Download for PostgreSQL 17.5 is broken

Hi Ertan Correct Version 17.5.0 is being downloaded and it may be a cache issue. Regards Kashif Zeeshan EDB On Thu, May 8, 2025 at 9:29 PM Ertan Küçükoglu wrote: > Hello, > > I am just writing here with the hope that there are some EDB contacts here. > > The 17.5 version