Re: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Matthias Apitz
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." > > >

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

2020-01-23 Thread Tom Lane
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

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

2020-01-23 Thread Mike Lissner
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,

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

2020-01-23 Thread Adrian Klaver
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

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

2020-01-23 Thread Mike Lissner
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

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

2020-01-23 Thread David Steele
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.

2020-01-23 Thread Adrian Klaver
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. :)

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

2020-01-23 Thread Ron
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

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

2020-01-23 Thread Mike Lissner
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:

Re: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Bruce Momjian
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." > > >

Re: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Christoph Moench-Tegeder
## 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.

RE: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Igor Neyman
-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,

Re: Clarification of documentation detail for upgrading minor version

2020-01-23 Thread Adrian Klaver
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

2020-01-23 Thread Phil Fisher
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.