IOTN :: Field Book :: PostgreSQL

ȸ¿ø°¡ÀÔ

/usr/bin/initdb -D /var/lib/pgsql/test [ Instance Ãß°¡ ]

ÃÖ±æÈ£ [LIST]   2021-11-05 10:14:46, Á¶È¸ : 106 -bash-4.1$ echo $PGDATA /var/lib/pgsql/data -bash-4.1$ ps -ef | grep $PGDATA postgres 23534     1  0 Nov04 ?        00:00:01 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data DB ¿î¿µÁß instance Ãß°¡ / port, DB À§Ä¡ ´Ù¸£¸é °¡´É -bash-4.1$ rm -rf /var/lib/pgsql/test -bash-4.1$ /usr/bin/initdb -D /var/lib/pgsql/test The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.UTF-8. The default database encoding has accordingly been set to UTF8. The default text search configuration will be set to "english". creating directory /var/lib/pgsql/test ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32MB creating configuration files ... ok creating template1 database in /var/lib/pgsql/test/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. Success. You can now start the database server using:     /usr/bin/postgres -D /var/lib/pgsql/test or     /usr/bin/pg_ctl -D /var/lib/pgsql/test -l logfile start -bash-4.1$ vi /var/lib/pgsql/test/postgresql.conf listen_addresses = '*' port = 5433 -bash-4.1$ /usr/bin/pg_ctl -D /var/lib/pgsql/test -l logfile start server starting -bash-4.1$ psql -h localhost -p 5433 psql (8.4.20) Type "help" for help. postgres=# \l                                   List of databases    Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges   -----------+----------+----------+-------------+-------------+----------------------- postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres                                                              : postgres=CTc/postgres template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres                                                              : postgres=CTc/postgres (3 rows) postgres=# \du             List of roles Role name | Attributes  | Member of -----------+-------------+----------- postgres  | Superuser   | {}            : Create role              : Create DB     postgres=# \q -bash-4.1$ pg_ctl stop -D /var/lib/pgsql/test waiting for server to shut down.... done server stopped 3.239.112.140

LIST

CategoryAdminTroubleshoot	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Admin	odbc_fdw test	ÃÖ±æÈ£	2021/11/22	138
Admin	ERROR: cross-database references are not implemented / postgres_fdw / psql dblink	ÃÖ±æÈ£	2021/11/15	185
Admin	CREATE EXTENSION postgres_fdw; [ source install ]	ÃÖ±æÈ£	2021/11/15	292
Admin	psql [ 8.4.20 , 8.4.22 ] ¿©·¯ Version ¿î¿µ, upgrade 8.4.20 to 8.4.22 [ µÚ Version ´Ù¸£¸é ±×³É ½ÃÀÛ ]	ÃÖ±æÈ£	2021/11/12	116
Admin	source make install [ 8 ~ 14 ]	ÃÖ±æÈ£	2021/11/11	171
Admin	psql odbc make install	ÃÖ±æÈ£	2021/11/09	134
Admin	oracle to psql dblink	ÃÖ±æÈ£	2021/11/09	155
Admin	/usr/bin/initdb -D /var/lib/pgsql/test [ Instance Ãß°¡ ]	ÃÖ±æÈ£	2021/11/05	106
Troubleshoot	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?	ÃÖ±æÈ£	2021/11/04	168
Troubleshoot	ERROR: current transaction is aborted, commands ignored until end of transaction block; [ postgresql-odbc upgrade ]	ÃÖ±æÈ£	2021/11/04	183
Troubleshoot	pg_ctl start $PGDATA/pg_log/ ÇѱÛ/¿µ¾î ¸Þ¼¼Áö [ $PGDATA/postgresql.conf lc_messages ]	ÃÖ±æÈ£	2021/10/29	205
Admin	pg_dumpall pg_upgrade	ÃÖ±æÈ£	2021/10/21	149
Admin	Åë°èÁ¤º¸	ÃÖ±æÈ£	2021/10/21	124
Admin	pg_dump / pg_restore[ psql (8.4.20) to psql (14.0) ]	ÃÖ±æÈ£	2021/10/20	170
Admin	PostgreSQL 14 / pgadmin Install [ lc_collate 'ko_KR.UTF-8' order by Á¤»ó ]	ÃÖ±æÈ£	2021/10/17	235
Admin	psql dblink to oracle [ odbc test ] ÇѱÛ	ÃÖ±æÈ£	2021/04/19	2499
Admin	postgres , enterprisedb(EDB) / [ ERROR: type "number" does not exist ]	ÃÖ±æÈ£	2020/09/01	272
Admin	install postgresql on docker centos:7	ÃÖ±æÈ£	2020/08/31	382
Troubleshoot	psql: server closed the connection unexpectedly [ vi $PGDATA/postgresql.conf / listen_addresses='*' ]	ÃÖ±æÈ£	2020/08/31	413

¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö

1 [2][3][4][5][6]

Copyright 1999-2022 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)