Redshift Endpoint Outdated

0

I noticed that the endpoint associated with my redshift cluster is outdated. Currently it ends with the name of the database that I first created the cluster with, but I have since renamed that database and now the endpoint doesn't work anymore unless I manually change it. Is there any way to permanently refresh it to make sure it doesn't become outdated again?

질문됨 2년 전253회 조회
1개 답변
0

In this case, you need to specify the new database by yourself.

I assume you want to change the "dbName" in the "Endpoint" displayed in Redshift console's "General information". Endpoint example:

# provisioned
my-cluster.xxx.<region>.redshift.amazonaws.com:<port>/<dbName>
# serverless
my-workgroup.<accountid>.<region>.redshift-serverless.amazonaws.com:<port>/<dbName>

The <dbName> is displaying the name of initial database when you create a cluster or a namespace and it cannot be changed after creation for both provisoned and serverless. Description for dbName is in following document and AFAIK there are no apis to update this.

DBName -> (string)

The name of the initial database that was created when the cluster was created. This same name is returned for the life of the cluster. > If an initial database was not specified, a database named dev dev was created by default.

dbName -> (string)

The name of the first database created in the namespace.

Therefore, as you mentioned, the database name in the endpoint will be outdated if you alter or drop the initial database.

AWS
Yota_H
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠