4 ms·
> Unfortunately, this sort of air-gapped setup is not something PostgreSQL supports out-of-the-box. Is a reverse tunnel really air gapped? I thought AG meant
by paulryanrogers 6y ago
> Unfortunately, this sort of air-gapped setup is not something PostgreSQL supports out-of-the-box.
Is a reverse tunnel really air gapped?
I thought AG meant one had to physically touch the device and transfer using devices without any network capability, such as a flash drive?
- tyingq 6y ago"Unfortunately, this sort of air-gapped setup is not something PostgreSQL supports out-of-the-box." Not sure what they mean by "out of the box", but you can make the listen_addresses list empty: "listen_addresses (string) ...If the list is empty, the server does not listen on any IP interface at all, in which case only Unix-domain sockets can be used to connect to it..." https://www.postgresql.org/docs/9.3/runtime-config-connection.html https://www.postgresql.org/docs/9.3/runtime-config-connectio...
- jagged-chisel 6y agoI’m sure the article author meant, by saying “out-of-the-box,” the features available on initial, default install. I disagree with the author and agree that indeed a fresh install supports (i.e. allows one to configure without rebuilding) not talking over a network at all.
- tyingq 6y agoAh, yes, re-read, and they do mention this.
- gnabgib 6y agoThat's a good question. I agree with your definition of AG. However, the only time a database (or any other kind of data store) would be useful in an AG setting would be if it's part of an AG system including network and other computers. Perhaps we need another somewhat similar term. It's like null-routing or firewalling devices on your network.. they're technically "connected" but if they cannot dial out they're in some ways gapped. (This is handy for dubious quality IoT devices, they can't phone home, auto-patch to drop features, or share your usage information with $corp, but still respond to local network commands). To some extent tunneling is security through obscurity (an SSH tunnel has moved the port you need to secure from 5432 to 22)
- paulryanrogers 6y agoAir gapped data stores sound useful for very common scenarios like: offline backups, non-anonymized PII, infrequently accessed bank records
- deleted 6y ago[deleted]
- chasd00 6y agoAir gap means there’s no physical connection. Like literal air between one wire and the other. Air gap should never be thought of something like a “logical air gap” because so such thing exists. Either the cable is physically plugged in or it isn’t.
- defanor 6y agoPretty sure that the common definition (also the one from Wikipedia [0]) is that there's no connection to a network (including wireless ones; the medium is not an important part in the concept). The article appears to say that a database/DBMS in the ideal world is not accessible over network at all. That is, apparently only accessible by users who have physical access to the machine it is on. [0] https://en.wikipedia.org/wiki/Air_gap_(networking) https://en.wikipedia.org/wiki/Air_gap_(networking)