Results 1 to 4 of 4
  1. #1
    Join Date
    May 2016
    Posts
    3

    Unanswered: postgres equivalent for oracle's v$archived_log

    Hi,

    Can anyone tell me if there is a dictionary view in Postgres that shpws you what the timestamp is of a specific WAL file?
    Or could you please point me in the ricght direction ( e.g. internal documentation)? I can't seem to find this information on the Postgres site.

    Thanks in advance.
    Regards,
    Mariane

  2. #2
    Join Date
    Nov 2003
    Posts
    2,914
    Provided Answers: 8
    Are you maybe looking for pg_stat_archiver?

    https://www.postgresql.org/docs/curr...-ARCHIVER-VIEW
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    May 2016
    Posts
    3
    Hi Shammat,

    I'm looking for a view that shows the history of the wal files with the timestamps that they were made.
    Is there a view like that?

    Thanks in advance.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,914
    Provided Answers: 8
    No, I don't think that is saved anywhere. That information is available if you simply check the target directory for your archive command.

    In theory you could extend the archive command to insert a row into a database table each time a WAL file is archived.

    Another option is to make the archive directory available as a symlink in the data directory and then use e.g. pg_ls_dir() to list the files in the directory through SQL.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •