postgresql

 

 

# postgresql 실행
$ sudo service postgresql start

# postgresql 상태 확인
$ sudo service postgresql status

# postgresql 종료
$ sudo service postgresql stop

 

PostgreSQL 기본 마스터 계정인 [postgres]로 접속

$ sudo -i -u postgres
$ psql

 

# if needed to change

postgres=# alter user postgres with password '1234';

 

 

#testshin id create

postgres=# create user testadmin password 'xxx' superuser;
postgres=# \du

 

 

# create testdb
postgres=# create database testdb owner testadmin;
postgres=# \l

 

# edit

etc/postgresql/16/main$ vi pg_hba.conf

~~~~ peer => md5

 

$ service postgresql restart

 

$ psql -U testadmin -d testdb

Password for user testadmin: 
psql (16.8 (Ubuntu 16.8-0ubuntu0.24.04.1))
Type "help" for help.

testdb=# 

 

 

 

 

 

#
# Setup the repository
#

# Install the public key for the repository (if not done previously):
curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg

# Create the repository configuration file:
sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/oracular pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

sudo apt install pgadmin4-desktop


https://www.pgadmin.org/download/pgadmin-4-apt/