6 ms·
Some of these are from our support playbook and I'm working on getting a few others. > When configuring a number of standby nodes > 1 what replication topology
by eddiezane 8y ago
Some of these are from our support playbook and I'm working on getting a few others.
> When configuring a number of standby nodes > 1 what replication topology is used? Are {all,none,some} replicas synchronous?
Trying to get an answer of this one.
> Is the postgres super user available?
At this time only our administrative users are superusers for the database. All other administrative tasks should be possible from the default "doadmin" user provided when setting up your database cluster.
You can see a list of current users in the database (including ours) with this command from the Postgres CLI: \du
If some administrative task isn't possible with the "doadmin" user just let us know and we can report that to our engineering team for review and potential future change. We can't promise anything immediately, but we can definitely look into changes long-term!
> What is the list of supported extensions?
address_standardizer
address_standardizer_data_us
btree_gin
btree_gist
chkpass
citext
cube
dblink
dict_int
earthdistance
fuzzystrmatch
hstore
intagg
intarray
isn
ltree
pg_buffercache
pg_partman
pg_stat_statements
pg_trgm
pgcrypto
pgrouting
pgrowlocks
pgstattuple
plcoffee
plls
plperl (PostgreSQL 9.5+)
plv8
postgis
postgis_sfcgal
postgis_tiger_geocoder
postgis_topology
postgis_legacy (see note below)
postgres_fdw
repack (PostgreSQL 10+)
sslinfo
tablefunc
timescaledb
tsearch2
unaccent
uuid-ossp
> Can WAL (physical/streaming) replication be configured to a non-managed postgresql instance? I'm assuming logical replication slots should be supported.
No, not available.
> Is there in-built streaming backups/point in time restore?
Only daily backups are available with our managed database service at this time. We maintain 7 days worth of backups for each database cluster. Backups can be viewed and restored from the Cloud Control Panel by clicking on your cluster and going to the "Backups" sub-tab. This will restore your entire database cluster to that point in time.
While the backup frequency can not be adjusted to more often/weekly/monthly, you can take point-in-time backups by creating a "fork" of your database cluster. The fork can be placed at a specific point-in-time (reference your logs to find out when the transaction happened modifying the data you want to get back), or "now".
> Any details you can share on how failover and general cluster management is performed?
Nodes are monitored and failover happens automatically with minimal downtime if a node becomes unavailable. Some more info [0].
> Are version upgrades supported? Assuming that would use pg_upgrade but is there an option for downtime-less upgrades using logical replication?
I _think_ all updates may require powering off but will try and confirm.
0: https://www.digitalocean.com/docs/databases/resources/high-availability/ https://www.digitalocean.com/docs/databases/resources/high-a...
- nh2 8y agoI recommend adding these points to the website once you know them. Especially not knowing whether it's synchronous or non-synchornous replication makes it impossible to design systems on it, as that decides whether you can lose some (likely small) amount of data on a failover, or whether the system guarantees nothing is lost. I also don't understand another key thing: On the Pricing page you write "Standby nodes with automated failovers". At the same time, the pricing table offers 0, 1 or 2 standby nodes. So what happens if I buy the offer with the 0 standby nodes, and a failure occurs? Is my data gone? Does DO replace the failed node, and how when there are no standbys?
- kamaln7 8y agoKamal from DigitalOcean here. With only a primary node and no standby nodes, a failure will cause a new replacement node to be created with its data being a combination of the latest backup and the write-ahead log. This will get you the most recent data possible. Check out this page for more info on auto failover and how it works with the different configurations: https://www.digitalocean.com/docs/databases/resources/high-availability/ https://www.digitalocean.com/docs/databases/resources/high-a...
- keypusher 8y agoHow is the WAL stored? If there is a problem with the storage, networking, or DC, you will not be able to get the WAL in order to bring up the DB in a new region. Also, the process of replaying WAL since last backup can take a very long time for a high traffic DB, during which time it is going to be completely unavailable.
- manigandham 8y agoThat's what a standby server is for, so that it's up to date without replaying the WAL. Nothing unique to DigitalOcean about that.
- kamaln7 8y agoThe WAL and all backups are stored offsite and are completely handled on our end. Re: availability, that’s right if you only have a primary node and no standby ones. Like manigandham said, there won’t be any downtime if you have a standby node.