Hello, i'm trying to configure the PostgreSQL workload protection using a protection plan and pgbackrest in a 11.1 domain but i can't find any guide about this. Also the PostgreSQL guide doesn't help, it mentions an universal share but doesn't tell anything about its configuration in the client.
I've created the share, exported it to the db host, installed the agent, discovered the databases and validated the credentials. What am i missing?
Thank you, regards,
Universal share concept is for dumping files inside it , for example SQL/oracle/Postgres, you will take backup and dump it there, and then you create a universal backup policy to fetch those data and back it up.
for Postgres, if you have support , open a case with support, I hope you get what you need from there.
now from what I have in my notes ( I have configured it only once):
-install the agent on the Postgres server.
-provide the required permission to the netbackup service account ( superuser)
-make sure the Postgres installed bin directory is available in environment variable
once you see the postgres under the workload in netbackup web UI, then you should be able to add it to a protection plan and take a backup of it( backup will be to MSDP and not to the universal share) , if it is failing, contact support, or provide more information about the error you are facing)
Thank you. for your reply.
The part i'm missing and i can't find in any guides, is the configuration on the share in the client. After exporting it and mounting it is it needed to do other activities to tell PostgreSQL to write there? This is the problem, no guide to follow.
Okai I see your point.
You have exported an unviersal share,mounted to the postgres server?correct?now you just have to take backup of your postgres database and save that dump file to universal share.
This can be treated like a NAS server (your univeral share folder)or you can dump it there,take backup of it (using universal policy)and remove the dump from it.
