[PostgreSQL] How to exit from PostgreSQL command line utility: psql (psql 종료 방법)

Type \q

[PostgreSQL] Install PostgreSQL

1.Install Server & Libraries

#> yum -y install postgresql-server postgresql-contrib

2. Initialize database

#> postgresql-setup initdb

3. Edit configuration

#> su - postgres
$> cd data
$> vi pg_hba.conf

TYPE    DATABASE  USER    ADDRESS         METHOD
host    all       all     127.0.0.1/32    md5
host    all       all     192.168.0.0/24  md5
host    all       all     0.0.0.0/0       md5

$> vi postgresql.conf

4. Start server

#> systemctl start postgresql
#> systemctl status postgresql

5. Create DB

#> su - postgres
$> createdb [DB_NAME]

6. Create user and grant privilege

$> psql -s [DB_NAME]
$> create user [USER_NAME] password '[PASSWORD]';
$> GRANT ALL PRIVILEGES ON DATABASE [DB_NAME] TO [USER_NAME];

[JDBC] PostgreSQL JDBC Driver Properties

PostgreSQL JDBC Driver

Property Name	Description	Reqired	Choices	Sample Value
PGDBNAME	Database name to connect to; may be specified directly in the JDBC URL.	true		null
user	Username to connect to the database as.	true		bizteco
PGHOST	Hostname of the PostgreSQL server; may be specified directly in the JDBC URL.	false		null
PGPORT	Port number to connect to the PostgreSQL server on; may be specified directly in the JDBC URL.	false		null
password	Password to use when authenticating.	false		btc7btc
protocolVersion	Force use of a particular protocol version when connecting; if set, disables protocol version fallback.	false		null
ssl	Control use of SSL; any nonnull value causes SSL to be required.	false		null
sslfactory	Provide a SSLSocketFactory class when using SSL.	false		null
sslfactoryarg	Argument forwarded to constructor of SSLSocketFactory class.	false		null
loglevel	Control the driver's log verbosity: 0 is off, 1 is INFO, 2 is DEBUG.	false	0 1 2	null
allowEncodingChanges	Allow the user to change the client_encoding variable.	false		null
logUnclosedConnections	When connections that are not explicitly closed are garbage collected, log the stacktrace from the opening of the connection to trace the leak source.	false		null
prepareThreshold	Default statement prepare threshold (numeric).	false		null
binaryTransfer	Use binary format for sending and receiving data if possible.	false		null
binaryTransferEnable	Comma separated list of types to enable binary transfer. Either OID numbers or names.	false		null
binaryTransferDisable	Comma separated list of types to disable binary transfer. Either OID numbers or names. Overrides values in the driver default set and values set with binaryTransferEnable.	false		null
charSet	When connecting to a pre-7.3 server, the database encoding to assume is in use.	false		null
compatible	Force compatibility of some features with an older version of the driver.	false	7.1 7.2 7.3 7.4 8.0 8.1 8.2	null
loginTimeout	The login timeout, in seconds; 0 means no timeout beyond the normal TCP connection timout.	false		null
socketTimeout	The timeout value for socket read operations, in seconds; 0 means no timeout.	false		null
tcpKeepAlive	Enable or disable TCP keep-alive probe.	false		null
stringtype	The type to bind String parameters as (usually 'varchar'; 'unspecified' allows implicit casting to other types)	false	varchar unspecified	null
kerberosServerName	The Kerberos service name to use when authenticating with GSSAPI. This is equivalent to libpq's PGKRBSRVNAME environment variable.	false		null
jaasApplicationName	Specifies the name of the JAAS system or application login configuration.	false		null