Re: equalant of msdb in sql server

2017-11-27 Thread John R Pierce 

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

Re: equalant of msdb in sql server

2017-11-27 Thread chandra sekhar 
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
>

Re: equalant of msdb in sql server

2017-11-27 Thread Craig Ringer 
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

Re: equalant of msdb in sql server

2017-11-26 Thread 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, there isn't.

-- 
 Craig Ringer   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: equalant of msdb in sql server

2017-11-26 Thread Daniel Gustafsson 
> 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 off
asking general postgres related questions on pgsql-general@ (cc:ed here).

cheers ./daniel