Thread: pg_init
I want to read pg_database from pg_init...
Is using heap_open() is possible? or else any other way is there ?
On Tue, Oct 08, 2019 at 10:03:03PM +0530, Natarajan R wrote: >I want to read pg_database from pg_init... > >Is using heap_open() is possible? or else any other way is there ? This is way too vague question - I have no idea what you mean by pg_init, for example. And it's probably a good idea to explain what you're trying to achieve. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote: > On Tue, Oct 08, 2019 at 10:03:03PM +0530, Natarajan R wrote: > >I want to read pg_database from pg_init... > > > >Is using heap_open() is possible? or else any other way is there ? > > This is way too vague question - I have no idea what you mean by > pg_init, for example. And it's probably a good idea to explain what > you're trying to achieve. This question was familiar to me so I searched the archives. It seems related to https://www.postgresql.org/message-id/17058.1570166272%40sss.pgh.pa.us -- Antonin Houska Web: https://www.cybertec-postgresql.com
On Wed, 9 Oct 2019 at 00:33, Natarajan R <nataraj3098@gmail.com> wrote:
I want to read pg_database from pg_init...Is using heap_open() is possible? or else any other way is there ?
I replied to a similar thread with details on how bgworkers can access different databases; look at the archives.
The gist is that you have to register a bgworker that attaches to shared memory and to a database (or use InvalidOid if you only want shared catalog access), then do your work from there.