Thanks a lot Laurenz Albe.
On Wed, Jun 19, 2013 at 6:16 PM, Albe Laurenz wrote:
> girish R G peetle wrote:
> > I was wondering if I can use the modified version of your solution.
> >
> > 1. Convert output of pg_stop_backup to transaction log file name. (This
> refers to the latest active
> > tr
girish R G peetle wrote:
> I was wondering if I can use the modified version of your solution.
>
> 1. Convert output of pg_stop_backup to transaction log file name. (This
> refers to the latest active
> transaction log file)
> 2. If we are able to see this file under archive(WAL) directory, bac
On Wed, Jun 19, 2013 at 4:32 PM, Albe Laurenz wrote:
> girish R G peetle wrote:
> > @Albe
> > Even I was thinking to backup the transaction log files under pg_xlog
> directory. But my concern is,
> > will it lead some kind of error or inconsistency ?
>
> No.
> During recovery, archived WAL files w
girish R G peetle wrote:
> @Albe
> Even I was thinking to backup the transaction log files under pg_xlog
> directory. But my concern is,
> will it lead some kind of error or inconsistency ?
No.
During recovery, archived WAL files will overwrite the ones in
pg_xlog. The WAL files in pg_xlog will
Hi
Thanks everyone for your quick response.
@Raghavendra,
Calling CHECKPOINT did not help. It will just force a transaction log
checkpoint, but it won't ensure/enforce archiving of current active
transaction log file.
@Albe
Even I was thinking to backup the transaction log files under pg_xlog
dir
On 19 June 2013 09:32, girish R G peetle wrote:
> Is there a way to switch the current transaction log file in Postgres 8.0 ?
No, that was an addition to 8.2
Suggest that you send more data until the WAL file switches.
You should upgrade with some urgency.
--
Simon Riggs ht
On Wed, Jun 19, 2013 at 2:02 PM, girish R G peetle
wrote:
> Hi
> The question is regrading PostgreSQL 8.0.26 version on Linux platform. I
> know that 8.0 version is no longer supported. But one of our customer is
> using this version.
> We are using File System based backup method to protect Postg
Hi
The question is regrading PostgreSQL 8.0.26 version on Linux platform. I
know that 8.0 version is no longer supported. But one of our customer is
using this version.
We are using File System based backup method to protect PostgreSQL server.
In PostgreSQL 8.2 and above versions, I can see that l
On Wed, 2010-03-17 at 10:41 -0400, Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop?
When you say "infinite" do you mean to say it never comes out of the
loop at all? Not sure if you are reporting a bug, or not.
Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop? While the
> first part of this select pg_start_backup(?label?) works without
> any issues??
pg_start_backup() is waiting for the archives to be stored. I would
lo
Out of curiosity, any idea why every time I run select pg_stop_backup(); it
goes into an infinite loop? While the first part of this select
pg_start_backup(‘label’) works without any issues??
Vitaly Burshteyn
Senior Network Engineer
Broadway.com, Theatre Direct International
729 7th
11 matches
Mail list logo
