To convert a client application to use a Postgres database, you must modify the connection properties to specify the new target database. In the case of a Java application, change the JDBC driver name (Class.forName) and JDBC URL.Converting an ODBC application to connect to an instance of Postgres is a two-step process. To connect an ODBC application:
1. Most Linux and Windows systems include graphical tools that allow you to create and edit ODBC data sources. After installing ODBC, check the Administrative Tools menu for a link to the ODBC Data Source Administrator. Click the Add button to start the Create New Data Source wizard; complete the dialogs to define the new target data source.The application will contain a call to SQLConnect (or possibly SQLDriverConnect); edit the invocation to change the data source name. In the following example, the data source is named "OracleDSN":To connect to an instance of Postgres defined in a data source named "PostgresDSN", change the data source name:After establishing a connection between the application and the server, test the application to find any compatibility problems between the application and the migrated schema. In most cases, a simple change will resolve any incompatibility that the application encounters. In cases where a feature is not supported, use a workaround or third party tool to provide the functionality required by the application. See , Migration Issues, for information about some common problems and their workarounds.