Обсуждение: Re: equalant of msdb in sql server
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, there isn't.
-- Craig Ringer http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
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 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, there isn't.
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
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 http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
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