cancel
Showing results for 
Search instead for 
Did you mean: 

backup the postgreSQL procedure

Riadh_R17
Level 4

Hi,

I want to backup the postgreSQL using netbackup (DataStore policy)

I have installed the netbackup client and the postgreSQL agent on the client (connectivity between the master and client is ok)

what are next steps?

please clear procedure

thank you very much

8 REPLIES 8

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@Riadh_R17 

Apologies for asking, but have you tried the manual?

https://sort.veritas.com/DocPortal/pdf/129277259-137906532-1

 

Hi @Marianne 

Of course as a first reflex i tried the guide But it seems for me the procedure order is not clear.

for example, i dont find what shoud i enter in the backup selection.

What i have did is as below : 

1. install of the client

2. install of the agent

4. creating the password file

5. introducing database parameters in the nbpgsql.conf

6. creating symbolic link for libpq.so

7. copying the script pgsql_backup_script.txt  in /usr/bin  without modifying the content (as below)

#!/bin/sh

#bcpyrght
#***************************************************************************
#* $Copyright: Copyright (c) 2017 Veritas Technologies LLC. All rights reserved VT25-0977-2658-84-51-3 $ *
#***************************************************************************
#ecpyrght

#NOTE:This is sample script can be changed according to the environment

RETURN_STATUS=0

echo "Execute $CMD_LINE"
CMD_LINE="/usr/NBPostgreSQLAgent/nbpgsql -o backup"

echo "Execute $CMD_LINE"

su - root -c "$CMD_LINE"

RETURN_STATUS=$?

exit $RETURN_STATUS

This is what i have did.

Thanks 

 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@Riadh_R17 

'Of course'. Really? Did you say that?

With this attitude, I wish you luck....

!! 

I think my of course was missunderstanded.

It was a normal of course and kindly.

I was telling that as a first reflex i was passed by the guide before writing here. 

Sorry and thank you anyway.

Mike_Gavrilov
Moderator
Moderator
Partner    VIP    Accredited Certified

You didn't read the manual carefully as Marianne said:

The guide https://www.veritas.com/content/support/en_US/doc/129277259-129955710-0/v129903049-129955710 has that information:

You can schedule the PostgreSQL backups from the NetBackup Administration Console using the DataStore policy to call a backup script.

For more information, see https://www.veritas.com/support/en_US/article.100041371

 

Hello,

What if PostgreSQL was installed on a Docker Image? Can NBU back it up in this case?

If yes, what is the procedure? (I couldn't find anything on this manner in the user guide or online).

I tried creating a post on this but the answer was not clear regarding the NBU plugin for PostgreSQL (https://vox.veritas.com/t5/NetBackup/NetBackup-for-PostgreSQL-on-Docker-Image-How-to/m-p/885882#M247...).

All help is appreciated and thank you in advance.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@me-ver-91 

I have seen that a document was shared in your other post that explains various options to protect containerised applications.

@Marianne I just saw your reply on my other post as well. Thank you!