Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On 10/29/22 20:38, David G. Johnston wrote: On Sat, Oct 29, 2022 at 8:20 PM Bryn Llewellyn > wrote:This is what I want: 1. I want to do this at the O/S prompt on the machine where my PG cluster has been started: *"su mary"*. 2. Then I want to start a sessi

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On Sat, Oct 29, 2022 at 8:20 PM Bryn Llewellyn wrote:This is what I want: > > 1. I want to do this at the O/S prompt on the machine where my PG cluster > has been started: *"su mary"*. > > 2. Then I want to start a session (I use "psql" here an an example) like > this: *"psql -d postgres"*. > > 3

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> ...What am I doing wrong? > > You skipped over this part of my post and the documentation (Section 21.2): > https://www.postgresql.org/docs/current/auth-pg-hba-con

Re: How to add a variable to a timestamp.

Adrian Klaver writes: > On 10/29/22 10:35, Eagna wrote: >> I'm trying to do something like this. >> '2022-10-31 00:00:00'::TIMESTAMP + INTERVAL 'd.i DAY' That will not work. A literal is a literal, you can't expect that the system will interpret parts of it as variable references. > '2022-1

Re: How to add a variable to a timestamp.

On 10/29/22 10:35, Eagna wrote: Hi, I'm trying to do something like this. SELECT   d.i,   h.i,  '2022-10-31 00:00:00'::TIMESTAMP  + INTERVAL 'd.i DAY' FROM   GENERATE_SERIES(0,  6) AS d(i),   GENERATE_SERIES(0, 23) AS h(i); where I add d.i days (and also h.i hours) to a timestamp. I ca

Re: How to add a variable to a timestamp.

> On 29/10/2022 19:35 CEST Eagna wrote: > > I'm trying to do something like this. > > SELECT > d.i, > h.i, > > '2022-10-31 00:00:00'::TIMESTAMP + INTERVAL 'd.i DAY' > FROM > GENERATE_SERIES(0, 6) AS d(i), > GENERATE_SERIES(0, 23) AS h(i); > > where I add d.i days (and also h.i hours) to a timestam

How to add a variable to a timestamp.

Hi, I'm trying to do something like this. SELECT d.i, h.i, '2022-10-31 00:00:00'::TIMESTAMP + INTERVAL 'd.i DAY' FROM GENERATE_SERIES(0, 6) AS d(i), GENERATE_SERIES(0, 23) AS h(i); where I add d.i days (and also h.i hours) to a timestamp. I can't seem to get this to work. Any ideas appreciated

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On 10/28/22 17:23, Bryn Llewellyn wrote: Adrian, thank you for your reply to my « Seeking the correct term of art for the (unique) role that is usually called "postgres"... » thread here: It got me in without error. (And, as hoped for, there was no password challenge.) But "select current_ro

Re: Re: Does it equal to execute "CREATE ACCESS METHOD"?

thanks for your advice, I realize my problems, can you give me some materials like some study routine for pg-internal? -- jack...@gmail.com >"jack...@gmail.com" writes: >> When I add >> "{ oid => '6015', oid_symbol => 'SPB_AM_OID', >>   descr => 'SPB index access

Re: Re: Does it equal to execute "CREATE ACCESS METHOD"?

"jack...@gmail.com" writes: > When I add > "{ oid => '6015', oid_symbol => 'SPB_AM_OID', > descr => 'SPB index access method', > amname => 'spb', amhandler => 'spbhandler', amtype => 'i' }," > in pg_am.dat > and add > "{ oid => '388', descr => 'spb index access method handler', > proname =

Re: Does it equal to execute "CREATE ACCESS METHOD"?

"jack...@gmail.com" writes: > When I add > "{ oid => '6015', oid_symbol => 'SPB_AM_OID', > descr => 'SPB index access method', > amname => 'spb', amhandler => 'spbhandler', amtype => 'i' }," > in pg_am.dat > and add > "{ oid => '388', descr => 'spb index access method handler', > proname =

Re: Does it equal to execute "CREATE ACCESS METHOD"?

Sorry, I open another mail list to ask this question. When I add "{ oid => '6015', oid_symbol => 'SPB_AM_OID', descr => 'SPB index access method', amname => 'spb', amhandler => 'spbhandler', amtype => 'i' }," in pg_am.dat and add "{ oid => '388', descr => 'spb index access method handler',

Does it equal to execute "CREATE ACCESS METHOD"?

Sorry, I open another mail list to ask this question. When I add "{ oid => '6015', oid_symbol => 'SPB_AM_OID', descr => 'SPB index access method', amname => 'spb', amhandler => 'spbhandler', amtype => 'i' }," in pg_am.dat and add "{ oid => '388', descr => 'spb index access method handler',

Re: Error while upgrading from v12 to v13

I have dropped the function on all databases on version 12,but while upgrading I am still getting the same error On Sat, 29 Oct, 2022, 7:56 pm Imre Samu, wrote: > > ERROR: could not find function "pl_profiler_enable" in file > > maybe obsolete function? > > -- Drop obsolete function > DROP FUNC

Re: Error while upgrading from v12 to v13

> ERROR: could not find function "pl_profiler_enable" in file maybe obsolete function? -- Drop obsolete function DROP FUNCTION pl_profiler_enable(bool); https://github.com/bigsql/plprofiler/blob/master/plprofiler--3.5--4.0.sql Regards, Imre shashidhar Reddy ezt írta (időpont: 2022. okt. 29.,

Re: Error while upgrading from v12 to v13

Any help in this? On Sat, 29 Oct, 2022, 5:09 pm shashidhar Reddy, < shashidharreddy...@gmail.com> wrote: > > I am getting below error while upgrading postgres from version 12 to 13 > and not sure how to enable the function before upgrading the cluster. Can > you please help me to resolve this. >

Re: access method xxx does not exist

Hi, On Sat, Oct 29, 2022 at 09:43:51PM +0800, jack...@gmail.com wrote: > --=_001_NextPart037628267087_= > Content-Type: text/html; charset="utf-8" > Content-Transfer-Encoding: quoted-printable > > Yes,I just want to know if I add a= > m in pg_am.dat, after I make install, it means the new

Re: Re: access method xxx does not exist

Hi, On Sat, Oct 29, 2022 at 08:15:54PM +0800, jack...@gmail.com wrote: > On 2022-10-29 19:19:28 +0800, jack...@gmail.com wrote: > > I'm trying to add a new index, but when I finish it, I use “ create index > > xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does > > not > > e

Re: access method xxx does not exist

Hi, On Sat, Oct 29, 2022 at 08:15:54PM +0800, jack...@gmail.com wrote: > On 2022-10-29 19:19:28 +0800, jack...@gmail.com wrote: > > I'm trying to add a new index, but when I finish it, I use “ create index > > xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does > > not > > e

Re: Re: access method xxx does not exist

On 2022-10-29 19:19:28 +0800, jack...@gmail.com wrote: > I'm trying to add a new index, but when I finish it, I use “ create index > xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does not > exist > And I don't know where this message is from, can you grve me its position? Se

Re: access method xxx does not exist

On 2022-10-29 19:19:28 +0800, jack...@gmail.com wrote: > I'm trying to add a new index, but when I finish it, I use “ create index > xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does not > exist > And I don't know where this message is from, can you grve me its position? Se

Error while upgrading from v12 to v13

I am getting below error while upgrading postgres from version 12 to 13 and not sure how to enable the function before upgrading the cluster. Can you please help me to resolve this. error: could not execute query: ERROR: could not find function "pl_profiler_enable" in file "/usr/lib/postgresql/1

回复: access method xxx does not exist

I'm trying to add a new index, but when I finish it, I use “ create index xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does not exist And I don't know where this message is from, can you grve me its position? I do like this. I add oid in pg_am.dat and pg_proc.dat for my

access method xxx does not exist

I'm trying to add a new index, but when I finish it, I use “ create index xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does not exist And I don't know where this message is from, can you grve me its position? I do like this. I add oid in pg_am.dat and pg_proc.dat for my

Upgrade error from version 12 to 23

I am upgrading postures from version 12 to 13 and getting below error when using pg_upgrade Error is checking database user is the install user only the install user can be defined in the new cluster. Note: I am using postures user

Re: how to install plprofiler

Thank you Pavel it worked for me. On Sat, 29 Oct, 2022, 12:59 pm Pavel Stehule, wrote: > > > so 29. 10. 2022 v 9:25 odesílatel shashidhar Reddy < > shashidharreddy...@gmail.com> napsal: > >> Pavel, >> >> After Uninstall plprofiler where can find this to install again. >> > > https://github.com/

Re: how to install plprofiler

so 29. 10. 2022 v 9:25 odesílatel shashidhar Reddy < shashidharreddy...@gmail.com> napsal: > Pavel, > > After Uninstall plprofiler where can find this to install again. > https://github.com/bigsql/plprofiler/blob/master/doc/installation.md > On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, > wr

Re: how to install plprofiler

I am sorry I have not installed it for version 13 as I am not able to find the source On Sat, 29 Oct, 2022, 12:55 pm shashidhar Reddy, < shashidharreddy...@gmail.com> wrote: > Pavel, > > After Uninstall plprofiler where can find this to install again. > > On Sat, 29 Oct, 2022, 12:42 pm Pavel Steh

Re: how to install plprofiler

Pavel, After Uninstall plprofiler where can find this to install again. On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, wrote: > Hi > > > so 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy < > shashidharreddy...@gmail.com> napsal: > >> Hello, >> >> I am in a process of upgrading postgresql 12 to

Re: how to install plprofiler

Hi so 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy < shashidharreddy...@gmail.com> napsal: > Hello, > > I am in a process of upgrading postgresql 12 to version 13, when I am > testing it getting the below error > could not load library $carlib/plprofiler > "/usr/lib/postgresql/13/l