PostgreSQL

07 Apr 2025 14:05

I have migrated the database from mysql to Postgres and now i am facing deadlock errors with procedures which are working in mysql ? Any idea on this

PostgreSQL

07 Apr 2025 10:22

I hope, can I learn this area

PostgreSQL

07 Apr 2025 10:07

https://roadmap.sh/postgresql-dba

PostgreSQL

07 Apr 2025 10:02

Read a docs about thing what you want to learn. I'm not experienced very well and still learn unknown things but reading the docs solving any problem.

Why did you decide to switch Postgres?

PostgreSQL

07 Apr 2025 08:40

Well... Good luck. 🧐

PostgreSQL

05 Apr 2025 17:42

https://merginmaps.com/docs/dev/dbsync/ aquí habla de un plug-in para sincronizar los datos con bases de datos postgresql con postgis

PostgreSQL

04 Apr 2025 14:13

If we go for dedicated storage for each node which type of storage is best ( having streaming replication from node 1 to node 2 & 3).

PostgreSQL

04 Apr 2025 10:20

Thanks, is it possible to have one primary (read write)and 2 secondary (read only) with shared storage?

PostgreSQL

04 Apr 2025 08:39

Hi Team, Is it possible to have the same setup as the Oracle 3 node RAC in postgresql, the reason is we need to have shared storage for all the 3 nodes.

PostgreSQL

03 Apr 2025 22:48

I think that it's a perfectly useful feature. There are just some pretty heavy architecture changes that would be required to make it work (like the ability for one session to have system catalogs from multiple databases open at the same time).

PostgreSQL

03 Apr 2025 22:47

What about case when there are multiple databases in each service? How about disambiguation?

PostgreSQL

03 Apr 2025 22:43

I used to be an Ms SQL Server database developer for a long time. And It's just fine to have an access to all the databases on a sever for me. It's just illegal not to have such possibility)

PostgreSQL

03 Apr 2025 22:39

As example (bad, but this is reality) I have server with several databases each for it's microservice. And now I need to perform analysis

PostgreSQL

03 Apr 2025 22:37

Schemas work in one db. And I need two(or even more) different databases

PostgreSQL

03 Apr 2025 22:35

It's not likely to be in the core PostgreSQL code anytime soon. There are a few complications about doing so in PostgreSQL, including the connection model (a connection is bound to a single database, and making other databases visible to a connection would be a substantial undertaking).

PostgreSQL

07 Apr 2025 10:22

Good luck with that.

PostgreSQL

07 Apr 2025 10:16

It is a great choice for that. I like this DBMS for simplicity and extensibility.

That thing is quitely simple than MySQL/MariaDB.

I don't know how to solve error with PHP mysql integration; MySQL works very well with even phpMyAdmin in Docker container but in PHP throws up "connection refused" in PDO. But postgres php works perfectly.

PostgreSQL

07 Apr 2025 10:05

Thanks for answer.
I want to focus on my personal ideas and plans. I need PostgreSQL for those plans.

PostgreSQL

07 Apr 2025 09:42

Good morning everyone. I have a question. Please answer based on your experience. I am 27 years old and decided a week ago to learn PostgreSQL. My reason is that I want to work in the field of databases, with clients, and do analytics. What are your recommendations, and what materials should I learn first? I have already installed the necessary tools, everything is available. Thank you for your answer and recommendations.

PostgreSQL

07 Apr 2025 00:39

I am new to PostgreSQL and I want to become an Expert at it

PostgreSQL

05 Apr 2025 17:37

Hi everyone! Does anyone know if MarginMaps can be integrated with PostgreSQL? I’m looking for information on possible integration methods and any available documentation. Thanks!

PostgreSQL

04 Apr 2025 10:24

Shared storage model are not popular within Postgres setup. Consult the first block https://www.postgresql.org/docs/current/different-replication-solutions.html and Wiki page https://wiki.postgresql.org/wiki/Shared_Storage for some details

PostgreSQL

04 Apr 2025 09:43

Not possible.
PG not have same as RAC technology.

PostgreSQL

03 Apr 2025 23:00

Ok, @unfoxo , @xof999 thanx for your answers!

PostgreSQL

03 Apr 2025 22:47

You do have the possibility with a fdw. Postgresql fdw also supports indexes and other stuff that speed up the queries dramatically

PostgreSQL

03 Apr 2025 22:44

And what about case when there are several schemas in each service? How about disambiguation?

PostgreSQL

03 Apr 2025 22:40

... I have the same thing and each "microservice" has a schema

PostgreSQL

03 Apr 2025 22:39

There's a tension there. People want multiple DBs because they want them to be isolated, but cross-DB queries reduce the isolation level.

PostgreSQL

03 Apr 2025 22:36

If you want a similar behaviour, you can use schemas

PostgreSQL

03 Apr 2025 22:35

I would like doing it "native", like in MS SQL Server