Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"

Поиск
Список
Период
Сортировка
Искать
От
Ajay Chitale
Тема
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
Дата
Msg-id
CAMNQYPhUn3vXU09=q5OXmZH6PFOL0HjQ6x4BBAhZ6CJ9B1Npjg@mail.gmail.com
Ответ на
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" (Magnus Hagander)
Список
Дерево обсуждения
BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Sergei Kornilov <sk@zsrv.org>
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Magnus Hagander <magnus@hagander.net>
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
I just installed Postgresql 13 by following below instructions at  https://www.postgresql.org/download/linux/redhat/. It installed the versions as you see 

  1. Select version: 
  2. Select platform: 
  3. Select architecture: 
  4. Copy, paste and run the relevant parts of the setup script:
    # Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Install PostgreSQL:
sudo yum install -y postgresql13-server

# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

On Thu, Jan 28, 2021 at 2:37 PM Magnus Hagander <magnus@hagander.net> wrote:
On Thu, Jan 28, 2021 at 9:54 AM Ajay Chitale <ajaycc@gmail.com> wrote:
>
> Hi,
>
>   Yes, I get that message
>
> bash-4.2$ psql mydb
> could not change directory to "/home/postgresql"
> psql (9.2.24, server 13.1)
> WARNING: psql version 9.2, server version 13.0.
>          Some psql features might not work.

Wow that is.. *very* old. And has been unsupported for many years.

You'll want to upgrade your client. On CentOS that will mean
installing the package "postgresql13". I'd suggest uninstalling the
9.2 packages while you're at it, so you don't accidentally end up
running things from the old versions.

--
 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/
В списке pgsql-bugs по дате отправления
Предыдущее
От: Magnus Hagander
Дата:
Следующее
От: PG Bug reporting form
Дата:
FAQ