Skip to main content
Solved

PostgreSQL index files restore


Forum|alt.badge.img+14

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

View original
Did this answer your question?
If you have a question or comment, please create a topic

6 replies

Meera
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • 68 replies
  • 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


Forum|alt.badge.img+14
  • Author
  • Byte
  • 101 replies
  • 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
  • Vaulter
  • 68 replies
  • 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


Forum|alt.badge.img+14
  • Author
  • Byte
  • 101 replies
  • January 25, 2022
Meera wrote:

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.


Forum|alt.badge.img+14
  • Author
  • Byte
  • 101 replies
  • January 27, 2022
Meera wrote:

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.


Forum|alt.badge.img+14
  • Author
  • Byte
  • 101 replies
  • 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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings