The AnyDAC native driver supports PostgreSQL Server version 7.4 and higher, because it requires a PG protocol 3.0 connection. 

AnyDAC requires the LIBPQ.DLL x86 or x64 client library for connecting to the PostgreSQL server. Ideally, the version should be equal to the server version. The full set of the v 9.0 client files:

• libpq.dll
• ssleay32.dll
• libeay32.dll
• libintl-8.dll
• libiconv-2.dll

You can take them from the server (details) installation Bin folder and put into a folder:

• listed in your PATH environment variable;
• your application EXE folder;
• any other folder and specify in AnyDAC\DB\ADDrivers.ini:

[PG]
VendorLib=<folder>\libpq.dll

When the PostgreSQL client library has not been properly installed, then you will get an exception when you try to connect: 

[AnyDAC][Phys][PGSQL]-314. Cannot load vendor library [LIBPQ.DLL]. The specified module could not be found.
Check [LIBPQ.DLL], which is located in one of the PATH directories or in application EXE directory.

or 

The ordinal Nnn could not be located in the dynamic link library SSLEAY32.dll.

AnyDAC requires:

• the libpq.so x86 or x64 client library.

To install on Linux use the commands: 

sudo apt-get update

sudo apt-get install libpq-dev

AnyDAC requires:

• the libpq.dylib x86 client library.

It comes preinstalled on Mac OS X or may be installed separately (more). 

To link the driver:

• drop a TADPhysPgDriverLink component from the "AnyDAC Links" palette page;
• or include the uADPhysPG unit into an uses clause.

To connect to a PostgreSQL DBMS, most applications will need to specify DriverID, Server, Database, User_Name, Password, CharacterSet. 

DriverID=PG  

Parameter	Description	Example value
Server	The TCP/IP address or host name of the server running a PostgreSQL server.	127.0.0.1
Port	The TCP/IP port on which PostgreSQL server is listening.	5432
Database	Name of the current database for the connection. If the Database is not specified, no current database is set up.	MyDB
User_Name	The PostgreSQL user ID.	postgres
Password	The PostgreSQL user password.
CharacterSet	The default character set for the connection. See the Character Set Support chapter for details.	WIN1251
LoginTimeout	Controls the amount of time (in seconds) an application waits for a connection attempt to timeout while waiting to establish a connection.	30
ExtendedMetadata	Controls the extended describing of the query result sets: True - AnyDAC describes a result set to get all the possible column attributes - is nullable, is auto incrementing, to which domain belongs, etc. Setting this option to True, slightly slows down a dataset opening. False - AnyDAC uses the restricted information about the query columns (default).	False
OidAsBlob	Controls the interpretation of an OID column in a table: No - an OID column is a dtUInt32 column (contains unsigned integer values); Yes - an OID column is a dtHBlob column (contains Large Object values); Choose - if a query selects a data from the dictionary tables or a column is not of a LO, LargeObject or BLOB domain, then an OID column is a dtUInt32 one, otherwise - dtHBlob one. The ExtendedMetadata option must be True to get a column domain (default).	Yes
UnknownFormat	Controls the handling of an unknown PostgreSQL data type: Error - raise the exception "Cannot describe type" (default); BYTEA - represent as a BLOB value.	BYTEA
ApplicationName	Name of the application. If specified, this value is stored in the pg_stat_activity table, application_name column.	AllBooks
PGAdvanced	Additional PostgreSQL server connection options. See the Database Connection Control Functions chapter PQconnectdb paragraph for details. A value format is - <option>=<value>[;...].
MetaDefSchema	Default schema name. Design time code will exclude the catalog name from the object name, if it is equal to MetaDefSchema. Setting MetaDefSchema does not change the current schema search path in PostgreSQL session. A 'public' is the default value.	MySchema

• Connect to a server running locally, listening on the default (5432) port:

DriverID=PG
Database=addemo

• Connect to a remote server, listening on a non-default port, using Unicode for character data:

DriverID=PG
Server=pgsrv
Port=5433
Database=addemo
CharacterSet=utf8
MetaDefSchema=MySchema
ExtendedMetadata=True

Common connection parameters, uADPhysPG Namespace, FAQs, How to configure AnyDAC Drivers, How to manage AnyDAC Connection Definitions