How to run pg_timetable without password

[ashx1901]

Hi,

Is there any way we can run pg_timetable without password.

Thanks

[pashagolub]

Hello,

sure. You can use $PGTT_PGPASSWORD environment variable, e.g.

$> PGTT_PGPASSWORD=mystrongkungfu pg_timetable postgresql://[email protected]/mydatabase

[prensgold]

Hello Pavlo ,

Where am I making a mistake here?

[postgres@lprdgovtb07 ~]$ PGTT_PGPASSWORD=Londra_123
[postgres@lprdgovtb07 ~]$ pg_timetable -c goperf postgresql://postgres@localhost/postgres
2023-09-23 00:52:16.394 [INFO] [sid:2121935134] Starting new session...
2023-09-23 00:52:16.399 [ERROR] [database:postgres] [err:failed to connect to host=localhost user=postgres database=postgres: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)] [host:localhost] [port:5432] [time:5.245965ms] Connect
2023-09-23 00:52:16.399 [ERROR] [error:failed to connect to host=localhost user=postgres database=postgres: dial error (dial tcp [::1]:5432: connect: cannot assign requested address)] Connection failed
2023-09-23 00:52:16.399 [INFO] Sleeping before reconnecting...
^C2023-09-23 00:52:18.273 [ERROR] [error:context canceled] Connection failed

[prensgold]

When I run it this way, it works.
pg_timetable -c goperf postgresql://postgres:$PGTT_PGPASSWORD@localhost/postgres

That way, the password appears in the processes.
The visibility of the password in .pgpass and processes is a problem in security vulnerabilities.

How can I get over this?
[postgres@lprdgovtb07 data]$ ps -ef |grep timetable
postgres 2472915 2457459 0 00:58 pts/1 00:00:00 pg_timetable -c goperf postgresql://postgres:Londra_123@localhost/postgres

[pashagolub]

Hello,

it sounds like a problem with network environment. Are you running in docker? Can this be an issue?

Another guess would be IPv4 vs IPv6 mess. pg_tt tries to connect to IPv6 localhost [::1]:5432, is it enabled? Can you try 127.0.0.1 instead?