Modifying UNIX User Name for a PostgreSQL Instance

Updated

If you want to use an instance as a restore destination (without backing up the instance), you can manually modify the user name.

On a UNIX platform, the UNIX user name is set for an instance during a full backup of an FSbased backupset. The user name is the operating system user that owns the PostgreSQL data, tablespaces, and archive log directories.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The database Overview page appears.

  2. Go to the Instances tab.

  3. Click an instance.

    The instance page appears.

  4. On the Overview tab, in the General tile, click Edit.

    The Edit PostgreSQL instance dialog box appears.

  5. Under the Connection details section, in the UNIX user name box, change the user name.

  6. Click Update.

Was this page helpful?