PostgreSQL

13 May 2026 00:03

Can someone help me, I create my layers on Qgis and I opened Postgresql inside QGIS with localhost, username and password. I create my server named "webgis" and table inside QGIS, but when I open pgadmin, I found same name but the table don't contain any information? How can I fix that?

PostgreSQL

10 May 2026 11:23

number of connections,
life time of connections,
number of applications, and how many they can get scaled up. for instance if you have two applications running, each has a pool at application level with 10 max connection, it sums up to 20 connections at postgres level. but if you scale in your peak times to 5 each, it will scale up to 100 connections. 100 connections might be too much might be nothing depends on your hardware spec and resources.
you should consider some postgres side configuration too when calculating these stuff like work_mem. there are also os level stuff which can affect your performance (still depends on your hardware). each pg connection becomes a process at os level and you have to know how it affects your system like context switches.

there are still other specific usecases which can be managed with connection pooling.

PostgreSQL

09 May 2026 19:23

I think you should look at your RPO instead of trying to not lose anything. For instance if changes are related to something that is not acceptable to lose, like financial data or audits, you should use sync replication or set the correct value for the session which is changing the data you care about. Ofc it has its downside too which can cause downtime, especially, when you have two nodes in your cluster. Sync replication requires that at least one secondary acknowledge that it has the change in its WAL before your primary gives back response to the client and writes will be blocked even if your primary is healthy. These disruption and downtimes can be decreased if you use a failover solution like patroni.

PostgreSQL

09 May 2026 18:13

It will surely be much faster than pg_basebackup

PostgreSQL

09 May 2026 17:41

Thanks team for your instant reply

PostgreSQL

09 May 2026 16:07

Short: no.

And it's better to use app-level differentials to try to restore missing data.

Long: well, you could try to extract all the new data from tools like pg_waldump... But it's not really suited to do so.

PostgreSQL

09 May 2026 15:11

You mean, promote the secondary and then apply those log (from the replication) later?

PostgreSQL

08 May 2026 19:24

Ah! That makes sense then. Tx!

PostgreSQL

08 May 2026 13:33

I'm also looking for somebody (roughly) familiar with Commvault!

PostgreSQL

08 May 2026 02:08

@placement_lelo
@infosys_discussion_2023
@placementonoffcampus
@tcs_nqt_solutions_group
@job_batch

PostgreSQL

07 May 2026 17:15

any region is okay to work .. currently client is at Asia (Thailand) Region

PostgreSQL

06 May 2026 07:29

Any openings on PostgreSql or plsql development? For 8+ years

PostgreSQL

03 May 2026 20:59

What do you need, and please know that this channel is "best case only". If you need support, I suggest you look into getting a support contract with one of the commercial vendors.

PostgreSQL

01 May 2026 09:59

Do you trade with STM32 CubeMX programming videos?

PostgreSQL

30 April 2026 06:10

Hi Team
Can Any one please Share with me MS SQL(3) + Postgres(2) Resume format.

PostgreSQL

10 May 2026 13:04

I have Microsoft SQL and Postgre sql videos

PostgreSQL

10 May 2026 11:04

Hi all,
What criteria should we use to decide whether PostgreSQL connection pooling should be added to, retained in, or removed from our architecture?

PostgreSQL

09 May 2026 18:46

I will go through pg_rewind

PostgreSQL

09 May 2026 18:13

If you want to save time, you can also use pg_rewind to only transfer the changed parts of the database

PostgreSQL

09 May 2026 16:31

You will end up with different time lines in the database. Than can never match up again.

PostgreSQL

09 May 2026 15:13

If that's what you mean, then it's not possible, as logs are tightly bound to the current physical status of the data. Therefore, applying them to a database that has been modified later is not possible

PostgreSQL

09 May 2026 15:10

Hi team, if i have PostgreSQL asynchronous type replication and my primary failed but still there is replication lag . is there any feature available in PostgreSQL So that i can immediately promote standby and when after some point of time my old primary join as a standby those lost wal logs would also be available to new primary. Plz guide , I know we have to secure the logs before promote but it cause higher delay time . Just to minimize downtime lesser and lesser i am asking this . Can pg_rewind done this job

PostgreSQL

08 May 2026 17:43

--binary-upgrade does.

PostgreSQL

08 May 2026 13:32

So, found / learned something interesting these days...:
As we know, when you do ALTER TABLE a ADD COLUMN b TEXT NOT NULL DEFAULT 'abc'; the table doesn't get rewritten (since PG 11).

When you then go ahead and do ALTER TABLE a ALTER COLUMN b DROP DEFAULT; that works, the table is still not rewritten and the former DEFAULT is still returned.

Which is cool, and caused by pg_attribute keeping atthasmissing = t and attmissingval = {abc} even after the DROP DEFAULT.

What I wondered: does this survive a pg_upgrade. Turns out it does. And I'm dumbstruck by that, tbth, because pg_dump --schema-only doesn't mention the default anywhere, and my understanding is that the schema is always carried over using pg_dump.

Anyone able to enlighten me there?

PostgreSQL

07 May 2026 18:10

#job #dba #postgresql #blockchain #database #remote

Job: PostgreSQL DBA (Blockchain)
Company: Lagrange Labs
Salary range: $4,500–$6,500
Work arrangement: remote, full-time

Responsibilities:
— Administration, optimization, and scaling of high-load PostgreSQL databases.
— Designing storage architectures for massive arrays of indexed data from various blockchain networks.
— Tuning the performance of complex SQL queries and optimizing data schemas to minimize latency.
— Configuring and monitoring backup, replication, and disaster recovery systems.
— Monitoring database health, identifying bottlenecks, and preventing incidents.
— Working with PostgreSQL extensions and integrating with analytical tools.

Requirements:
— At least 4 years of experience as a Database Administrator.
— Expert knowledge of PostgreSQL (internal architecture, vacuuming, partitioning, indexing).
— Experience working with high-load systems and terabyte-scale data sets.
— Skills in automating routine tasks (Python/Bash) and working with infrastructure in Docker/Kubernetes.
— An understanding of the specifics of blockchain data (immutability, block and transaction structure) would be a significant plus.

Contact: Gorskines

PostgreSQL

07 May 2026 08:08

Any dba who can manage the postgres and understand the query to tune... intrested to work as a freelance work ..then pls connect with me

PostgreSQL

04 May 2026 16:22

pgBackRest may have been saved

https://www.linkedin.com/posts/davidsteele_after-i-announced-that-i-am-no-longer-maintaining-share-7457070555595313152-sW68

PostgreSQL

03 May 2026 20:55

Anyone interested to give support on posrgresql

PostgreSQL

01 May 2026 09:58

I have Microsoft SQL and Postgre sql videos

PostgreSQL

29 April 2026 23:12

If you're in the market for a solution right now, it's probably the safe choice. If you're currently using pgbackrest, I'd wait a bit. There's a lot of discussions going on behind the curtains right now, it's well possible that some solution to keep pgbackrest alive will show up.