Save Passwords in Separate File

I used to save my DbConsole scripts in a GIT project, including the init.sql file with the database connections. There was a problem with the passwords: I didn't want the passwords to get listed into GIT. Therefore DbConsole allow to save a separate file, with passwords. It the file can be .pgpass in the user home directory or passwords.txt in home directory/.dbconsole. The file format is the same as Postgres pgpass

hostname:port:database:username:password
For example the password is 'secret' for all hosts, port 1521 user postgres.
*:1521:sakila:postgres:secret

Navigation