PostgreSQL

05 Nov 2024 21:19

please suggest

/usr/bin/ld: cannot find -lnsl
collect2: error: ld returned 1 exit status
make: *** [Makefile:527: blib/arch/auto/DBD/Oracle/Oracle.so] Error 1

PostgreSQL

05 Nov 2024 09:21

Can you please put yourself into the position of another reader of your messages, and try to understand if anyone can follow your actions and see what you are doing and where you are failing. You do not provide enough information for anyone to follow you or see what you are doing.

PostgreSQL

05 Nov 2024 09:19

I'm not interested in any private messages which ask me for support. Post this here.

PostgreSQL

05 Nov 2024 09:16

Ok Andreas , unable to run create extension db_link; in postgres DB .getting error like oracle_fdw.dll file doesn't exit for specified path .tried to extract from oracle_fdw.sln file but unable to do it if any one having oracle_fdw.dll file for postgresql version 16 please provide it

PostgreSQL

05 Nov 2024 08:01

Please help me on oracle_fdw.dll file this

PostgreSQL

04 Nov 2024 18:12

Hiring

Position: SQL Developer

Company: PhonePe

Location: Bangalore, Hyderabad, Pune

Qualification: Bachelor's or Master's degree from the relative fields.

Experience: Fresher to 3 Years

Apply
https://shorturl.at/RhLi7

PostgreSQL

04 Nov 2024 16:06

can I know any link to follow steps plz

PostgreSQL

04 Nov 2024 16:03

Ora2pg depends on Perl dbi driver for oracle that it requires instant client basic or lite

PostgreSQL

04 Nov 2024 15:53

I am trying to migrate oracle database to postgreSQL

PostgreSQL

04 Nov 2024 15:51

can someone suggest on this

PostgreSQL

04 Nov 2024 13:01

Yes sqllite,duckdb or "pglite" looks way more suitable for in-program database use case. They might be doing a lot of over-engineering.

PostgreSQL

04 Nov 2024 12:22

Well, after reading... It looks like the postgres is just the worse choice for them among relational databases.

Yes, it tends to fall completely in any trouble. Any bit flip, some fsync misues, and so on. It is good sometime (often).

It is awful when there is some random user's desktop without any administration.

So, generally, sqlite, interbase, mysql, ms sql server express — would be better for such "internal" or "in-program" database cases.

PostgreSQL

04 Nov 2024 11:50

Yelp switched from PostgreSQL to MySQL.

While I understand the rationale why they did that, it's surprising to see how many workarounds they had to implement in order to catch up with features which are native in PG.

https://engineeringblog.yelp.com/amp/2024/10/migrating-from-postgres-to-mysql.html

PostgreSQL

03 Nov 2024 10:42

type of database #generally

PostgreSQL

03 Nov 2024 07:19

Evarikaina postgreSQL dba,MySQL, mongodb inkemaina dba curs kavalantey vds aval. Nake vidiga msg cheyandi

PostgreSQL

05 Nov 2024 09:37

Windows user probably. Not many use windows except for pc games. Better ask on it's github, there are similar questions answered already.

https://github.com/laurenz/oracle_fdw

PostgreSQL

05 Nov 2024 09:20

You do not specify "how" you tried to extract that file, and how this is failing.

PostgreSQL

05 Nov 2024 09:18

I pinged screen shot to you -FYI

PostgreSQL

05 Nov 2024 08:56

How exactly do you expect anyone to help you when you do not provide more information.

PostgreSQL

04 Nov 2024 19:16

Unable to download oracle_fdw.dll file can you please help me

PostgreSQL

04 Nov 2024 18:06

PostgreSQL Person of the Week interview with: Rushabh Lathia

https://postgresql.life/post/rushabh_lathia/

PostgreSQL

04 Nov 2024 16:04

Your installation of that Perl module is raising an error. I think you should install ora2pg using operating system packages

PostgreSQL

04 Nov 2024 15:59

Why don't you use ora2pg operating system packages?

PostgreSQL

04 Nov 2024 15:53

/u1/app/oracle/product/19.0.0/client_1/sdk/include/oci.h:745:10: fatal error: ociver.h: No such file or directory
#include <ociver.h>
^~~~~~~~~~
compilation terminated.
make: *** [Makefile:383: Oracle.o] Error 1
ZARQUON/DBD-Oracle-1.90.tar.gz
/usr/bin/make -- NOT OK

PostgreSQL

04 Nov 2024 15:51

[root@lsp-oratl01 ora2pg]# export ORACLE_HOME=/u1/app/oracle/product/19.0.0/client_1
[root@lsp-oratl01 ora2pg]# export LD_LIBRARY_PATH=/u1/app/oracle/product/19.0.0/client_1/lib
[root@lsp-oratl01 ora2pg]# ora2pg -t SHOW_VERSION -c ora2pg.conf
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (you may need to install the DBD::Oracle module) (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (eval 14) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Mem, Pg, Proxy, SQLite, Sponge.
at /usr/local/share/perl5/Ora2Pg/Oracle.pm line 144.

PostgreSQL

04 Nov 2024 12:39

Hello I have situation where i have 2 databases in the cluster and one database is with collation ‘en_US.UTF-8’
And another one in ‘c’ collation with same data. INSERT query running fine with database having collation ‘en_US.UTF-8’ but giving OMM error when it executes on the database which is having ‘c’ collation

PostgreSQL

04 Nov 2024 12:08

Thanks god, it's not Uber!

PostgreSQL

03 Nov 2024 13:51

https://chat.whatsapp.com/ErXwfkvL3CMFUn4lygMkEm

Please connect , explore learn more about postgresql DBA

PostgreSQL

03 Nov 2024 10:40

database design:
#key value# newline is new node
#title freebsd# #supportswineandunrealengine
it is called #mangal
#key_nesteddicts

PostgreSQL

03 Nov 2024 04:28

Hello anyone working at Mumbai location ?