Re: Oracle_fdw

Thanks, I'll look into it. On Tue, Apr 22, 2025, 7:54 AM Laurenz Albe wrote: > On Tue, 2025-04-22 at 07:28 -0400, Yongye Serkfem wrote: > > We are using Postgresql-15, ahd having issues importing foreign schema > with all > > its objects from an Oracle databse. Here is

Oracle_fdw

Hello Team! We are using Postgresql-15, ahd having issues importing foreign schema with all its objects from an Oracle databse. Here is the error I am getting, "error connecting to Oracle: OCIEnvCreate failed to create environment handle: Detail: SQL state: HV00N I have installed oracle instantclie

Deleting idle connections

Hi Everyone! I am having a series of idle connections and unable to delete them with a single command. Any help in realizing this would be greatly appreciated. Regards Yong

Re: Bash profile

I am upgrading from version 12.7 to 15.7 On Sat, Feb 15, 2025, 2:15 PM Ron Johnson wrote: > On Sat, Feb 15, 2025 at 2:01 PM Yongye Serkfem wrote: > >> Hi Everyone! >> I would appreciate any assistance with configuring the bash profile to >> run two different postgresq

Bash profile

Hi Everyone! I would appreciate any assistance with configuring the bash profile to run two different postgresql versions. Specifically V12.7 and 15.7 My regards to all Yongye Serkfem.

Upgrading from v12.7 to v15.7

Hello Engineers, After upgrading from v12.7 to v15.7, I ran the following command and got this error message. postgres_upgrade_work_area]$ /usr/pgsql-15/bin/pg_upgrade \ > --check \ --old-datadir=/data/postgres12 \ > --old-datadir=/data/postgres12 \ > --new-datadir=/data/postgres \ > --old-bindir=

Replication After manual Failover

Hello Engineer, Below is the error message I am getting after failing over to the standby and reconfiguring the former master as the new standby. Any help will be appreciated. [image: image.png]

Manual Failover

completing maintenance on the previous master to assume its original role as master? I would appreciate any input, and thank you for your time. Yongye Serkfem

PITR

Hi, I hope you are all doing well. I am trying to do PITR on Postgresql v12. Now that the recovery.conf file is not available in this version, where should I set the recovery_target_time? I checked the Postgresql.conf file and can't find the appropriate parameter to set the target time. I'm looking

pg_dump Running Slow

he process? Sincerely your Yongye Serkfem

Re: Uninstalling Ora2pg

Thanks, I appreciate the input Regards Yong On Thu, Oct 26, 2023, 11:39 AM Ron wrote: > On 10/26/23 07:42, Yongye Serkfem wrote: > > Hello PostgreSQL Community, > I am having difficulties uninstalling ora2pg which I manually installed on > our Postgresql servers. I would appre

Uninstalling Ora2pg

Hello PostgreSQL Community, I am having difficulties uninstalling ora2pg which I manually installed on our Postgresql servers. I would appreciate any input on how to uninstall it. Thanks everyone for your time. Very Respectfully Yong