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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo