DSN - PostgreSLQ dsn it's basically a string like 'field1=value
field2=value' fields are describe below (from the pgsql Programmer's
Manual):
host
Name of host to connect to. If this begins with a slash, it
specifies Unix-domain communication rather than TCP/IP communication;
the value bis the name of the directory in which the socket file is
stored. The default is to connect to a Unix-domain socket in /tmp.
hostaddr
IP address of host to connect to. This should be in standard
numbers-and-dots form, as used by the BSD functions inet_aton et al. If
a nonzero-length string is specified, TCP/IP communication is used.
Using hostaddr instead of host allows the application to avoid a
host name look-up, which may be important in applications with time
constraints. However, Kerberos authentication requires the host name.
The following therefore applies. If host is specified without hostaddr,
a host name lookup is forced. If hostaddr is specified without host,
the value for hostaddr gives the remote address; if Kerberos is used,
this causes a reverse name query. If both host and hostaddr are
specified, the value for hostaddr gives the remote address; the value
for host is ignored, unless Kerberos is used, in which case that value
is used for Kerberos authentication. Note that authentication is likely
to fail if libpq is passed a host name that is not the name of the
machine at hostaddr.
Without either a host name or host address, libpq will connect using
a local Unix domain socket. port
Port number to connect to at the server host, or socket file name
extension for Unix-domain connections.
dbname
The database name.
user
User name to connect as.
password
Password to be used if the server demands password
authentication.
options
Trace/debug options to be sent to the server.
tty
A file or tty for optional debug output from the backend.
requiressl
Set to 1 to require SSL connection to the backend. Libpq will then
refuse to connect if the server does not support SSL. Set to 0
(default) to negotiate with server.
example= 'host=localhost dbname=test user=test'
-
- Overrides:
datasource.datasource_base.__init__
|