i'm not sure if this will help, but the following
should be located in your postgresql.conf file...
--- David <luckychap(at)bluebottle(dot)com> wrote:
> My database v8.3 is running well on Fedora C3, but
> now I have to instal a
> backup system and
> I am having trouble understanding the documentation.
> I am new to Postgresql
> so please be
> patient with my questions.
> What is the difference between archive and backup?
> The terms seem to be
> inter changed.
> The "Archive" command "will always be placed in the
> postgresql.conf file (p
> 307). I could not see any sections or related
> commands there. Not even an
> example. Will adding an archive command in this file
> actually cause wal
> files to be copied? If so, when - when they fill or
> at a set interval or
> when a full backup is done. Is there a way of
> forcing the Wal file to be
> The following command (p308) uses -i and </dev/null.
> The -i allows interact
> with the
> terminal, the </dev/null suggests it can get input
> from null. It seems
> contradictory to
> Cp -i %p mnt/server/archivedir/%f </dev/null
> How can I ensure WAL archiving is enabled and
> working? I thought it was
> If I execute pg_start_backup, an archive command,
> and pg_stop_backup in a
> script, will the
> commands be carried out in sequence and do not
> overlap (p309).
> Are backed up WAL files automatically deleted? Can
> a delete command be
> added to the script?
> If there is any more documentation or books for
> beginners that are explicit
> on WAL backups I
> will gratefully buy one.
Sell on Yahoo! Auctions no fees. Bid on great items.
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2005-07-06 18:46:14|
|Subject: Re: User Defined Note Order Problem|
|Previous:||From: operationsengineer1||Date: 2005-07-06 16:56:13|
|Subject: User Defined Note Order Problem|