Thanks for the prompt response!
On 22/12/2007, at 1:33 PM, Tom Lane wrote:
Tom Davies <[EMAIL PROTECTED]> writes:
3. What's the best thing to do when I deliberately shut down
PostgreSQL (i.e. pg_ctl stop)? When I start again I will be restoring
from the most recent backup and rolling forward
Tom Davies <[EMAIL PROTECTED]> writes:
> 1. Purely out of curiousity, what's the .history file which is
> requested from the archive when you restore?
Read the doc section about timelines --- if a history file exists,
it's needed to allow proper tracing of the "timeline" through multiple
I've been working on backup restore scripts for a PostgreSQL DB hosted
on an Amazon EC2 instance. EC2 instances don't have any persistent
storage, so I archive the WAL files to Amazon S3. I do periodic
backups, and restore and roll forward when an instance is restarted.
I've followed the ex
We occasionally get the "file changed while being read" error, usually
only once or twice a month (and we run nightly backups.) It's nothing
to be concerned about, as someone else mentioned, the WAL logs will fix
any internal inconsistencies.
Regarding the file sizes, because it's zipped (I b
Another thing that conerns me is that the zipped file size keeps changing.
I'm backing up 10GB total. One night the backup file was 9 GB, one night it
was 874 MB and just now, 5 GB. I'm expecting a file around 1.5 GB (15% of
the 10GB) that's there.
---(end of broa
uot; <[EMAIL PROTECTED]>
To: "Mr. Dan" <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] On-line backup - /bin/tar: Error exit delayed from
previous errors
Date: Thu, 3 Aug 2006 10:02:25 +0200
I think you should post the command you're using, as well as the
condition in which you&
Mr. Dan wrote:
> /bin/tar: /sqldata/Linux.pgsql/base/19473856/19524666: file changed as we
> read it
>
> Hi,
>
> I'm seeing that a file changed during the /bin/tar process. Is that
> anything to be concerned about?
> This is the first time this happened in a month. Does that mean I'm still
>
/bin/tar: /sqldata/Linux.pgsql/base/19473856/19524666: file changed as we
read it
Hi,
I'm seeing that a file changed during the /bin/tar process. Is that
anything to be concerned about?
This is the first time this happened in a month. Does that mean I'm still
backed up in regards to that da
Thanks!
~DjK
From: Tom Lane <[EMAIL PROTECTED]>
To: "Mr. Dan" <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] On-line backup Date: Mon, 17 Jul 2006 14:43:30 -0400
"Mr. Dan" <[EMAIL PROTECTED]> writes:
> ... What h
"Mr. Dan" <[EMAIL PROTECTED]> writes:
> ... What happens is that we have a 'hot' table (one with many many
> transactions) that gets inserted and deleted often. About once a month now
> when we do a select from that table the results of the select do not match
> the where clause, ex.
> select *
Hi Tom,
We do a complete re-index(reindexcb) to the cluster on the weekend.
The index corruption is characterized by incorrect result sets returned from
a query. What happens is that we have a 'hot' table (one with many many
transactions) that gets inserted and deleted often. About once a mont
"Mr. Dan" <[EMAIL PROTECTED]> writes:
> Is this 2003 advice still relevant with postgresql 8.1.0? Our b-tree
> indexes corrupt pretty often on our production server running 8.1.0 and we
> are grasping for a solution.
Corrupt how --- what's the exact symptoms?
The *first* bit of advice I'd giv
Hi Tom,
Is this 2003 advice still relevant with postgresql 8.1.0? Our b-tree
indexes corrupt pretty often on our production server running 8.1.0 and we
are grasping for a solution. We perform online backups like this: In
addition, we archive the transactions and replay them for PITR.
/us
On Thu, Aug 18, 2005 at 11:01:27PM -0400, Bruce Momjian wrote:
> Enzo D'addario wrote:
> > 2.What happens with any DB inserts, updates, deletes etc that occur
> > between the SELECT pg_start_backup() and the end of the tar?
> > They would be already logged in the WAL files and already applied in t
Enzo D'addario wrote:
> Hi All,
>
> I have a couple of questions regarding On-line backup and point-in-time
> recovery (PITR) in the postgres documentation:
>
> 1.How is it that we can create a tar file of the PG Data directory
> whilst postgres is running?
Whe pg_xlog archived files contain inf
Hi All,
I have a couple of questions regarding On-line backup and point-in-time
recovery (PITR) in the postgres documentation:
1.How is it that we can create a tar file of the PG Data directory
whilst postgres is running?
2.What happens with any DB inserts, updates, deletes etc that occur
betwee
16 matches
Mail list logo
