http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [41]
DB2 [79]
ORACLE [2942]
PSQL [132]
기타정보 [151]
운영체제 [588]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: PostgreSQL

 회원가입

connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
최길호 [LIST]   2021-11-04 15:25:38, 조회 : 239

# service postgresql start
Starting postgresql service:                               [  OK  ]

$ ps -ef | grep post
postgres 23212     1  3 15:14 ?        00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 23219 23212  0 15:14 ?        00:00:00 postgres: logger process                          
postgres 23221 23212  0 15:14 ?        00:00:00 postgres: writer process                          
postgres 23222 23212  0 15:14 ?        00:00:00 postgres: wal writer process                      
postgres 23223 23212  0 15:14 ?        00:00:00 postgres: autovacuum launcher process            
postgres 23224 23212  0 15:14 ?        00:00:00 postgres: stats collector process  

$ psql
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
$ ls /var/run/postgresql/
ls: cannot access /var/run/postgresql/: No such file or directory

mkdir -p /var/run/postgresql
chown postgres:postgres /var/run/postgresql
ls /tmp/.s.PGSQL.5432
ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432

출처: https://answer-id.com/ko/59781965
3.236.209.138


  LIST

제목 작성자 작성일 조회
Admin  HA 복구 test    최길호 2023/03/03 5
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 4
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 5
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 7
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 4
Admin  memory buffer cache    최길호 2023/02/06 5
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 13
Admin  psql HA    최길호 2023/02/05 13
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 4
Admin  pg_waldump    최길호 2023/02/03 4
Troubleshoot  $PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    최길호 2023/02/02 4
Admin  pg_basebackup 복구 test lv:9   최길호 2023/02/02 14
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ 로그 기록용 ]    최길호 2023/02/01 2
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    최길호 2023/02/01 7
Admin  pg_restore [ 다른 계정, 다른 DB, sql 파일로 저장 ]    최길호 2023/01/30 3
Admin  pg_basebackup pg_dump pg_dumpall backup script    최길호 2023/01/30 16
Admin  session 정보    최길호 2023/01/27 11
Admin  limit fetch offset rows    최길호 2023/01/21 7
Admin  pg_resetwal -D $PGDATA --wal-segsize 2 [ wal size 변경 ]    최길호 2023/01/20 8

    목록보기   다음페이지 1 [2][3][4][5][6][7]
       

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
03/28
[운영체제]
listView.getChildAt(i).setEnab....
by 최길호
03/14
[ORACLE]
Java (1.7) could not be locate....
by 최길호
03/10
[ORACLE]
EXP-00111: Table CREATE$JAVA$L....
by 최길호