2806
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
Unable to download oracle_fdw.dll file can you please help me
Читать полностью…
PostgreSQL Person of the Week interview with: Rushabh Lathia
https://postgresql.life/post/rushabh_lathia/
Your installation of that Perl module is raising an error. I think you should install ora2pg using operating system packages
Читать полностью…
/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
[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.
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
https://chat.whatsapp.com/ErXwfkvL3CMFUn4lygMkEm
Please connect , explore learn more about postgresql DBA
database design:
#key value# newline is new node
#title freebsd# #supportswineandunrealengine
it is called #mangal
#key_nesteddicts
Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.
- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong
⬇️ Press the button down here ⬇️
Staff member. It needs to be worked on a b2b due to the company not having registered offices outside of Malta.
If based in Malta, it would be a regular employment contract
In need of an expert to advise on all things postgre related and lead the company in this area
Читать полностью…
It's fully remote from anywhere of your choice, work hours are CET.
I would rather disclose the company name in private chat if that's okay.
The industry is iGaming
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
Ora2pg depends on Perl dbi driver for oracle that it requires instant client basic or lite
Читать полностью…
Yes sqllite,duckdb or "pglite" looks way more suitable for in-program database use case. They might be doing a lot of over-engineering.
Читать полностью…
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.
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
Evarikaina postgreSQL dba,MySQL, mongodb inkemaina dba curs kavalantey vds aval. Nake vidiga msg cheyandi
Читать полностью…
Evarikaina postgreSQL dba inkemaina dba curs kavalantey vds aval. Nake vidiga msg cheyandi
Читать полностью…
Are you looking for a staff member or outside consultant?
Читать полностью…
14 to 16 🤔 I would plan straight away to 17. Lots of new things available in 17, native incremental backup and logical replication improvements gives big boost.
Читать полностью…