Table of Contents

Search

  1. Preface
  2. Introducing Administrator
  3. Organizations
  4. Licenses
  5. Ecosystem single sign-on
  6. SAML single sign-on
  7. Metering
  8. Source control and service upgrade settings
  9. Users and user groups
  10. User roles
  11. Permissions
  12. Runtime environments
  13. Serverless runtime environments
  14. Secure Agent services
  15. Secure Agent installation
  16. Schedules
  17. Bundle management
  18. Event monitoring
  19. File transfer
  20. Troubleshooting

Administrator

Administrator

Managing the PostgreSQL database on Windows

Managing the PostgreSQL database on Windows

Use binaries and utility scripts to manage the PostgreSQL database.
To manage the PostgreSQL database, you must log in as a user who does not have system administrator rights. A system administrator will be unable to run PostrgreSQL binaries and utility scripts.
Informatica has created some utility scripts based on PostgreSQL binaries. These utility scripts make it easier for you to manage the PostgreSQL database.
The following directories contain files for the PostgreSQL database:
  • PostgreSQL binaries:
    <Secure Agent installation directory>\apps\process-engine\data\db\postgresql-windows-x64-binaries\pgsql\bin
  • PostgreSQL utility scripts:
    <Secure Agent installation directory>\apps\process-engine\data\db\util
  • PostgreSQL logs:
    <Secure Agent installation directory>\apps\process engine\logs\PostGreSql\postgresql.log
  • PostgreSQL data:
    <Secure Agent installation directory>\apps\process engine\data\PostGreSql\Data
For more information about PostgreSQL scripts, see the PostgreSQL help at https://www.postgresql.org/docs/current/static/index.html.
Some of the following sections contain sample commands that use these default values:
  • Default database name: activevos
  • Default database user name: bpeluser
  • Default database password: bpel


Updated October 29, 2020