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

From: Ajay Chitale <ajaycc(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Sergei Kornilov <sk(at)zsrv(dot)org>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
Date: 2021-01-28 09:36:32
Message-ID: CAMNQYPhUn3vXU09=q5OXmZH6PFOL0HjQ6x4BBAhZ6CJ9B1Npjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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: 131211109.69.5
2. Select platform: * Select your platformRed Hat Enterprise, CentOS,
Scientific or Oracle version 6Red Hat Enterprise, CentOS, Scientific or
Oracle version 7Red Hat Enterprise, CentOS, Scientific or Oracle version
8Fedora version 31Fedora version 32Fedora version 33
3. Select architecture: x86_64ppc64leaarch64
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(at)hagander(dot)net> wrote:

> On Thu, Jan 28, 2021 at 9:54 AM Ajay Chitale <ajaycc(at)gmail(dot)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/
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message s.p.e 2021-01-28 12:08:21 Postgress 13.x: wrong result for delete with subquery
Previous Message Magnus Hagander 2021-01-28 09:06:48 Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"