Обсуждение: ubuntu pg_wrapper selects the wrong version for pg_restore

hi there,

I have postgresql 10.1 installed

when I use pg_restore the wrong version is selected:

robert@lappi:~/odoo_instances$ pg_restore  -V
pg_restore (PostgreSQL) 9.5.10


when I execute

robert@lappi:~/odoo_instances$ pg_restore --cluster 10/main -V
pg_restore (PostgreSQL) 10.1

the correct one is used.


how can I make pg_wrapper use this one as default?


thanks

robert

Hi,

Please find response inline...

I think you need to set your environment variable with the new version in .bash_profile, this will also help pg_wrapper to pick the correct version you are looking for.​

i added the following to: /etc/postgresql-common/user_clusters
# USER  GROUP   VERSION CLUSTER DATABASE
*       *       10      main    *