PostgreSQL is a leading object-relational database management system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.
Google Contacts, the address book built into Gmail, lets you easily keep everyone's details in one place. It helps you sync your contacts and keep them up-to-date across all your devices so you always have access to the right information.Google Contacts Integrations
Google Contacts + Follow Up BossCreate or update Follow Up Boss Contacts Automatically from Your Google Contacts Read More...
Gmail + Google ContactsCreate or update contacts in Google Contacts from new Gmail emails Read More...
If you often use Gmail, and you want to keep your contacts up to date. You just need to connect your Gmail to Google Contacts and save all your Gmail contacts in it. Appy Pie Connect allows you to sync your Gmail account with Google Contacts without any coding. Once you set it up, Appy Pie Connect will automatically watch your Gmail account for emails, sending new contacts to Google Contacts to create a contact or update an existing one, keeping up with all your communication from then on.
Agendor + Google ContactsCreate a new contact in Google Contacts for every new people in Agendor Read More...
EngageBay + Google ContactsAdd your EngageBay contacts to your Google Contacts Read More...
Freshworks CRM + Google ContactsCreate contacts in Google Contacts from new Freshworks CRM contacts Read More...
It's easy to connect PostgreSQL + Google Contacts without coding knowledge. Start creating your own business flow.
Triggered when you add a new column.
Triggered when you add a new row.
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
Triggers whenever a group is created.
Triggers when a contact is created or updated.
Adds a new row.
Updates an existing row.
Adds an existing contact to a group.
Creates a new contact.
PostgreSQL is the world’s most advanced open source database, with an unmatched track record of stability, reliability and performance. PostgreSQL is a powerful, open source relational database that is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages. It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, TIMESTAMP, INTERVAL, and more. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC. PostgreSQL is scalable from cell phones to supercomputers.
Google Contacts is a free service for storing contacts. You can use it to store your personal contacts or business ones. Through Google Contacts you can search info about your contacts; edit their information; see their photos and events in your calendar; send them messages and emails; and share contacts between several Google services. Your Google Contacts are available from any computer connected to the Internet having a web browser. You can add and edit your own Google Contacts or manage those of other users on your domain. You can also use Google Contacts as part of other Google services.
There are many options for integration of Google Contacts and PostgreSQL. The easiest way to integrate them is via using x2vnc top. x2vnc allows you to access your screen remotely (and not only. and contrp it using the mouse and keyboard. To enable this functionality we need to start a vnc server on our machine which will be connected to the remote user through a ssh tunnel . This way we create a secure connection between local machine and it’s user and therefore we can safely transfer data between them. We also need a way to transfer data between PostgreSQL and Google Contacts since they don’t have any direct communication capabilities. This way comes in handy the program mentioned above – x2vnc – which will allow us to contrp our computer remotely but also transfer data between these two services mentioned above.
To achieve this goal we need to install x2vnc and vncserver packages on our machine. First of all we need to install x2vnc package – this package contains vncviewer executable which will allow us to connect to our virtual machine remotely. Then we need to install vncserver package which will allow us to run our own vnc server on our machine which will be used to establish a secure connection with remote user. If you are using Ubuntu or Debian distributions just enter fplowing command as root:
aptitude install x2vnc vncserver
If you are not using Debian based OS (e.g. you are using Red Hat based OS. then you can install both packages by entering fplowing commands in the terminal:
yum install vnc-server x2vnc
Now that we have installed both packages we need to prepare our machine for our setup. We need to create a new user for the remote user which will be connecting to our machine through a ssh tunnel so we need to do fplowing actions:
After creating new user we need to give it a password so it can log into our machine so we can start working with him/her remotely:
After that we are ready to start the process of integration of PostgreSQL and Google Contacts so we need to connect to our newly created user via an ssh tunnel so first of all let’s enable ssh server in Ubuntu or Debian OS by entering fplowing command as root:
update-rc.d ssh enable
and then enter fplowing command as root:
After that we need to make sure that there is no firewall blocking our ssh port because if there is a firewall enabled it will not allow us to connect via ssh tunnel so we need to make sure that there is no blocking rule by entering fplowing command as root:
iptables -L -n --line-numbers
Clear rules by entering fplowing command as root:
iptables -F -n --line-numbers
and then enter fplowing command as root:
ifdown eth0 && ifup eth0 && iptables -P FORWARD ACCEPT && iptables -F FORWARD
After that we need to configure terminal option by entering fplowing command as root:
Since this is the last step before connecting to the remote server we need to set the default shell for the remote user so we need to change /etc/passwd file so we need to edit /etc/passwd file by entering fplowing command as root:
and add :sh. line under the first cpumn where username appears like this:
The process to integrate PostgreSQL and Google Contacts may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.