Thread: postgresql11-devel RPM is missing from "Direct RPM downloads"

postgresql11-devel RPM is missing from "Direct RPM downloads"

From
Dmitry O Litvintsev
Date:
Hi,

Where can I find postgresq11-devel RPM ?

It is missing from direct RPM download page :

https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/

or

https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/postgresqldbserver11.group.html

Thanks,
Dmitry




Re: postgresql11-devel RPM is missing from "Direct RPM downloads"

From
Jakub Olczyk
Date:
Hi Dimiry,

On 04/06/2019 23:49, Dmitry O Litvintsev wrote:
> Where can I find postgresq11-devel RPM ?
> [...]
> https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/

have you looked under the letter "P" in your first link?
There you can find the -devel package.

https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html

Cheers!
Jakub




Re: postgresql11-devel RPM is missing from "Direct RPM downloads"

From
Dmitry O Litvintsev
Date:
D'oh. Thanks!

/----------------------------------------------------------\
| Tel:       (630) 840 5005                                |
| FAX:       (630) 840 2968                                |
|            (630) 840 2783                                |
| office:    FCC 240                                       |
| E-mail:    litvinse@fnal.gov                             |
\----------------------------------------------------------/

On Wed, 5 Jun 2019, Jakub Olczyk wrote:

> Hi Dimiry,
>
> On 04/06/2019 23:49, Dmitry O Litvintsev wrote:
>> Where can I find postgresq11-devel RPM ?
>> [...]
>>
https://urldefense.proofpoint.com/v2/url?u=https-3A__yum.postgresql.org_11_redhat_rhel-2D7-2Dx86-5F64_repoview_&d=DwICaQ&c=gRgGjJ3BkIsb5y6s49QqsA&r=7PHi3TDlwkvpc07MjENbOxVFl0u_sEurf250JnUFWCU&m=x0FsGjpFkd074Owr0TbLitPaA8Y3iFdjJIgsUZQKx4Q&s=64-qFF0vgct9WdlN14qDUr3Dx58YQv0sWwCFLg2D8M4&e=
>
> have you looked under the letter "P" in your first link?
> There you can find the -devel package.
>
>
https://urldefense.proofpoint.com/v2/url?u=https-3A__yum.postgresql.org_11_redhat_rhel-2D7-2Dx86-5F64_repoview_letter-5Fp.group.html&d=DwICaQ&c=gRgGjJ3BkIsb5y6s49QqsA&r=7PHi3TDlwkvpc07MjENbOxVFl0u_sEurf250JnUFWCU&m=x0FsGjpFkd074Owr0TbLitPaA8Y3iFdjJIgsUZQKx4Q&s=9BjL2HUlWfddhgpV1vnwDsRjRXNO4d1DNN0USk3J1uE&e=
>
> Cheers!
> Jakub
>
>



Hi All,

We have recently noticed in our development environment pg_log with flooded message.

[64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution
[64463]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution
[64464]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution
[64548]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution
[64551]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution
[64553]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution

Not sure , How to address this message ,

Much appreciated if some one give light on this.

Version . : 9.2.23

Regards,
Raj


On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj <perucinci@gmail.com> wrote:
Hi All,

We have recently noticed in our development environment pg_log with flooded message.

[64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution...

First thing I'd check is that DNS is functioning correctly (including local resolution settings or caching name resolvers).

Cheers,
Steve
 


On Wed, Jun 5, 2019 at 11:08 AM Steve Crawford <scrawford@pinpointresearch.com> wrote:
On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj <perucinci@gmail.com> wrote:

[64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution...

First thing I'd check is that DNS is functioning correctly (including local resolution settings or caching name resolvers).

In addition to what Steve mentioned, I've a vague recollection from running into this several years ago that this is triggered by having "log_hostname" enabled in your postgresql.conf.
Thanks Steve for the response, Yes we had DNS server change. 
But conf file updated with right DNS server and its resolving when i crosscheck with nslookup against clinet_addr

By the way , What is the right syntax for LDAP configuration ,

I am using the one below, and getting LDAP authentication error though i was able to login to server with same password.

host    all     all     0.0.0.0/0       ldap ldapserver=ldap.xxx.com ldapport=389 ldaptls=1 ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=auth_user,dc=domain,dc=com" ldapbindpasswd=encrypted_password ldapsearchattribute=uid

Version :9..2

Regards,
Raju


On Wed, Jun 5, 2019 at 11:08 AM Steve Crawford <scrawford@pinpointresearch.com> wrote:
On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj <perucinci@gmail.com> wrote:
Hi All,

We have recently noticed in our development environment pg_log with flooded message.

[64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution...

First thing I'd check is that DNS is functioning correctly (including local resolution settings or caching name resolvers).

Cheers,
Steve
 
Hi All,

We are using the following format for LDAP authentication,

host    all     all     0.0.0.0/0       ldap ldapserver=ldap.xxx.com ldapport=389 ldaptls=1 ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=auth_user,dc=domain,dc=com" ldapbindpasswd=encrypted_password ldapsearchattribute=uid

1. It successfully retrieved user information when we do ldapsearch "ldapsearch -H "ldaps://ldap.xxxx.com" -W -D "cn=auth_user,ou=people,dc=domain,dc=com" -b "dc=domain,dc=com" "uid=ldap_user"

2. Same LDAP server is authenticating while ssh / sudo successfully.

But issue is while connecting DB 

-bash-4.1$ psql -h dbhost.domain.com -Atc "select 'success'" -Uldap_user postgres

Password for user ldap_user: 

psql: FATAL:  LDAP authentication failed for user "ldap_user"

-bash-4.1$ 



Is there any way to validate ldap_user password using ldapsearch ?
Or is there any specific format in pg_hba.conf to configure LDAP.

Regards,
Raj

On Wed, Jun 5, 2019 at 4:56 PM Perumal Raj <perucinci@gmail.com> wrote:
Thanks Steve for the response, Yes we had DNS server change. 
But conf file updated with right DNS server and its resolving when i crosscheck with nslookup against clinet_addr

By the way , What is the right syntax for LDAP configuration ,

I am using the one below, and getting LDAP authentication error though i was able to login to server with same password.

host    all     all     0.0.0.0/0       ldap ldapserver=ldap.xxx.com ldapport=389 ldaptls=1 ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=auth_user,dc=domain,dc=com" ldapbindpasswd=encrypted_password ldapsearchattribute=uid

Version :9..2

Regards,
Raju


On Wed, Jun 5, 2019 at 11:08 AM Steve Crawford <scrawford@pinpointresearch.com> wrote:
On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj <perucinci@gmail.com> wrote:
Hi All,

We have recently noticed in our development environment pg_log with flooded message.

[64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:  pg_getnameinfo_all() failed: Temporary failure in name resolution...

First thing I'd check is that DNS is functioning correctly (including local resolution settings or caching name resolvers).

Cheers,
Steve