?
Thanks,
Scott
On Sun, Apr 28, 2013 at 11:22 AM, Tom Lane wrote:
> Scott Briggs writes:
> > So we're using 8.3 with file-based replication using rsync to a warm
> backup
> > server. The problem is the backup server crashed and somehow WAL files
> got
> > lost so t
So we're using 8.3 with file-based replication using rsync to a warm backup
server. The problem is the backup server crashed and somehow WAL files got
lost so the backup server is continuously looking for WAL files that are no
longer available on the master.
My question is, how can I skip to a se
So we have a large TB database that we need to migrate to 9.1 and I'm
wondering if there's a way to do this process in stages.
Since the date/time storage types changes between 8.3 and 8.4, I
realize we'll have to dump the database and my plan is to create a
backup using pg_start_backup(), run tha
with wal
files?
Cheers,
Scott
On Wed, May 16, 2012 at 6:28 AM, Albe Laurenz wrote:
> Scott Briggs wrote:
>> Hi, can someone please explain the purpose of archive_command on both
>> the master and slave when it comes to streaming replication? From
>> what I understand so far, w
So this is purely anecdotal but I'm curious, what's with all the
different naming conventions? There's psql (for database
connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this
mailing list), postgres (user and other references), and postgresql
(startup scripts).
Cheers,
Scott
--
Hi, can someone please explain the purpose of archive_command on both
the master and slave when it comes to streaming replication? From
what I understand so far, what really matters is how many pg_xlog
files are kept when it comes to reestablishing replication when it
breaks for some reason.
Let'
On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge
wrote:
> On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote:
>> Hi, so I have a master-slave set of database servers that are running
>> postgres 9.0 using streaming replication and I'd like to migrate them
>> to 9.1
Hi, so I have a master-slave set of database servers that are running
postgres 9.0 using streaming replication and I'd like to migrate them
to 9.1. My question is, can 9.0 do streaming replication to 9.1? If
not, what's the best way to upgrade a production database to 9.1 with
no downtime?
I als
