Hi there,
I have been looking for a good solution to backup a postgresql 8.4
database server (not pg_dump) and the only options that it seems that I
have are either a Omnipitr or a custom-coded solution.
I am a little bit afraid about setting up omipitr in production for
archiving & backup, e
On Wed, 2007-04-04 at 11:07 -0400, Tom Lane wrote:
> Damian Lubosch <[EMAIL PROTECTED]> writes:
> > My problem now is, how to continually feed the slave server with new
> > received WAL files?
>
> You need to make the restore_command script wait until the next WAL file
> is available, instead of f
Hi,
Found on the dev mailing list (hidden well)...
On the master postgresql.conf:
archive_command = 'rsync -arv "%p"
slave_hostname:/.../wal_archive/"%f";'
(and maybe '&cp "%p" /.../wal_archive/"%f";')
archive_timeout= 900
So, you need to perform a ssh-keygen on both sides.
Now, the slave recov
Damian Lubosch <[EMAIL PROTECTED]> writes:
> My problem now is, how to continually feed the slave server with new
> received WAL files?
You need to make the restore_command script wait until the next WAL file
is available, instead of failing immediately.
This is actually not that simple to get ri
Hello!
I already searched in the archives for similar problems but didn't find any.
I want to have a hot backup server of my master server's database.
I am using NetBSD 3.0.1 with Postgresql 8.2.3.
It works so far, that I receive the WAL Files on the slave every few
minutes from the master. I ha
yes,
either by snapshot (Os-feature) or pg_dump
-Original Message-From: Steulet Grégory
[mailto:[EMAIL PROTECTED]Sent: Mittwoch, 03. August 2005
10:47To: pgsql-admin@postgresql.orgSubject: [ADMIN] hot
backup
Hi,
I just would
like to know if it's possible t
On Wed, 3 Aug 2005, Steulet Grégory wrote:
I just would like to know if it's possible to dot hot backup(not dump) with
postgres.
That probably depends what you define as a hot backup. Likely what you are
looking for is Point in Time Recovery through WAL archiving. Read about it
here:
http
Hi,
I just would like
to know if it's possible to dot hot backup(not dump) with postgres.
Thank
you
Greg
Grégory SteuletAssistant HES
HEG Haute école de gestion
ArcLaboratoire
de Base de Données84,
rue de l
:14 PM
To: Krishna R Palati
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Hot backup
On Tue, Jun 01, 2004 at 10:55:26 -0400,
Krishna R Palati <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Thanks for the reply. Pg_dump might provide consistent dump at that point
of
> time. But my questi
On Tue, Jun 01, 2004 at 10:55:26 -0400,
Krishna R Palati <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Thanks for the reply. Pg_dump might provide consistent dump at that point of
> time. But my question is:
>
> We can setup pg_dump everyday at 3AM. Suppose a crash occurs at 10PM. Is
> there a way in
: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Monday, May 31, 2004 5:15 AM
To: Krishna R Palati
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Hot backup
On Wed, May 26, 2004 at 10:50:21 -0400,
Krishna R Palati <[EMAIL PROTECTED]> wrote:
>
> I read online that Postgres 7.4.1 has the c
On Wed, May 26, 2004 at 10:50:21 -0400,
Krishna R Palati <[EMAIL PROTECTED]> wrote:
>
> I read online that Postgres 7.4.1 has the capability to do hotbackups
> (equivalent to Hotbackups on Oracle). But am not able to find any
> documentation which will help me set up one. Can you please point me
Hello,
I read online that Postgres 7.4.1 has the capability to do
hotbackups (equivalent to Hotbackups on Oracle). But am not able to find any
documentation which will help me set up one. Can you please point me to a
resource that I can use to set up hotbackups for Postgres 7.4.1 ?
13 matches
Mail list logo
