Skip to main content
commvault.com commvault.com
Answer

PostgreSQL index files restore

  • January 25, 2022
  • 6 replies
  • 77 views
M
Novice
Forum|alt.badge.img+13

Hi all

I am running a PostgreSQL restore and the DBA has mentioned that the index files haven’t restored on this particular restore process.

 

I’m doing a table level restore to another DB instance (out of place).
He mentioned a restore that was completed in December had the index files restored. I’m a bit at a loss as there is no option to allow this from what I can see. I also followed the identical restoration process as was done in December so I’m a little stumped.

Not sure if there is a simple solution to this? I am happy to log a support ticket bu thought I’d ask here first.

Thanks in advance.

Mauro

Best answer by Meera

Hi Mauro,

Database level or schema level restore restores index also. Table level doesn’t. What was the service pack level in December?

 

Regards,

Meera

    If you have a question or comment, please create a topic

    6 replies

    Meera
    Vaulter
    Forum|alt.badge.img+7
    • MeeraVaulter
    • Vaulter
    • January 25, 2022

    Hi Mauro, 

    Are you performing restore from dumpbased backup or block level backup? What is the service pack level of client? 

     

    Regards,

    Meera

    Meera
    M
    Novice
    Forum|alt.badge.img+13
    • MauroNovice
    • Author
    • Novice
    • January 25, 2022

    Hi Meera
     

    I’m doing a dumpbased backup/restore.
    I’m on V11.25.14 which was upgraded about 2 weeks ago.

    Regards,
    Mauro

    Meera
    Vaulter
    Forum|alt.badge.img+7
    • MeeraVaulter
    • Vaulter
    • Answer
    • January 25, 2022

    Hi Mauro,

    Database level or schema level restore restores index also. Table level doesn’t. What was the service pack level in December?

     

    Regards,

    Meera

    Meera
    M
    Novice
    Forum|alt.badge.img+13
    • MauroNovice
    • Author
    • Novice
    • January 25, 2022

    Hi Mauro,

    Database level or schema level restore restores index also. Table level doesn’t. What was the service pack level in December?

     

    Regards,

    Meera

    That makes more sense now.
    We were on V11.25.9 in December. 

    I’ll just check what we did then and give a quick update.

    Mike Struening
    M
    Novice
    Forum|alt.badge.img+13
    • MauroNovice
    • Author
    • Novice
    • January 27, 2022

    Hi Mauro,

    Database level or schema level restore restores index also. Table level doesn’t. What was the service pack level in December?

     

    Regards,

    Meera

    Thanks so much.

    I’ve tested both options with the results as expected, so I’ve let the DBA know on the difference.

    Mike Struening
    M
    Novice
    Forum|alt.badge.img+13
    • MauroNovice
    • Author
    • Novice
    • February 4, 2022

    @Meera May I ask a question regarding the table restore that was posted to me by the DBA?

    He wanted to find out if the functionality to restore the Indexes during a table level restore are going to be a feature in future releases or is this a PostgreSQL limitation?

    Thanks so much.

    Terms & ConditionsCookie settingsAccessibility statement