Load e2e env from file

[ilidemi]

Remove the need for passing environment variables when running e2e locally

• [x] PG->CH
• [ ] MySQL->CH
• [ ] Mongo->CH

[codecov[bot]]

:x: 3 Tests Failed:

Tests completed	Failed	Passed	Skipped
1306	3	1303	131

View the top 2 failed test(s) by shortest run time

github.com/PeerDB-io/peerdb/flow/e2e::TestApiPg/TestCreateCDCFlowAttachConcurrentRequestsToxi

Stack Traces | 0.04s run time

=== RUN   TestApiPg/TestCreateCDCFlowAttachConcurrentRequestsToxi
=== PAUSE TestApiPg/TestCreateCDCFlowAttachConcurrentRequestsToxi
=== CONT  TestApiPg/TestCreateCDCFlowAttachConcurrentRequestsToxi
    api_test.go:1466: 
        	Error Trace:	.../flow/e2e/api_test.go:1466
        	Error:      	Received unexpected error:
        	            	failed to create postgres connection: failed to create connection: failed to connect to `user=postgres database=postgres`:
        	            		127.0.0.1:9902 (localhost): tls error: EOF
        	            		[::1]:9902 (localhost): tls error: EOF
        	            		127.0.0.1:9902 (localhost): failed to receive message: unexpected EOF
        	            		[::1]:9902 (localhost): failed to receive message: unexpected EOF
        	Test:       	TestApiPg/TestCreateCDCFlowAttachConcurrentRequestsToxi
    api_test.go:44: begin tearing down postgres schema api_x6ahg4il
--- FAIL: TestApiPg/TestCreateCDCFlowAttachConcurrentRequestsToxi (0.04s)

github.com/PeerDB-io/peerdb/flow/e2e::TestApiPg/TestDropCompletedAndUnavailable

Stack Traces | 0.05s run time

=== RUN   TestApiPg/TestDropCompletedAndUnavailable
=== PAUSE TestApiPg/TestDropCompletedAndUnavailable
=== CONT  TestApiPg/TestDropCompletedAndUnavailable
2025/10/29 06:02:31 INFO Received AWS credentials from peer for connector: ci x-peerdb-additional-metadata={Operation:FLOW_OPERATION_UNKNOWN}
2025/10/29 06:02:31 INFO Received AWS credentials from peer for connector: clickhouse x-peerdb-additional-metadata={Operation:FLOW_OPERATION_UNKNOWN}
2025/10/29 06:02:31 ERROR Failed to create connection x-peerdb-additional-metadata={Operation:FLOW_OPERATION_UNKNOWN} error="failed to connect to `user=postgres database=postgres`:\n\t127.0.0.1:9903 (localhost): tls error: EOF\n\t[::1]:9903 (localhost): tls error: EOF\n\t127.0.0.1:9903 (localhost): failed to receive message: unexpected EOF\n\t[::1]:9903 (localhost): failed to receive message: unexpected EOF"
2025/10/29 06:02:31 ERROR failed to create connection x-peerdb-additional-metadata={Operation:FLOW_OPERATION_UNKNOWN} error="failed to connect to `user=postgres database=postgres`:\n\t127.0.0.1:9903 (localhost): tls error: EOF\n\t[::1]:9903 (localhost): tls error: EOF\n\t127.0.0.1:9903 (localhost): failed to receive message: unexpected EOF\n\t[::1]:9903 (localhost): failed to receive message: unexpected EOF"
    api_test.go:732: 
        	Error Trace:	.../flow/e2e/api_test.go:732
        	Error:      	Received unexpected error:
        	            	failed to create postgres connection: failed to create connection: failed to connect to `user=postgres database=postgres`:
        	            		127.0.0.1:9903 (localhost): tls error: EOF
        	            		[::1]:9903 (localhost): tls error: EOF
        	            		127.0.0.1:9903 (localhost): failed to receive message: unexpected EOF
        	            		[::1]:9903 (localhost): failed to receive message: unexpected EOF
        	Test:       	TestApiPg/TestDropCompletedAndUnavailable
    api_test.go:44: begin tearing down postgres schema api_pu9kxe53
--- FAIL: TestApiPg/TestDropCompletedAndUnavailable (0.05s)

View the full list of 1 :snowflake: flaky test(s)

github.com/PeerDB-io/peerdb/flow/e2e::TestApiPg

Flake rate in main: 21.54% (Passed 102 times, Failed 28 times)

Stack Traces | 0s run time

=== RUN   TestApiPg
=== PAUSE TestApiPg
=== CONT  TestApiPg
--- FAIL: TestApiPg (0.00s)

To view more test analytics, go to the Test Analytics Dashboard _{📋 Got 3 mins? Take this short survey to help us improve Test Analytics.}