Re: Setting up replication on Windows, v9.4

Note that WAL replication replicates *the whole instance* not just specific databases.  You need logical replication for that. Also, I just learned that 9.4 *does* have WAL replication slots (which makes replication *much* easier).  v9.6 is where replication is "like rolling off a log" simple.

Re: Setting up replication on Windows, v9.4

Cranking up the log_min_messages level might help, to see what is (or is not) reaching the server. On 11/11/22 14:35, Brad White wrote: > Or manually running the application queries? That was the odd thing. It didn't appear to be in the middle of running any queries. The database shouldn't hav

Re: Setting up replication on Windows, v9.4

> Or manually running the application queries? That was the odd thing. It didn't appear to be in the middle of running any queries. The database shouldn't have had any effect. > Anyway, try Pg 9.6. I have Pg 12 installed, so I'll try that. I'll start a new thread on my adventures in upgrading. Th

Re: Setting up replication on Windows, v9.4

On 11/10/22 21:24, Brad White wrote: On 11/7/2022 3:42 PM, Rob Sargent wrote: > Care to share some of the ways the app stopped working? You might get a leg up on where best to remediate. I don't recall, as that was a few months ago. We are running MS-Access as a front end with Postgres as the

Re: Setting up replication on Windows, v9.4

From the error log:      FATAL:  hot standby is not possible because wal_level was not set to "hot_standby" or higher on the master server      HINT:  Either set wal_level to "hot_standby" on the master, or turn off hot_standby here. I tried setting hot_standby to off, but that

Re: Setting up replication on Windows, v9.4

On 11/7/2022 3:42 PM, Rob Sargent wrote: > Care to share some of the ways the app stopped working?  You might get a leg up on where best to remediate. I don't recall, as that was a few months ago. We are running MS-Access as a front end with Postgres as the back end. It appeared to read and wr

Re: Setting up replication on Windows, v9.4

On 11/7/22 13:59, Brad White wrote: > v9.4 has been EOL for 2 years 9 months. As I said, the next step will be to upgrade. It would make sense to upgrade first, since "there have been some big advances since then which make replication much easier" But when we upgraded, the app stopped w

Re: Setting up replication on Windows, v9.4

> > > > v9.4 has been EOL for 2 years 9 months. As I said, the next step will be to upgrade. It would make sense to upgrade first, since "there have been some big advances since then which make replication much easier" But when we upgraded, the app stopped working. So I'll need to go through and n

Re: Setting up replication on Windows, v9.4

On 11/4/22 17:59, Brad White wrote: I'm setting up a backup for our primary postgres server using the archived WAL files. Then I'll try to upgrade it to Streaming Replication. Then I'll upgrade the system to v.latest. For now, we are on v.9.4. FYI: v9.4 has been EOL for 2 years 9 months.   (An

Re: Setting up replication on Windows, v9.4

2022年11月5日(土) 10:02 Ian Lawrence Barwick : > > 2022年11月5日(土) 7:59 Brad White : ... > > Interestingly, the recovery file says > > # Note that recovery.conf must be in $PGDATA directory. > > # It should NOT be located in the same directory as postgresql.conf > > Those seem contradictory. > > I don't

Re: Setting up replication on Windows, v9.4

2022年11月5日(土) 7:59 Brad White : > > I'm setting up a backup for our primary postgres server using the archived > WAL files. > Then I'll try to upgrade it to Streaming Replication. > Then I'll upgrade the system to v.latest. > For now, we are on v.9.4. > > I do a base backup from the primary to a d

Re: Setting up replication

That is helpful, thanks Vijay. I will wade in and give it a go. For some reason I had it in my head that it was a good idea to run pg_basebackup frequently, e.g. once a day, but it looks like it's only necessary once for the initial transfer to the replica. Oliver On Wed, 26 May 2021 at 20:37, V

Re: Setting up replication

core ref: PostgreSQL: Documentation: 13: Part III. Server Administration although this is a lot verbose, but you would keep coming back to this to tune your setup. to understand basic setups. some are How to Set Up Streaming Replication in PostgreSQ

Re: Setting up replication from 9.4 to 10.4

Thanks Andreas, pglogical seems really great. My knowledge of replication was frozen at the time of Slony II and PG 8.4, I didn't have the chance to use replication since that time. I'll give a look at pglogical ! Best regards Lionel 2018-06-06 8:40 GMT+02:00 Andreas Kretschmer : > > > Am 06.0

Re: Setting up replication from 9.4 to 10.4

Am 06.06.2018 um 08:16 schrieb Lionel Tressens: Hello, We are running a single PG 9.4 database node we are switching to PG 10.4 (which will run as master + setup of a slave) To minimize downtime when switching from the 9.4 server to the 10.4 one, I would like to setup a replication stream