---
title: "Set up DataSync Agent to share to PostgreSQL"
canonical: "https://docs.perspectium.com/space/helium/2113330/Set%20up%20DataSync%20Agent%20to%20share%20to%20PostgreSQL"
format: markdown
---
You can configure your  DataSync Agent  to share data from ServiceNow or Salesforce to a PostgreSQL database by changing some additional  configurations in your  agent.xml  file .  Prerequisites  First, you will need to  Install the DataSync Agent .  You will also need to  create a ServiceNow dynamic share/bulk share .   Make sure to  stop running your DataSync Agent  before making any Agent configuration changes.   Finally, you will need to create a database in PostgreSQL that will store data replicated via the DataSync Agent. Procedure To set up your  DataSync Agent  to share application data to a PostgreSQL database, follow these steps: Additional Configurations For optional configurations for how the DataSync Agent interacts with your PostgreSQL database. Contact  Perspectium Support  if you have any questions. By default, the DataSync Agent will set datetime fields with the  timestamp  data type which will not have a time zone. The PostgreSQL JDBC driver as used by the Agent does not support a time zone parameter so any datetime values are passed in based on the time zone of the server where the Agent is running. If you are running the Agent on a server with a non-UTC time zone and want to ensure records are saved properly so you can query the PostgreSQL database in different time zones, do the following:  Since ServiceNow's data is sent out is in UTC time, doing the above ensures data is saved properly in UTC time in the database. You can now query in different time zones by using the  SET TIME ZONE '<TIME ONE>';  SQL command where  <TIME ZONE>  is the desired time zone to query in.  For example:  SET TIME ZONE 'US/Eastern'; Will allow you to query for records in the US Eastern Timezone. See  SET  for more information.   NOTE :  Using SET only applies the time zone for the current session. Contact your Database/System Administrator to change the default time zone for your PostgreSQL environment as this may require modifying the postgresql.conf main configuration file and restarting the PostgreSQL service.