Timeline for Are PostgreSQL clusters and servers the same thing?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 9, 2017 at 14:40 | history | tweeted | twitter.com/StackDBAs/status/917399401194311680 | ||
| Oct 9, 2017 at 10:17 | vote | accept | Anders Rabo Thorbeck | ||
| Oct 9, 2017 at 9:53 | comment | added | Vérace | A schema is what Joe Sixpack would understand as a database - a bunch of related information stored together - i.e. the "HR database", the "Sales database" &c... | |
| Oct 9, 2017 at 9:53 | comment | added | Vérace | Take a look here. A "database" can be the machine with its disks, a running instance of PosgreSQL (or Oracle - concepts similar if you exclude the 12c specific stuff), or a schema. Within a schema transactions are guaranteed to be ACID. I think the hierarchy is best visualised as instance -> database -> schema. An instance can be the machine + disks and also the database software as running. A database is an instance with one or more running schemas (excluding templates in the case of PostgreSQL). | |
| Oct 9, 2017 at 9:16 | answer | added | Basil Bourque | timeline score: 10 | |
| Oct 9, 2017 at 7:54 | review | First posts | |||
| Oct 9, 2017 at 8:38 | |||||
| Oct 9, 2017 at 7:52 | history | asked | Anders Rabo Thorbeck | CC BY-SA 3.0 |