Обсуждение: Incorrect version of initdb
Hello, Installed postgresql-13 from Debian repos. postgres@roblaptop:/usr/lib/postgresql/13/bin$ initdb -V initdb (PostgreSQL) 12.4 (Debian 12.4-1) PG_VERSION is initialised as 12. However, postgres@roblaptop:/usr/lib/postgresql/13/bin$ createdb -V createdb (PostgreSQL) 13.0 (Debian 13.0-2) pg_ctl (PostgreSQL) 12.4 (Debian 12.4-1) pg_dump (PostgreSQL) 13.0 (Debian 13.0-2) Debian OS:- Linux roblaptop 5.8.0-2-amd64 #1 SMP Debian 5.8.10-1 (2020- 09-19) x86_64 GNU/Linux This is just a development box.
On Wed, Sep 30, 2020 at 8:01 AM rob stone <floriparob@gmail.com> wrote:
Hello,
Installed postgresql-13 from Debian repos.
postgres@roblaptop:/usr/lib/postgresql/13/bin$ initdb -V
initdb (PostgreSQL) 12.4 (Debian 12.4-1)
This does not execute initdb from the 13 directory, it executes it from the one in the path.
If you run "./initdb -V", you should see version 13.
PG_VERSION is initialised as 12.
However,
postgres@roblaptop:/usr/lib/postgresql/13/bin$ createdb -V
createdb (PostgreSQL) 13.0 (Debian 13.0-2)
pg_ctl (PostgreSQL) 12.4 (Debian 12.4-1)
pg_dump (PostgreSQL) 13.0 (Debian 13.0-2)
Debian OS:- Linux roblaptop 5.8.0-2-amd64 #1 SMP Debian 5.8.10-1 (2020-
09-19) x86_64 GNU/Linux
This is just a development box.
initdb is in the postgresql-13 package, and createdb is in postgresql-client-13. Perhaps you only installed/upgraded one of them?
Since you are in debian, you should also look at using pg_createcluster instead of raw initdb. It'll set things up properly with service starting and permissions and such things automatically for you there.