equalant of msdb in sql server
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 ?
On 26 Nov 2017, at 17:54, chandra sekhar <sekhar.career@gmail.com> 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
On 27 November 2017 at 04:59, Daniel Gustafsson <daniel@yesql.se> wrote:
On 26 Nov 2017, at 17:54, chandra sekhar <sekhar.career@gmail.com>
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 logfiles 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 <craig@2ndquadrant.com> wrote:
Show quoted text
On 27 November 2017 at 04:59, Daniel Gustafsson <daniel@yesql.se> wrote:
On 26 Nov 2017, at 17:54, chandra sekhar <sekhar.career@gmail.com>
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 logfiles 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 <sekhar.career@gmail.com>
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
