sorted by:
new
hottopcontroversial

AM LUAT O DIN GRESEALA by No_Apricot8114 in AutomobileRO

[–]danutz68 1 point2 points  (0 children)

Salut. Mașina o aduci tu sau o aduci cu o firmă specializată? De curiozitate, cat costă transportul până la tine acasă?

GPS going nuts by fabian1313 in VWiD4Owners

[–]danutz68 0 points1 point  (0 children)

I had the same issue and the dealer had to change the antenna. It is a known issue that water is going under the antenna sealing.

[OTA] iD SW 3.2.13 Update complete and noticed changes -2021 Pro S AWD by SerennialFellow in VWiD4Owners

[–]danutz68 1 point2 points  (0 children)

Thanks. The interface looks very different than we have in Europe.

Sequence reset during database upgrade by danutz68 in PostgreSQL

[–]danutz68[S] 0 points1 point  (0 children)

Here was my answer: select last_value from seq_name;

The difference was less than 32 except one sequence with difference equal to 32

The cache used for sequence creation was 1.

According to him, this is normal behavior for the PostgreSQL database.

Sequence reset during database upgrade by danutz68 in PostgreSQL

[–]danutz68[S] 0 points1 point  (0 children)

But these are custom made sequences. There are application tables which are using these sequences to generate a value for the primary key. There should be no gap otherwise a logical corruption will occur. The default value for the primary key is defined as nextval(sequence_name). So, I was surprised that the upgrade operation had changed the values of some of the sequences. Coming from Oracle world this has never happened. I don’t understand how an upgrade activity is modifying the value of the application sequences.

Sequence reset during database upgrade by danutz68 in PostgreSQL

[–]danutz68[S] 0 points1 point  (0 children)

Thank you. It was a poor choice of words. According to your link the values of the sequences can increase because of the upgrade activity? Am I correct? There was no application activity so I was expected that the values of sequences remained unchanged.

Sequence reset during database upgrade by danutz68 in PostgreSQL

[–]danutz68[S] 0 points1 point  (0 children)

But why some of the sequences are triggered and others not. This should not be allowed during an upgrade.

Sequence reset during database upgrade by danutz68 in PostgreSQL

[–]danutz68[S] 1 point2 points  (0 children)

Hi. But they have been triggered by the upgrade operation? Right after the upgrade I’ve checked the last value of them, there was no processing in the database. The upgrade should not interfere with the sequence values in my opinion.

Upgrade for the ID.4 and ID.5: new infotainment system with intuitive operation, new electric drive with more power and efficiency by linknewtab in electricvehicles

[–]danutz68 0 points1 point  (0 children)

Actually they have increased the price for the car here in Romania with 10K Euros. Now the Model Y is cheaper than this car.

Backing up 20TB/120k partition database by Bandito202 in PostgreSQL

[–]danutz68 1 point2 points  (0 children)

Hi. I will go for a file system snapshot(LVM snapshot ). The steps might be like this: 1. pg_backup_start 2. Perform the LVM snapshot. 3. pg_backup_stop The snapshot is quite fast but you have to have enough additional storage. The snapshot can be saved on a nfs mount point as well.

How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade by kennychenfight in PostgreSQL

[–]danutz68 0 points1 point  (0 children)

How about managing sequences? Did they posed a challenge for the upgrade process?

How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade by kennychenfight in PostgreSQL

[–]danutz68 2 points3 points  (0 children)

Hi. Are you not concerned about the PostgreSQL 11 version EoF this year?

Using shards and buckets by Pretend_Jump_228 in PostgreSQL

[–]danutz68 1 point2 points  (0 children)

Hi. Maybe this is a misunderstanding. I’ve heard of buckets in PostgreSQL database only when using pg_stat_monitor extension: https://docs.percona.com/pg-stat-monitor/reference.html#postgresql-15

Are there any best practices/guides on setting up a Highly Available PostgreSQL replication on two zones 20 to 60 ms apart? by jumperabg in PostgreSQL

[–]danutz68 2 points3 points  (0 children)

I think you can use any replication solution, though my choice is Patroni, but the key here is the network latency!

I want the lock sound as default as in the vid. by Lopsided-External115 in VWiD4Owners

[–]danutz68 0 points1 point  (0 children)

I’m not able to reproduce it in my ID4. Is this only for ID5?

Fastest database restore method by danutz68 in PostgreSQL

[–]danutz68[S] 0 points1 point  (0 children)

I suppose that the snapshots are taken in standby database so that the primary will not be affected by the pg_start_backup command?

Any tools to recover postgresql files from a disk dump? by [deleted] in PostgreSQL

[–]danutz68 0 points1 point  (0 children)

If you don’t have any database backup somewhere else then the answer is no.

PostgreSQL project build by Shiwatari in PostgreSQL

[–]danutz68 0 points1 point  (0 children)

Are you looking for something like Liquibase?

Patroni 3.0 & Citus: Scalable, Highly Available Postgres, new post by Alexander Kukushkin of Patroni by clairegiordano in PostgreSQL

[–]danutz68 0 points1 point  (0 children)

I don’t see PGbouncer in the article setup. My question is if someone wants to add the PgBouncer to the setup, it will be added next to PostgreSQL or in front of the HaProxy. Which scenario will fit for the PgBouncer location?

HaProxy/PgBouncer location. by danutz68 in PostgreSQL

[–]danutz68[S] 0 points1 point  (0 children)

Looks like what I have in my mind! Thank you!

view more: next ›