Prune or Purge data stored on Postgres 14.13

Hi, I am running PostgreSQL 14.13 on RHEL 8.10 OS. Is there a way to Prune or Purge data stored on PostgreSQL 14.13 ? For example I have Analytics data stored in PostgreSQL 14.13 server for last 1 year (1st September 2023 till date) Is there a way to prune analytics data from Analytics Data stor

Re: Migrating MySQL DB to PostgreSQL DB.

On Mon, Jul 31, 2023 at 4:15 AM Ron wrote: > On 7/30/23 09:01, Kaushal Shriyan wrote: > > Hi, > > > > I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 > > (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL > > 14 databa

Re: Migrating MySQL DB to PostgreSQL DB.

Thanks Ken and Adrian for the quick email response. Really appreciate it. Thanks once again👍 Best Regards, Kaushal On Sun, Jul 30, 2023 at 8:23 PM Adrian Klaver wrote: > On 7/30/23 07:11, Ken Marshall wrote: > > On Sun, Jul 30, 2023 at 07:31:02PM +0530, Kaushal Shriyan wrote

Migrating MySQL DB to PostgreSQL DB.

Hi, I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14 database server? Please suggest. Thanks in advance. Best Regards, Kaushal

Re: Grant all privileges to user on a database

On Mon, Jul 24, 2023 at 6:51 PM Ron wrote: > > On 7/24/23 08:15, Kaushal Shriyan wrote: > > Hi, > > > > I am running postgresql15-server 15.3 on Red Hat Enterprise Linux > > release 8.7 (Ootpa) > > > > # rpm -qa | grep -i post > > postgresql15-serv

Grant all privileges to user on a database

Hi, I am running postgresql15-server 15.3 on Red Hat Enterprise Linux release 8.7 (Ootpa) # rpm -qa | grep -i post postgresql15-server-15.3-2PGDG.rhel8.x86_64 postgresql15-libs-15.3-2PGDG.rhel8.x86_64 postgresql15-15.3-2PGDG.rhel8.x86_64 # $psql psql (15.3) Type "help" for help. postgres=# GRAN

Re: Replication between Master PostgreSQL database version 9.6.1 and Standby/Slave PostgreSQL database version 10.17.

Pettus wrote: > > > > On Oct 5, 2022, at 09:32, Kaushal Shriyan > wrote: > > > > Hi, > > > > Is replication possible between PostgreSQL support Master database > running 9.6.1 version which is a lower version to Standby/Slave running > version 10.17? &

Replication between Master PostgreSQL database version 9.6.1 and Standby/Slave PostgreSQL database version 10.17.

Hi, Is replication possible between PostgreSQL support Master database running 9.6.1 version which is a lower version to Standby/Slave running version 10.17? I have a datacenter *DC1* which is a production environment and serves live customer traffic hosting Master PostgreSQL database version *9.

Error : /usr/local/share/lua/5.1/pgmoon/init.lua:211: don’t know how to auth: 10

Hi, I am running CentOS Stream release 8 with kong-2.6.0-1.x86_64 with the below PostgreSQL database versions. postgresql14-libs-14.1-1PGDG.rhel8.x86_64 postgresql14-14.1-1PGDG.rhel8.x86_64 postgresql14-server-14.1-1PGDG.rhel8.x86_64. #kong migrations bootstrap -c /etc/kong/kong.conf --vv > 202

Recommended Hardware requirements for PostgreSQL DB Server.

Hi, Are there any recommended hardware requirements to setup PostgreSQL DB server? I checked https://wiki.postgresql.org/wiki/Database_Hardware but unable to find it. I am going to install Postgresql 9.6 version in AWS ( https://aws.amazon.com/ec2/instance-types/). I will appreciate if someone ca