eele [mailto:da...@pgmasters.net]
Sent: Friday, December 04, 2015 6:26 PM
To: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbasebackup help
On 12/3/15 12:59 AM, Yelai, Ramkumar IN BLR STS wrote:
> What I wanted to achieve is simple copy of Data folder. I
On 12/3/15 12:59 AM, Yelai, Ramkumar IN BLR STS wrote:
What I wanted to achieve is simple copy of Data folder. I can't shutdown the
database during the backup and unable to use file system copy of data folder as
it creates inconsistency and don't want to use pg_dump.
Hence I decided to use Pg_
On 12/2/15 6:25 PM, Jim Nasby wrote:
On 12/2/15 1:56 PM, David Steele wrote:
>Also, I don’t want enable archive_mode = on as it needs to maintain
>archives files.
As it turns out, archiving would be the solution to your problem. If
you were archiving you could restore a*previous* backup and t
Maybe I'm just being picky here, but...
On 12/3/15 3:04 PM, Andreas Kretschmer wrote:
If you invoke pg_start_backup() before the copy, and pg_stop_backup()
>after the copy, then a file system copy is consistent.
The filesystem copy is not consistent, but because of how
pg_start/stop_backup w
> John R Pierce hat am 3. Dezember 2015 um 21:38
> geschrieben:
>
>
> On 12/2/2015 9:59 PM, Yelai, Ramkumar IN BLR STS wrote:
> > I can't shutdown the database during the backup and unable to use file
> > system copy of data folder as it creates inconsistency
>
> If you invoke pg_start_back
On 12/2/2015 9:59 PM, Yelai, Ramkumar IN BLR STS wrote:
I can't shutdown the database during the backup and unable to use file system
copy of data folder as it creates inconsistency
If you invoke pg_start_backup() before the copy, and pg_stop_backup()
after the copy, then a file system co
y understand correct? And am I doing the correct way to
backup.
Regards,
Ramkumar.
-Original Message-
From: David Steele [mailto:da...@pgmasters.net]
Sent: Thursday, December 03, 2015 1:27 AM
To: pgsql-general@postgresql.org; Yelai, Ramkumar IN BLR STS
Subject: Re: [GENERAL] Pgbaseba
On 12/2/15 1:56 PM, David Steele wrote:
>Also, I don’t want enable archive_mode = on as it needs to maintain
>archives files.
As it turns out, archiving would be the solution to your problem. If
you were archiving you could restore a*previous* backup and then replay
WAL to exactly T3. There m
On 11/30/15 6:28 AM, Yelai, Ramkumar IN BLR STS wrote:
> Hi All,
>
> I need some help in postgresql base backup.
>
> We are currently using multiple DBMS in our project and postgresql is
> one of them. Our private DBMS keeps the online data and postgresql keeps
> online as well as historical da
Hi All,
I need some help in postgresql base backup.
We are currently using multiple DBMS in our project and postgresql is one of
them. Our private DBMS keeps the online data and postgresql keeps online as
well as historical data.
At present, we are doing the backup/restore process for our proj
10 matches
Mail list logo
