70. PostgreSQL DBA: How to start stop restart PostgreSQL on Kali Linux

70. PostgreSQL DBA: How to start stop restart PostgreSQL on Kali Linux

r2schools

2 года назад

1,901 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@Pmbharali
@Pmbharali - 22.02.2023 07:39

In Kali Linux (Debian Bullseye Kali Rolling), after successfully installing PGAdmin 4's latest version with PostgreSQL's latest version, while checking configuration, in binary path, I found psql is showing configured with latest psql server was showing PostgreSQL 15.2 but pg_dump, pg_dumpall, pg_restore were showing previous version. So, like psql, how to upgrade the rest of the 3:

from:

pg_dump: (PostgreSQL) 14.4 (Debian 14.4-1+b1)
pg_dumpall: (PostgreSQL) 14.4 (Debian 14.4-1+b1)
pg_restore: (PostgreSQL) 14.4 (Debian 14.4-1+b1)
psql: (PostgreSQL) 15.2 (Debian 15.2-1)

to:

pg_dump: (PostgreSQL) 15.2 (Debian 15.2-1+b1)
pg_dumpall: (PostgreSQL) 15.2 (Debian 15.2-1+b1)
pg_restore: (PostgreSQL) 15.2 (Debian 15.2-1+b1)
psql: (PostgreSQL) 15.2 (Debian 15.2-1)

Ответить