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
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 appreciate any input on how to uninstall > it. Thanks everyone for your time. > > > Why do you have to uninstall it, when "just don't use it" accomplishes the > task. > > (This ignores the question "why did you install ora2pg on a *Postgresql* > server? That's backwards.) > > -- > Born in Arizona, moved to Babylonia. >
pg_dump Running Slow
Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do I check on the progression of the process? Sincerely your 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 forward to reading your thoughts. Best regards Yong Serkfem
Manual Failover
Hello Engineers, I am facing an issue with the manual failover of the standby to the master role. I was able to promote the standby and got it out of recovery mode. How do I direct applications to point to the standby which has assumed the role of the current master, and what should I do after 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
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]
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=/usr/pgsql-12/bin \ > --new-bindir=/usr/pgsql-15/bin \ > --old-options '-c config_file=/data/postgres12/postgresql.conf' \ > --new-options '-c config_file=/data/postgres/postgresql.conf' \ > --old-port=5433 \ > --new-port=5432 Performing Consistency Checks on Old Live Server Checking cluster versions ok Checking database user is the install user ok Checking database connection settings ok Checking for prepared transactions ok Checking for system-defined composite types in user tables ok Checking for reg* data types in user tables ok Checking for contrib/isn with bigint-passing mismatch ok Checking for user-defined encoding conversions ok Checking for user-defined postfix operators ok Checking for incompatible polymorphic functions ok Checking for presence of required libraries fatal Your installation references loadable libraries that are missing from the new installation. You can add these libraries to the new installation, or remove the functions using them from the old installation. A list of problem libraries is in the file: /data/postgres/pg_upgrade_output.d/20240708T141557.291/loadable_libraries.txt Failure, exiting [postgres@AWPPLCOLEDBXL01 postgres_upgrade_work_area]$ ll total 0 [postgres@AWPPLCOLEDBXL01 postgres_upgrade_work_area]$ cat /data/postgres/pg_upgrade_output.d/20240708T141557.291/loadable_libraries.txt could not load library "$libdir/cstore_fdw": ERROR: could not access file "$libdir/cstore_fdw": No such file or directory In database: postgres In database: logicole could not load library "$libdir/oracle_fdw": ERROR: could not access file "$libdir/oracle_fdw": No such file or directory In database: postgres In database: logicole Does anyone know where I can download rpm cstore_fdw and oracle_fdw. I have searched and can't find the rpm for v15.7. I will greatly appreciate any help.
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 postgresql versions. Specifically V12.7 and 15.7
>>
>
> Create a bash function that exports PGDATA to the relevant directory,
> based on the parameter you pass.
> Add as much error checking (to ensure that the parameter you passed
> actually points to a real data dir and that the postmaster is running. How
> you do that depends on whether it's Debian-based, RH-based or something
> else.
>
> We, for example, have standardized on data directories in the format:
> /Database//data
>
> Thus, something as simple as this would work for us:
> pgswitch() { export PGDATA=/Database/${1}/data ; }
>
> --
> Death to , and butter sauce.
> Don't boil me, I'm still alive.
> lobster!
>
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.
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 instantclient 19_24 I would appreciate any help getting this resolved. Regards Yong Serk
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 the error I am getting, > > "error connecting to Oracle: OCIEnvCreate failed to create environment > handle: Detail: SQL state: HV00N > > I have installed oracle instantclient 19_24 > > I would appreciate any help getting this resolved. > > This error usually indicated that you configured the Oracle Client wrongly. > Usually, that is a question of setting environment variables wrong, but > unfortunately it is a very generic error that Oracle throws when "something > is wrong". > > Your best bet is to research all the oracle_fdw issues that reported this > error. Hopefully, one of these cases matches yours: > https://github.com/laurenz/oracle_fdw/issues?q=is%3Aissue%20OCIEnvCreate > > Yours, > Laurenz Albe >
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
