1. apt-get update apt-get install postgresql-11 2. su - postgres psql -c "alter user postgres with password 'barbar'" 3. edit /etc/postgresql/11/main/postgresql.conf listen_addresses = '*' 4. restart systemctl restart postgresql 5. create user: sudo su - postgres createuser dcms 6. set user password: psql alter user dcms with password 'barbar'; 7. login: psql dcms or via http://adminer.arkyidae.com/?pgsql=localhost&username=dcms login: http://adminer.arkyidae.com/?pgsql=localhost&username=postgres

https://computingforgeeks.com/install-postgresql-11-on-debian-10-buster/

to quick import a db: psql -h 127.0.0.1 -U dbuser mydb -f mydb.sql 08.04.20 to access from remote 1. modify: /etc/postgresql/15/main/postgresql.conf listen_addresses = '*' 2. add to /etc/postgresql/15/main/pg_hba.conf host all all all md5 3. restart: /etc/init.d/postgresql restart 08.04.20

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024