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

Setting up replication on Windows, v9.4

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 directory on the NAS. "C:\Program Files\Po

Re: postgres disconnects on master after setting up replication

yep we think this is exactly the issue...we have been testing a new build with a later driver in UAT this morning and no recurrence of the issue so looking most probable. thanks all for the very prompt and clear responses it's most appreciated. On Tue, 17 Aug 2021 at 13:09, Dave Cramer wrote: > >

Re: postgres disconnects on master after setting up replication

Dave Cramer www.postgres.rocks On Mon, 16 Aug 2021 at 12:32, Andy Hall wrote: > thanks for the very clear explanation much appreciated shall take this > back to the team. > > On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote: > > > > Andy Hall writes: > > > we have an odd issue where a java app us

Re: postgres disconnects on master after setting up replication

thanks for the very clear explanation much appreciated shall take this back to the team. On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote: > > Andy Hall writes: > > we have an odd issue where a java app using JDBC which has been > > working fine has suddenly started disconnecting after we setup > >

Re: postgres disconnects on master after setting up replication

Andy Hall writes: > we have an odd issue where a java app using JDBC which has been > working fine has suddenly started disconnecting after we setup > replication from the database it was connecting to ( which is now the > primary in a replicating pair ) with errors such as the following... > CLI

postgres disconnects on master after setting up replication

we have an odd issue where a java app using JDBC which has been working fine has suddenly started disconnecting after we setup replication from the database it was connecting to ( which is now the primary in a replicating pair ) with errors such as the following... CLIENT SIDE: DBNAME/logs/2021081

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

Setting up replication

Hi, We currently have an app with the database on the same server as the app itself. I'd like to transition to a system where 1) in the short term, the db replicates to a different server. This will allow us to take the daily pg_dump backups from the replica rather than the primary server. They'r

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

Setting up replication from 9.4 to 10.4

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 instead of stopping the production, dumping 9.4 and res