[ADMIN] Steps to switch from Master to standby mode :

Hi all, I have been trying to setup Postgres 9.2 in HA using streaming replication and base backup. There is no problem in switching from: Standby -> Master using the trigger file mechanism provided by postgres. The problem comes when switching from: Master -> Stanbdy : I try to set up Streaming

Re: [ADMIN] Point in time recovery + replication

Hi all, I have been trying to setup Postgres 9.2 in HA using streaming replication and base backup. There is no problem in switching from: Standby -> Master using the trigger file mechanism provided by postgres. The problem comes when switching from: Master -> Stanbdy : I try to set up Streaming

Re: [ADMIN] Steps to switch from Master to standby mode :

So to allow a standby to recover WAL files that are missing (using archives or directly copying wall from the new master to the new standby) in order to complete the timeline change, is a wrong approach, I mean is this not safe in term of data not being corrupted? Because i tried this and this seem

[ADMIN] Standby doesn't chose a new timeline when promoted to master

Hi all, I am trying to set up Postgres 9.2 in HA mode. But i have noticed something strange happening with the xlogs being generated after a switch over. Problem: When a standby is promoted to master mode its not choosing a new timeline to work with. Can anyone please help me with the situations

Re: [ADMIN] Steps to switch from Master to standby mode :

ql/archivedir/0004.history': No such file or directory LOG: invalid record length at 0/1E80 and they just continue like this. Please help me with the reason for this issue. regards, Prakhar On Mon, May 20, 2013 at 6:06 AM, Amit Langote wrote: > On Wed, May 15, 2013 at 3:12

Re: [ADMIN] Steps to switch from Master to standby mode :

1 comes up it has all the archives (including that it generated when Node1 was master) when it comes up in standby mode. Is that a problem? Please let me know the problem with this approach. regards, Prakhar. On Mon, Jun 3, 2013 at 7:46 PM, Amit Langote wrote: > On Mon, Jun 3, 2013 at 9:43

Re: [ADMIN] WAL scenario valid?

Hey.. I am facing a similar kind of problem, but in a two node setup. Streaming replication is being used with a high wal_keep_segments, using log shipping to bump up timelines on the standby server to setup SR(streaming replication). DB1 - master DB2 - standby When a switchover happens DB2 becom

Re: [ADMIN] WAL scenario valid?

t; on DB1 before starting DB1 in standby mode and if "Latest checkpoint location" on DB1(old master) is greater than *"last replayed xlog id*" on DB2(new master) then i have to go for basebackup. regards, Prakhar. On Wed, Jun 19, 2013 at 1:11 PM, Albe Laurenz wrote: > prakha

[ADMIN] 777 permissions on basebackup directory

Hi all, I am currently using postgresql 9.2 installation. While taking base backups using pg_basebackup utility, I noticed that permissions of the directory which i specify for base backup are set to 777. Does postgesql need such lenient permissions to work, coz 777 on Db directory seems a securit

[ADMIN] Does postgres user on linux need login permission?

Hey, I am using postgres9.2, on a linux 6.3 box. For start i created a user postgres on linux with login permission and no password. Is it necessary for the postgres user to have login permissions? Can i change it to "no login" with out breaking basebackup and Streaming Replication from other ma