PostgreSQL

17 July 2025 17:43

If there is any Postgres DBA working in Hyderabad, please let me know I need help.

PostgreSQL

16 July 2025 12:44

That's the understatement of the year ;-)

PostgreSQL

16 July 2025 12:30

Pgbasebackup working but I want to take a db backup using pgdump any idea or command?

PostgreSQL

16 July 2025 12:20

Logical replication has issues with LoBs

PostgreSQL

16 July 2025 12:18

Any other option to take dump full db

PostgreSQL

16 July 2025 12:16

Are you saving to /tmp/?

PostgreSQL

16 July 2025 12:07

Any specific error ?

PostgreSQL

16 July 2025 12:03

Hope you're not taking the LOBs backup in text format.
You may use this to take it in custom archive

pg_dump -Fc -f mydatabase.dump mydatabase

Same while doing pg_restore.

PostgreSQL

14 July 2025 00:16

Yep! Glad to be able to help.

PostgreSQL

13 July 2025 23:52

Of course it depends on your needs. If just doing stuff in the browser related to the specific type then you might have it easier storing the details as JSON and just processing them in the browser. But if you want to do any work on them in the database that is probably not ideal, even in PostgreSQL which supports indexing over jsonb etc.

PostgreSQL

13 July 2025 23:41

Never too late to stop using mssql.

PostgreSQL

13 July 2025 23:28

Ah, that might have been good to specify first as this is a PostgreSQL channel. 😼

You can essentially do the above in SQL server by making the primary key of a subclass specialisation table with the details specific to a type of payment be a foreign key linked to the primary key of a base class table.

Whether that is the right solution for your particular case is another matter. But it is nice in that IDs are unique and if the specific details of the type of table are not required only the base table needs to be consulted. You also don't have a bunch of null values for irrelevant columns as you might if trying to stuff all types into one table.

PostgreSQL

13 July 2025 23:16

PostgreSQL does offer the option for inheritance, perhaps this is useful for you? The order and subscription could be specialisations of Payable, perhaps subscriptions have periods and start dates while orders have order dates for example. https://www.postgresql.org/docs/current/tutorial-inheritance.html

PostgreSQL

13 July 2025 23:00

What is your preferred way when dealing with polymorphism? intersection tables? multiple FKs? ...?

I can't really evalute the trade-offs. they seem kinda equal, so I'm asking for your experience.

PostgreSQL

13 July 2025 09:10

How can i listen for changes in a table with nodejs api? And the notify the user? Websockets?

PostgreSQL

17 July 2025 12:17

ParadeDB - An Elasticsearch Alternative built on PostgreSQL

Author: Editorial Team

https://www.blackslate.io/articles/paradedb-an-elasticsearch-alternative-built-on-postgresql

PostgreSQL

16 July 2025 12:31

This or try on high Ram machine

PostgreSQL

16 July 2025 12:25

Cluster level all DB dump can be done using pg_basebackup for worry less transfer of LOBs, if you can afford downtime & do all necessary steps.

PostgreSQL

16 July 2025 12:19

Is that on-prem server or managed service..I guess on prem

PostgreSQL

16 July 2025 12:17

Looks like some of your LOBs are really large size, chewing up memory.. you can try to identify the Big sized LOB (if, a few) & export them separately using lo_export maybe.

PostgreSQL

16 July 2025 12:09

Do you add domain restriction in the database or in the API?

PostgreSQL

16 July 2025 12:04

Custom format only no luck tried directory format and plain also but result same

PostgreSQL

16 July 2025 11:55

Hi Team good evening am trying to database dump in 12 version pgdump but the db having lot of lob data types so while running pgdump its getting killed I have tried schema , data, and lob separate dump but still same and not able to achieve the backup any idea how to fix this … thanks in advance

PostgreSQL

14 July 2025 00:15

wow wow 🔥
The first link is what I was looking for! I was experimenting with the same design, but I had problems with limiting sub-classes to be of only one type, and it has a solution.

PostgreSQL

13 July 2025 23:44

Perhaps https://www.sqlteam.com/articles/implementing-table-inheritance-in-sql-server helps, or class table inheritance in this answer has a clear example. https://stackoverflow.com/a/3579462/2283898

PostgreSQL

13 July 2025 23:40

Can you please give an example schema? I can't imagine it 😅

PostgreSQL

13 July 2025 23:17

I'm using sql server 👀

PostgreSQL

13 July 2025 23:04

What I try to solve is handling different payment "reason"s (probably not the correct term). I have a payments table including info about amount, date, and stuff like that. But the payment can be for an order, a subscription, ...

PostgreSQL

13 July 2025 09:11

You can use a trigger that raises a NOTIFY event

PostgreSQL

12 July 2025 09:53

Yes, there are a lots of third party tool that could help you with security. If you are looking for a document with a checklist of security hardening, you should look up cis guide of postgresql