How do I connect Postgres locally (local host) on Linux? #70872

RealNath · 2025-12-11T18:59:34Z

RealNath
Dec 11, 2025

Hi, sorry for the beginner question. Basically, I'm told to use this tool by my university as a preparation for an assignment. This is my first time using the tool. The thing is, I can't use host.docker.internal since it's not Windows/Mac (Failed to save Postgres_Source1 due to the following error: State code: 08001; Message: The connection attempt failed.).

localhost doesn't work directly since it's a Docker container too (Failed to save Postgres_Source1 due to the following error: State code: 08001; Message: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

So I used 172.17.0.1, but I got this error instead (Failed to save Postgres_Source1 due to the following error: Message: HikariPool-1 - Connection is not available, request timed out after 10001ms (total=0, active=0, idle=0, waiting=0)). Here's the log message:

2025-12-12 01:57:41 info 
2025-12-12 01:57:41 info Transitioning workload to running state
2025-12-12 01:57:41 info ----- START CHECK -----
2025-12-12 01:57:41 info 
2025-12-12 01:57:41 info Workload successfully transitioned to running state
2025-12-12 01:57:50 info Connector exited, processing output
2025-12-12 01:57:50 info Output file jobOutput.json found
2025-12-12 01:57:50 info Connector exited with exit code 0
2025-12-12 01:57:50 info Reading messages from protocol version 0.2.0
2025-12-12 01:57:50 info INFO main i.a.i.s.p.PostgresSource(main):750 starting source: class io.airbyte.integrations.source.postgres.PostgresSource
2025-12-12 01:57:50 info INFO main i.a.c.i.b.IntegrationCliParser$Companion(parseOptions):144 integration args: {check=null, config=/config/connectionConfiguration.json}
2025-12-12 01:57:50 info INFO main i.a.c.i.b.IntegrationRunner(runInternal):130 Running integration: io.airbyte.cdk.integrations.base.ssh.SshWrappedSource
2025-12-12 01:57:50 info INFO main i.a.c.i.b.IntegrationRunner(runInternal):131 Command: CHECK
2025-12-12 01:57:50 info INFO main i.a.c.i.b.IntegrationRunner(runInternal):132 Integration config: IntegrationConfig{command=CHECK, configPath='/config/connectionConfiguration.json', catalogPath='null', statePath='null'}
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword group - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword always_show - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword pattern_descriptor - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword display_type - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword min - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword max - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 warn WARN main c.n.s.UnknownKeywordFactory(lambda$getKeyword$0):37 Unknown keyword groups - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword or if it should generate annotations AnnotationKeyword
2025-12-12 01:57:50 info INFO main i.a.c.i.b.s.SshTunnel$Companion(getInstance):424 Starting connection with method: NO_TUNNEL
2025-12-12 01:57:50 info INFO main i.a.i.s.p.PostgresUtils(isCdc):70 using CDC: false
2025-12-12 01:57:50 info INFO main i.a.i.s.p.PostgresSource(toSslJdbcParamInternal):976 DISABLED toSslJdbcParam disable
2025-12-12 01:57:50 info INFO main c.z.h.HikariDataSource(<init>):79 HikariPool-1 - Starting...
2025-12-12 01:57:50 info INFO main c.z.h.HikariDataSource(<init>):81 HikariPool-1 - Start completed.
2025-12-12 01:57:50 info INFO main c.z.h.HikariDataSource(close):349 HikariPool-1 - Shutdown initiated...
2025-12-12 01:57:50 info INFO main c.z.h.HikariDataSource(close):351 HikariPool-1 - Shutdown completed.
2025-12-12 01:57:50 info INFO main i.a.c.i.b.IntegrationRunner(runInternal):224 Completed integration: io.airbyte.cdk.integrations.base.ssh.SshWrappedSource
2025-12-12 01:57:50 info INFO main i.a.i.s.p.PostgresSource(main):752 completed source: class io.airbyte.integrations.source.postgres.PostgresSource
2025-12-12 01:57:50 info Checking for optional control message...
2025-12-12 01:57:50 info Optional control message not found. Skipping...
2025-12-12 01:57:50 info Writing output of decd338e-5647-4c0b-adf4-da0e75f5a750_043e643b-0927-4211-8de5-907f55c437e5_0_check to the doc store
2025-12-12 01:57:50 info Marking workload decd338e-5647-4c0b-adf4-da0e75f5a750_043e643b-0927-4211-8de5-907f55c437e5_0_check as successful
2025-12-12 01:57:50 info Deliberately exiting process with code 0.
2025-12-12 01:57:50 info 
2025-12-12 01:57:50 info ----- END CHECK -----
2025-12-12 01:57:50 info

For the life of me, I can't figure out how to connect PostgreSQL. I'm at a loss. How am I supposed to run PostgreSQL locally using Linux?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

How do I connect Postgres locally (local host) on Linux? #70872

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

How do I connect Postgres locally (local host) on Linux? #70872

Uh oh!

Uh oh!

RealNath Dec 11, 2025

Replies: 0 comments

RealNath
Dec 11, 2025