Blu Age L3 Workshop AppStream 2.0-Error when trying to install local database server

The error you're encountering is likely related to how AppStream 2.0 manages user profiles and persistent storage. The D: drive, which is typically used for persistent storage in AppStream 2.0, may not be available or configured correctly in your current session.

To resolve this issue, try the following steps:

1. Verify that you're using the AppStream 2.0 client and not accessing the environment through a web browser, as the client provides better support for persistent storage.

2. Check if the D: drive is present in your session by opening File Explorer.

3. If the D: drive is not present, the persistent storage feature may not be enabled for your AppStream 2.0 fleet. Contact your AWS administrator to ensure that persistent storage is properly configured.

4. If the D: drive is present but the PhotonUser folder is missing, try creating the folder structure manually using these commands:

   mkdir D:\PhotonUser mkdir D:\PhotonUser\Workshop mkdir D:\PhotonUser\Workshop\postgresql-data

5. After creating the directory structure, try running the pg_ctl initdb command again.

6. If you're still encountering issues, you might need to modify the %WORKSHOP_POSTGRESQL_DATA_HOME% environment variable to point to a location that definitely exists, such as C:\Users\PhotonUser\Workshop\postgresql-data. You can do this with the following command:

   setx WORKSHOP_POSTGRESQL_DATA_HOME C:\Users\PhotonUser\Workshop\postgresql-data

   After changing the environment variable, close and restart your command prompt before trying the pg_ctl initdb command again.

If these steps don't resolve the issue, you may need to reach out to your AWS administrator or AWS support for further assistance, as there might be specific configurations or limitations in your AppStream 2.0 environment causing this problem.

Regarding pgAdmin, it's not typically pre-installed in AppStream 2.0 environments. If you need pgAdmin, you may need to install it separately or use an alternative method to manage your PostgreSQL database, such as command-line tools or other management interfaces provided in your workshop environment.
Sources
Blu Age L3 Workshop AppStream - Start Local Database Server not running | AWS re:Post