pgxpool & GetSSLPassword

[jwc-clinnection]

I've looked all over and can't seem to find how to use pgxpool & GetSSLPassword. Would someone please help me? Thank you.

[jackc]

I suppose we could add a pgxpool.ParseConfigWithOptions, but at least for now I think you can use pgxpool.ParseConfig and then overwrite the ConnConfig field of the pgxpool.Config with pgx.ParseConfigWithOptions.

[jwc-clinnection]

Is this the correct way of using GetSSLPassword with pgxpool? Thank you in advance.

func getSslPassphrase(ctx context.Context) string {
	return "ssl_passphrase"
}

func main() {
	url := "postgres://username:password@localhost:5432/database_name"

	parseConfigOptions := pgconn.ParseConfigOptions{
		GetSSLPassword: getSslPassphrase,
	}

	configWithOptions, _ := pgconn.ParseConfigWithOptions(url, parseConfigOptions)

	config := pgxpool.Config{
		ConnConfig: &pgx.ConnConfig{
			Config: *configWithOptions,
		},
	}

	conn, err := pgxpool.NewWithConfig(context.Background(), &config)
	if err != nil {
		fmt.Fprintf(os.Stderr, "Unable to connect to database: %v\n", err)
		os.Exit(1)
	}
}

[jackc]

Close, but the pgxpool.Config and pgx.ConnConfig need to be created with a Parse* function. This is to ensure that default fields are set properly.

I would suggest getting it to work with a single pgx.Conn before getting attempting to get it to work with a pgxpool.Pool.