On 11/26/2017 8:10 PM, chandra sekhar wrote:
What is the query to get list of the archive log files to capture
start date and time of each archive log
ls -l nfsserver:/path/to/archive
--
john r pierce, recycling bits in santa cruz
What is the query to get list of the archive log files to capture start
date and time of each archive log
On Sun, Nov 26, 2017 at 5:31 PM Craig Ringer wrote:
> On 27 November 2017 at 04:59, Daniel Gustafsson wrote:
>
>> > On 26 Nov 2017, at 17:54, chandra sekhar
>> wrote:
>> >
>> > sql server
On 27 November 2017 at 12:10, chandra sekhar
wrote:
> What is the query to get list of the archive log files to capture start
> date and time of each archive log
>
There isn't one.
You may be looking for a tool like PgBarman or other archive and backup
managers.
--
Craig Ringer
On 27 November 2017 at 04:59, Daniel Gustafsson wrote:
> > On 26 Nov 2017, at 17:54, chandra sekhar
> wrote:
> >
> > sql server has msdb database which stores the history of backups taken.
> > is there any table in postgres which keep track of when the archive log
> files are archived ?
>
No, t
> On 26 Nov 2017, at 17:54, chandra sekhar wrote:
>
> sql server has msdb database which stores the history of backups taken.
> is there any table in postgres which keep track of when the archive log files
> are archived ?
This is the mailinglist for the postgresql.org website, you are better o
