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 German,
Il 09/05/13 17:45, German Becker ha scritto:
> Do I need to get a new copy of the primary to continue the replication?
Yes. At that point, it is a completely different server with its own new
life. :)
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Se
Hi Viktor,
Yes that is the usual procdure* *I use. The question was, since the primary
is starting from a backup and then "diverting" to a new timeline, if there
was a way to make the secondary start from the same backup and then follow
the primary. I'm gessing the answer is no
On Fri, May 10
Hei,
I think, that it can be done just via RSYNC with stopped both of databases:
http://www.debian-administration.org/article/How_to_setup_Postgresql_9.1_Streaming_Replication_Debian_Squeeze
Just like in the "*Getting it working*" part.
On 5/9/2013 6:45 PM, German Becker wrote:
Hello Everyon
Hello Everyone,
I have a primary / hot standby scenario with streaming replication.
Postgres version is 9.1.8.
A full backup is made nightly on the primary and copied to the secondary,
just for backup purposes, the replication is never stopped /restarted.
Supose that for a reason I need to rest
(017) 362 3661
Email: white.he...@yahoo.com
From: Ian Lea
To: Karuna Karpe
Cc: pgsql-admin@postgresql.org
Sent: Wednesday, November 23, 2011 11:51 PM
Subject: Re: [ADMIN] Point in time recovery
> Can any one please explain me how to us
On 11/23/2011 08:39 PM, Karuna Karpe wrote:
Hello,
Can any one please explain me how to use PITR?
Are you struggling with one particular issue with PITR setup where the
documentation isn't helping? If so, please explain in more detail,
making sure to include all the appropriate infor
> Can any one please explain me how to use PITR?
http://lmgtfy.com/?q=postgres+pitr
--
Ian.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Wed, Nov 23, 2011 at 12:39 PM, Karuna Karpe
wrote:
> Can any one please explain me how to use PITR?
Yes, the docs contain a great explanation.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin m
Hello,
Can any one please explain me how to use PITR?
Regards,
karuna karpe.
I've tried to follow the directions as closely as possible, but still
the server won't start. I do get a different PANIC:
2011-08-26 23:55:08 CEST LOG: database system was shut down at
2011-08-26 22:08:35 CEST
2011-08-26 23:55:08 CEST LOG: starting archive recovery
2011-08-26 23:55:08 CEST
I've tried to follow the directions as closely as possible, but still
the server won't start. I do get a different PANIC:
2011-08-26 23:55:08 CEST LOG: database system was shut down at
2011-08-26 22:08:35 CEST
2011-08-26 23:55:08 CEST LOG: starting archive recovery
2011-08-26 23:55:08 CEST L
gais wrote:
> I'm running a caldav server with postgresql backend. For some
> reason a user removed his agenda, I want to revert to a state
> before 20th of August in order to restore this. I have a
> configuration with archive_mode = on in postgresql.conf and a
> timeout of 24h. I have a dump f
Hi, new to the list here.
I'm running a caldav server with postgresql backend. For some reason a
user removed his agenda, I want to revert to a state before 20th of
August in order to restore this. I have a configuration with
archive_mode = on in postgresql.conf and a timeout of 24h. I have a
ml ml wrote:
> i am using the following archive command:
>archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p
> pg...@pg-backup:/restore/walfiles/'
>
> Which works perfectly so far. My problem now is, what happens if the
> "pg-backup" server is down for some time and the archove command
Hello List,
i am using the following archive command:
archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p
pg...@pg-backup:/restore/walfiles/'
Which works perfectly so far. My problem now is, what happens if the
"pg-backup" server is down for some time and the archove command can
not copy th
Mailing List wrote:
> Hi.
>
> In April this year there was a thread on this list talking about a
> future "point in time" recovery feature in PostgreSQL.
>
> http://www.geocrawler.com/mail/thread.php3?subject=%5BADMIN%5D+point-in-time+recovery&list=7
>
> 7.4 was rumored to include such a feature
Mailing List writes:
> 7.4 was rumored to include such a feature.
Those rumors are false.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi.
In April this year there was a thread on this list talking about a
future "point in time" recovery feature in PostgreSQL.
http://www.geocrawler.com/mail/thread.php3?subject=%5BADMIN%5D+point-in-time+recovery&list=7
7.4 was rumored to include such a feature.
Does anybody know what the status
19 matches
Mail list logo
