[DOCS] Need help finding all possible parameters for wal_level
Hi, I'm searching for all of the possible parameters for setting the "wal_level" outlined in the PostgreSQL Streaming Replication article: https://wiki.postgresql.org/wiki/Streaming_Replication I currently see hot_standby, but I can't find a list for all of the parameters that setting will take. Where can I find that? Thanks!
Re: [DOCS] Need help finding all possible parameters for wal_level
Well, so that's what doesn't make sense. Other documentation also indicates a 'hot_standby' setting and I'm looking to see if it can do 'warm_standby' as well. I was hoping for a complete list because it seems scattered right now. On Fri, Sep 1, 2017 at 10:43 AM, Pantelis Theodosiou wrote: > > > On Fri, Sep 1, 2017 at 3:36 PM, None wrote: > >> Hi, >> >> I'm searching for all of the possible parameters for setting the >> "wal_level" outlined in the PostgreSQL Streaming Replication article: >> >> https://wiki.postgresql.org/wiki/Streaming_Replication >> >> I currently see hot_standby, but I can't find a list for all of the >> parameters that setting will take. Where can I find that? >> >> Thanks! >> > > They are here: https://www.postgresql.org/docs/current/static/runtime- > config-wal.html > > Note that there have been some changes (additions of replica and logical) > for this setting in the latest versions. > > > >
Re: [DOCS] Need help finding all possible parameters for wal_level
Hi all, Thank you. I'm using 9.6. I found all the available options in the 'postgresql.conf' file on the server itself. The explanations are good, but I was looking for something like this: # minimal, archive, hot_standby, or logical I saw the 'replica' option in the documentation, but not in the conf file itself, so I dunno if it's supported. On Fri, Sep 1, 2017 at 10:58 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Sep 1, 2017 at 7:46 AM, None wrote: > >> Well, so that's what doesn't make sense. Other documentation also >> indicates a 'hot_standby' setting and I'm looking to see if it can do >> 'warm_standby' as well. I was hoping for a complete list because it seems >> scattered right now. >> > > The documentation is version specific. All of the values allowed for the > specified version are listed on that page. There is not and never was a > "warm_standby" value. The valid values for wal_level do not fully > restrict how one can setup their standby configuration but rather define > the minimum possible configuration (which is basically either cold or warn > standby depending on whether you decide to run an independent standby > server full time). The settings at https://www.postgresql.org/ > docs/current/static/runtime-config-replication.html are use if you wish > to convert the warm standby into a hot standby. In either case the > relevant wal_level needs to be "replica". It was deemed unnecessary to > distinguish between "archive (cold/warn) and hot_standby" in 9.6 - in terms > of what information was recorded in the WAL. > > David J. >
Re: [DOCS] Need help finding all possible parameters for wal_level
Good call, Thank you On Fri, Sep 1, 2017 at 11:55 AM, Alvaro Herrera wrote: > None wrote: > > Hi all, > > > > Thank you. I'm using 9.6. I found all the available options in the > > 'postgresql.conf' file on the server itself. The explanations are good, > but > > I was looking for something like this: > > > > # minimal, archive, hot_standby, or logical > > > > I saw the 'replica' option in the documentation, but not in the conf file > > itself, so I dunno if it's supported. > > Hmm. Commit b555ed810267 (in 9.6) removed values 'archive' and > 'hot_standby' and introduced 'replica' to substitute them, and updated > postgresql.conf.sample to account for that. If you're using a > postgresql.conf file that has the outdated comment, I'm guessing that > the conf file was copied from an older installation somehow (which is > very common since the file largely remains compatible). > > -- > Álvaro Herrerahttps://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services >
[DOCS] Streaming replication documentation
Page: https://wiki.postgresql.org/wiki/Streaming_Replication Description: The instructions at step 7 are making too many assumptions. $PGDATA is an undefined variable that isn't created during the initial install process and rsync daemon on standby must be first setup and running. /srv/pgsql/ ins't a default file path created during install on Debian/RedHat-based systems, so some relevancy is lost in the instructions. The "pg_basebackup" command also won't work as you're not specifying a copy-to destination. It also seems something is missing on the standby node to match what's in the host pg_hba.conf file.
