Re: calculating the MD5 hash of role passwords in C

El día jueves, enero 23, 2020 a las 05:15:37p. m. +0100, Christoph Moench-Tegeder escribió: > ## Matthias Apitz (g...@unixarea.de): > > > > The documentation on pg_authid has the details: > > > "The MD5 hash will be of the user's password concatenated to their user > > > name." > > > https://ww

Re: PgQ and NOTIFY/LISTEN

On Wed, Jan 22, 2020 at 5:46 AM Олег Самойлов wrote: > > Hi all. > > I looked for a forum or a mailing list for PgQ, but didn't find. May be > someone know here? > > Does PgQ use NOTIFY/LISTEN for PgQ internal daemon or consumers. And if not, > why? May be it has internal own simulation of NOTIF

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

Adrian Klaver writes: > On 1/23/20 1:28 PM, Mike Lissner wrote: >> OK, so then the docs *are* wrong? They say that: >>> any indexes on the affected columns must still be rebuilt. >> But that doesn't happen? Sorry to be persistent. I'm just a bit confused >> here. > My guess is that it is because

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

On 1/23/20 1:28 PM, Mike Lissner wrote: You wrote:  > Well it did not rebuilt the index("t1_name_idx") you created on name. OK, so then the docs *are* wrong? They say that: > any indexes on the affected columns must still be rebuilt. But that doesn't happen? Sorry to be persistent. I'm just

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

You wrote: > Well it did not rebuilt the index("t1_name_idx") you created on name. OK, so then the docs *are* wrong? They say that: > any indexes on the affected columns must still be rebuilt. But that doesn't happen? Sorry to be persistent. I'm just a bit confused here. On Thu, Jan 23, 202

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

On 1/23/20 11:17 AM, Mike Lissner wrote: Thanks Adrian. Is there a reason that the index rebuild is nearly instant during the ALTER command as opposed to when you build it from scratch? Well it did not rebuilt the index("t1_name_idx") you created on name. Does it have to do with why this is

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

Thanks Adrian. Is there a reason that the index rebuild is nearly instant during the ALTER command as opposed to when you build it from scratch? Does it have to do with why this is called a "toast" index? DEBUG: building index "pg_toast_37609_index" on table "pg_toast_37609" Thanks for the feed

Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

On 1/21/20 8:45 AM, David Steele wrote: On 1/21/20 12:55 AM, Eric Veldhuyzen wrote: Ron wrote: On 1/21/20 1:10 AM, Eric Veldhuyzen wrote: Hi, We are using pgbackrest (2.21) to backup out postgresql (11) clusters. Last night our nightly diff backup gave me the ERROR: unable to convert base 10

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

On 1/23/20 8:55 AM, Mike Lissner wrote: I think the docs say that if you convert a varchar to text, it'll rewrite the index, but my test doesn't seem to indicate that. Is the test or the documentation wrong? If the docs, I'll be happy to make a fix my first contribution to postgresql. :) He

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

Since you just built the index, and it's relatively small, maybe all the data is still cached. On 1/23/20 10:55 AM, Mike Lissner wrote: I think the docs say that if you convert a varchar to text, it'll rewrite the index, but my test doesn't seem to indicate that. Is the test or the documentati

Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

I think the docs say that if you convert a varchar to text, it'll rewrite the index, but my test doesn't seem to indicate that. Is the test or the documentation wrong? If the docs, I'll be happy to make a fix my first contribution to postgresql. :) Here are the docs: (https://www.postgresql.org/

Re: calculating the MD5 hash of role passwords in C

On Thu, Jan 23, 2020 at 05:15:37PM +0100, Christoph Moench-Tegeder wrote: > ## Matthias Apitz (g...@unixarea.de): > > > > The documentation on pg_authid has the details: > > > "The MD5 hash will be of the user's password concatenated to their user > > > name." > > > https://www.postgresql.org/doc

Re: calculating the MD5 hash of role passwords in C

## Matthias Apitz (g...@unixarea.de): > > The documentation on pg_authid has the details: > > "The MD5 hash will be of the user's password concatenated to their user > > name." > > https://www.postgresql.org/docs/12/catalog-pg-authid.html > > This is still not exactly what I was looking for. But

RE: calculating the MD5 hash of role passwords in C

-Original Message- From: Matthias Apitz [mailto:g...@unixarea.de] Sent: Wednesday, January 22, 2020 3:05 PM To: Igor Neyman Cc: pgsql-general@lists.postgresql.org Subject: Re: calculating the MD5 hash of role passwords in C > -- > Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.d

Re: Clarification of documentation detail for upgrading minor version

On 1/23/20 3:28 AM, Phil Fisher wrote: Hello I have a 9.6.6 system that misses some features. It is installed on a RHEL7 OS. Reading the 9.6 documentation to upgrade I find the following: " 18.6. Upgrading a PostgreSQL Cluster This section discusses how to upgrade your database data from

Clarification of documentation detail for upgrading minor version

Hello I have a 9.6.6 system that misses some features. It is installed on a RHEL7 OS. Reading the 9.6 documentation to upgrade I find the following: " 18.6. Upgrading a PostgreSQL Cluster This section discusses how to upgrade your database data from one PostgreSQL release to a newer one. Po