Re: a very naive question about table names in Postgres

[Dave Cramer]

On Fri, 31 Dec 2021 at 16:25, Paul Jungwirth 
wrote:

> On 12/31/21 12:27 PM, Martin Mueller wrote:
> > I know that on my Mac the tables are  kept in the  data directory
> > /Users/martinmueller/Library/Application Support/Postgres/var-13.  If I
> > go there I see that internally the tables have numbers.  Somewhere in
> > the system there must be a table that maps the name I gave to table X
> > to the numerical  inside the database.
> >
> > Where is that mapping and how can I query it?  On what page of the
> > documentation do I find the answer?
>
> Dear Prof. Mueller,
>
>

Everything you ever wanted to know is here

PostgreSQL: Documentation: 14: Chapter 52. System Catalogs


Enjoy the journey

Dave

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

[Adrian Klaver]

On 12/30/21 18:32, Hasan Marzooq wrote:

Hi.
I tried "yum install centos-release-scl-rh" before but it gives the 
below error.

--
# yum install centos-release-scl-rh
Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
213 packages excluded due to repository priority protections
No package centos-release-scl-rh available.
Error: Nothing to do


Postgres 9.6 on this machine (Amazon Linux 2) is installed via PGDG 
repo, so I tried installing Postgres 13 as well, and I can see it has 
installed but only one more package I need that is 
"postgresql13-devel.x86_64" which needs another dependency " 
llvm-toolset-7-clang >= 4.0.1" that is not available from the same repo.


---
yum list installed | grep -i postgres
postgresql13.x86_64                13.5-1PGDG.rhel7                  @pgdg13
postgresql13-contrib.x86_64        13.5-1PGDG.rhel7                  @pgdg13
postgresql13-libs.x86_64           13.5-1PGDG.rhel7                  @pgdg13
postgresql13-server.x86_64         13.5-1PGDG.rhel7                  @pgdg13
postgresql96.x86_64                9.6.24-1PGDG.rhel6                @pgdg96
postgresql96-contrib.x86_64        9.6.24-1PGDG.rhel6                @pgdg96
postgresql96-devel.x86_64          9.6.24-1PGDG.rhel6                @pgdg96
postgresql96-libs.x86_64           9.6.24-1PGDG.rhel6                @pgdg96
postgresql96-server.x86_64         9.6.24-1PGDG.rhel6                @pgdg96
---


Not sure if it will make a difference, but your 9.6 instance is using 
the rhel6 repo and the 13 is using rhel7.




--
Adrian Klaver
adrian.kla...@aklaver.com

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

[Magnus Hagander]

On Fri, Dec 31, 2021 at 3:32 AM Hasan Marzooq  wrote:
>
> Hi.
> I tried "yum install centos-release-scl-rh" before but it gives the below 
> error.
> --
> # yum install centos-release-scl-rh
> Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
> 213 packages excluded due to repository priority protections
> No package centos-release-scl-rh available.
> Error: Nothing to do
> 
>
> Postgres 9.6 on this machine (Amazon Linux 2) is installed via PGDG repo, so 
> I tried installing Postgres 13 as well, and I can see it has installed but 
> only one more package I need that is "postgresql13-devel.x86_64" which needs 
> another dependency " llvm-toolset-7-clang >= 4.0.1" that is not available 
> from the same repo.

I don't believe 9.6 was supported either, but it may have worked "by chance".

The llvm dependency comes from the JIT functionality, which was added
in PostgreSQL 11, so it not being a dependency in an older version
than that makes perfect sense.

-- 
 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/