본문 바로가기

개발/postgresql

 (2)
개발/postgresql
PostgreSQL 기본 클라이언트 psql 사용 psql 쉘 옵션 [root@linux root]# psql --help This is psql 7.4.1, the PostgreSQL interactive terminal. Usage: psql [OPTIONS]... [DBNAME [USERNAME]] General options: -d DBNAME specify database name to connect to (default: "root") -c COMMAND run only single command (SQL or internal) and exit -f FILENAME execute commands from file, then exit -l list available data.. 2012.01.14
개발/postgresql
PostgreSQL 설치 PostgreSQL 설치 postgresql-7.4.5.tar.gz 설치 [root@localhost postgresql-7.4.5] ./configure [root@localhost postgresql-7.4.5] gmake [root@localhost postgresql-7.4.5] su [root@localhost postgresql-7.4.5] gmake install postgre 그룹 및 유저추가: [root@localhost postgresql-7.4.5] groupadd postgres [root@localhost postgresql-7.4.5] adduser postgres -g postgres -d /usr/local/pgsql [root@localhost postgresql-7.4.5.. 2012.01.12

티스토리툴바