Re: equalant of msdb in sql server

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: equalant of msdb in sql server

Craig Ringer-3
On 27 November 2017 at 04:59, Daniel Gustafsson <[hidden email]> wrote:
> On 26 Nov 2017, at 17:54, chandra sekhar <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: equalant of msdb in sql server

sql2pg
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 <[hidden email]> wrote:
On 27 November 2017 at 04:59, Daniel Gustafsson <[hidden email]> wrote:
> On 26 Nov 2017, at 17:54, chandra sekhar <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: equalant of msdb in sql server

Craig Ringer-3
On 27 November 2017 at 12:10, chandra sekhar <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: equalant of msdb in sql server

John R Pierce
In reply to this post by sql2pg
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