Ajustando o Fuso Horario do banco de dados

--Check if you have the timezone set
SHOW TIMEZONE;

-- Ver a hora agora
select * from now ();

--If not set the timezone
SET TIMEZONE='America/Manaus';
--alter database  "dbCONTTRADE" set timezone to  'America/Manaus'


--
SELECT
     *
FROM pg_timezone_names
where utc_offset = '-04:00:00'