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 > this

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 >

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

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: 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 Kashif

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.com>

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: 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: 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: 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: 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

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: 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: 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: 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'; Rega

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

id 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 documentation.

Re: Questions on logical replication

s 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 > > > But agai

Re: Can't Remote connection by IpV6

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 all ::

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: 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: 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. > >

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 configuring

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 with the correct syntax

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: pg_stat_io clarifications: background worker, writes and reads

. 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 autovacuum or bg

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'm trying

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: Listing only the user defined types (with owners)

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 this: > > FOR r IN SELECT tablename FROM pg_tables WHERE

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: 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: 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 da

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

happens, 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: 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

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