Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add settings for shared credentials file and config #70

Open
marcoslot opened this issue Nov 6, 2024 · 0 comments
Open

Add settings for shared credentials file and config #70

marcoslot opened this issue Nov 6, 2024 · 0 comments

Comments

@marcoslot
Copy link
Collaborator

It's a bit unusual to configure PostgreSQL extensions via environment variables. It would be nice if there were GUCs corresponding to AWS_SHARED_CREDENTIALS_FILE and AWS_CONFIG_FILE.

aykut-bozkurt added a commit that referenced this issue Nov 27, 2024
To make it more Postgres way, we define 3 s3 related GUCs.

- `pg_parquet.aws_config_file`: an absolute path to the configuration file used by s3 client. Note that when set,
   the GUC overrides `AWS_CONFIG_FILE` environment variable. By default the GUC is unset,
- `pg_parquet.aws_shared_credentials_file`: an absolute path to the shared credentials file used by s3 client.
   Note that when set, the GUC overrides `AWS_SHARED_CREDENTIALS_FILE` environment variable. By default the GUC is unset,
- `pg_parquet.aws_profile`: the profile name used by s3 client. Note that when set, the GUC overrides `AWS_PROFILE`
   environment variable. By default the GUC is unset.

These GUCs can only be set by a superuser. You can easily set these GUCs to use different configurations per session.
You do not need to restart your session to change the config file, shared credentials file or profile name.

Closes #70.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant