While trying to run metasploit in arch linux im getting
[root@archserver ~]# msfconsole
[-] Failed to connect to the database:
PG::InvalidParameterValue: ERROR: invalid value for parameter
"TimeZone": "UTC" : SET time zone 'UTC'
Postgres configuration is done and db is also created
My database.yml is
production:
adapter: postgresql
database: msf
username: root
password: root
host: localhost
port: 5432
pool: 5
timeout: 5
Fixed it by editing SET time zone 'UTC' in /opt/metasploit/vendor/bundle/ruby/2.4.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb