public inbox for [email protected]
help / color / mirror / Atom feedFrom: Justin Pryzby <[email protected]>
To: Devrim Gündüz <[email protected]>
Cc: [email protected]
Subject: Re: pgfincore (Re: cannot install postgis30 / rhel7)
Date: Wed, 2 Oct 2019 18:37:11 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
On Thu, Oct 03, 2019 at 12:18:04AM +0100, Devrim Gündüz wrote:
>
> Hi
>
> On Thu, 2019-09-26 at 17:12 -0500, Justin Pryzby wrote:
> > No package pgfincore12 available.
>
> Please use pg_prewarm. pgfincore does not have v12 support (and does not
> compile anywa)
>
> > No package pg_repack12 available.
>
> https://github.com/reorg/pg_repack/pull/207
> https://github.com/reorg/pg_repack/issues/216
Thanks.
For pgfincore, I don't use it to read blocks, but (very infrequently) in a
tuning query to check "if incore"...
I compiled it fine just now for HEAD (under ubuntu).
make PG_CONFIG=/usr/local/pgsql/bin/pg_config install
waiting for server to start....2019-10-02 18:33:44.409 CDT [25266] LOG: starting PostgreSQL 13devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit
2019-10-02 18:33:44.410 CDT [25266] LOG: listening on IPv4 address "127.0.0.1", port 5678
2019-10-02 18:33:44.492 CDT [25266] LOG: listening on Unix socket "/tmp/.s.PGSQL.5678"
2019-10-02 18:33:44.614 CDT [25277] LOG: database system was shut down at 2019-10-02 12:07:06 CDT
2019-10-02 18:33:44.649 CDT [25266] LOG: database system is ready to accept connections
done
server started
postgres=# CREATE EXTENSION pgfincore;
CREATE EXTENSION
postgres=# SELECT * FROM pgfincore('pg_class');
relpath | segment | os_page_size | rel_os_pages | pages_mem | group_mem | os_pages_free | databit | pages_dirty | group_dirty
-----------------+---------+--------------+--------------+-----------+-----------+---------------+---------+-------------+-------------
base/12708/1259 | 0 | 4096 | 26 | 26 | 1 | 196465 | | 0 | 0
(1 row)
postgres=# SELECT version();
version | PostgreSQL 13devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit
Justin
view thread (29+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgfincore (Re: cannot install postgis30 / rhel7)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox