PostgreSQL

05 March 2025 21:16

and then run juniper for 6 ports communication?

PostgreSQL

05 March 2025 21:14

how rack help with that?

PostgreSQL

05 March 2025 21:14

like when 24 disk start to resonate, others can degrade in performance

PostgreSQL

05 March 2025 21:13

reliability i guess, what you can search more ? maintainability?

PostgreSQL

05 March 2025 21:12

is it even good idea to mix rack and non rack

PostgreSQL

05 March 2025 21:10

Oooh its just enclosure, nice

PostgreSQL

05 March 2025 21:09

It's an Oracle DE2-24

PostgreSQL

05 March 2025 21:07

just wanted to show off for no particular reason if not the fact that i can post images

PostgreSQL

05 March 2025 19:55

And the "final" explanation:

bluthg=# SELECT pg_typeof(0.1^2.0), pg_typeof(0.1::float^2.0::float);
┌───────────┬──────────────────┐
│ pg_typeof │    pg_typeof     │
├───────────┼──────────────────┤
│ numeric   │ double precision │
└───────────┴──────────────────┘
(1 row)

PostgreSQL

05 March 2025 17:32

It's not serious. Need such disks:
https://hackaday.com/wp-content/uploads/2023/02/usagi_electronics_repairing_1970s_HDD.jpg?w=800

PostgreSQL

05 March 2025 17:24

New server for postgresql just arrived

PostgreSQL

05 March 2025 16:02

Ok...

bluthg=# SELECT 0.1::float^2.0::float;
┌──────────────────────┐
│       ?column?       │
├──────────────────────┤
│ 0.010000000000000002 │
└──────────────────────┘
(1 Zeile)

bluthg=# SELECT 0.1^2.0;
┌──────────────────────┐
│       ?column?       │
├──────────────────────┤
│ 0.010000000000000000 │
└──────────────────────┘
(1 Zeile)

bluthg=#

PostgreSQL

04 March 2025 18:46

Or alternatively ensure you're using ssl for all of your database connections

PostgreSQL

04 March 2025 18:45

To enable encrypted data flow between servers

PostgreSQL

04 March 2025 08:11

Hello Everyone

We are migrating data from oracle to postgres using the ora2pg tool. We are exploring ways to perform this migration in encrypted mode.
Does anyone have experience or how to achieve this?

PostgreSQL

05 March 2025 21:15

Racked servers have a lot of additional components that consume more power. On my racked HPE 425, the raid card was 25w even when not used

PostgreSQL

05 March 2025 21:14

the 405 G6 is 35w for the full system, 100% load

PostgreSQL

05 March 2025 21:14

cost and power consumption

PostgreSQL

05 March 2025 21:13

It depends on what you're looking for

PostgreSQL

05 March 2025 21:11

From top to bottom:

Mikrotik RB5009
Juniper EX4300
Supermicro SC-something + X470D4U
HP 405 G6 SFF
Oracle DE2-24
A random dual Asusrack PC
HP 806 G5 SFF
Another random dual Asusrack PC

PostgreSQL

05 March 2025 21:09

under switch is dell under oracles is hp

PostgreSQL

05 March 2025 21:08

what is storage system there, can't recognise

PostgreSQL

05 March 2025 21:06

was there a joke already about storing as blob photo of your mom?

PostgreSQL

05 March 2025 17:54

I'm guessing people didn't understand what your question actually is?

PostgreSQL

05 March 2025 17:24

Are these enough drives for a db

PostgreSQL

05 March 2025 17:23

Was nicht cell ist?!

(Sorry, just kidding, I don't know Deutsch).

PostgreSQL

04 March 2025 18:48

First step is to set the pg_hba.conf entry that applies to your connection to hostssl.
If ora2pg still works, you're good on the target side. No idea about the source side, that will probably be a pita

PostgreSQL

04 March 2025 18:45

Setup a wireguard or ssh tunnel and enjoy free transparent encryption

PostgreSQL

04 March 2025 18:44

If you could tell us what you mean with "encrypted mode"...

PostgreSQL

03 March 2025 15:55

Any recommended settings for postgres aurora..I meant all the parameters (work memory,cache,vaccum, etc)