Re: What is the problem with this code?

2018-10-19 Thread Thiemo Kellner
In your place I would double check whether the table structure on the database is what you expect. Without knowing the code of mentioned function there seem only two numbers in the call. It quite misty in the crystal fortune telling ball to me. Quoting Igor Korot : Does anybody have an id

Re: pg_dump backup utility is taking more time around 24hrs to take the backup of 28GB

2018-10-19 Thread Jeff Janes
On Thu, Oct 18, 2018 at 8:26 AM Raghavendra Rao J S V < raghavendra...@gmail.com> wrote: > Hi All, > > We are using *pg_dump *backup utility in order to take the backup of the > database. Unfortunately,it is taking around 24hrs of time to take the > backup of 28GB database. Please guide me how t

Fwd: What is the problem with this code?

2018-10-19 Thread Igor Korot
Does anybody have an idea why the code below fails? Thank you. -- Forwarded message - From: Igor Korot Date: Thu, Oct 18, 2018 at 11:49 PM Subject: What is the problem with this code? To: PostgreSQL ODBC list Hi, ALL, [code] std::wstring query1 = L"SHOW log_directory";

RE: pg_dump backup utility is taking more time around 24hrs to take the backup of 28GB

2018-10-19 Thread Kevin Brannen
From: Raghavendra Rao J S V [mailto:raghavendra...@gmail.com] Sent: Thursday, October 18, 2018 7:26 AM To: pgsql-general@lists.postgresql.org Subject: pg_dump backup utility is taking more time around 24hrs to take the backup of 28GB Hi All, We are using pg_dump backup utility in order to take t

Re: PGDG status and policy

2018-10-19 Thread Steve Crawford
On Fri, Oct 19, 2018 at 7:34 AM Adrian Klaver wrote: > On 10/18/18 3:36 PM, Steve Crawford wrote: > > No, the *link* exists. The package doesn't (404 errors on, for example, > > Centos 7 x86_64 and several others). > > According to this: > > > https://www.postgresql.org/message-id/04a8f81ad82d272

Re: PostgreSQL 11 and security

2018-10-19 Thread Adrian Klaver
On 10/19/18 7:38 AM, ROS Didier wrote: Hi Hilbert Thank you for your answer. In fact, I need to update a security guide for PostgreSQL 11. And for that, I need to know what's new in the field of security for this version. Take a look at: https://www.postgresql.org/docs/11/st

RE: PostgreSQL 11 and security

2018-10-19 Thread ROS Didier
Hi Hilbert Thank you for your answer. In fact, I need to update a security guide for PostgreSQL 11. And for that, I need to know what's new in the field of security for this version. Best Regards Didier ROS -Message d'origine- De : karsten.hilb...@gmx.net [mailto:karste

Re: PGDG status and policy

2018-10-19 Thread Adrian Klaver
On 10/18/18 3:36 PM, Steve Crawford wrote: No, the *link* exists. The package doesn't (404 errors on, for example, Centos 7 x86_64 and several others). According to this: https://www.postgresql.org/message-id/04a8f81ad82d272d031f43c9f6f742e2fd3fcd30.camel%40gunduz.org it should be fixed now.

Re: Problem about partitioned table

2018-10-19 Thread Adrian Klaver
On 10/19/18 2:03 AM, Mehman Jafarov wrote: Hi everyone, I have a problem with partitioned table in PostgreSql. Actually I use the version 10. I created the partitioned table in test environment but face some problems with partitioned table constraint. I google all about it last week and from th

Re: PostgreSQL 11 and security

2018-10-19 Thread Karsten Hilbert
On Fri, Oct 19, 2018 at 10:22:05AM +, ROS Didier wrote: >I would like to know what's new in security with PostgreSQL 11 https://www.postgresql.org/docs/current/static/release-11.html#id-1.11.6.5.5 sections "Permissions" and "Authentication" And then, bugs have been

PostgreSQL 11 and security

2018-10-19 Thread ROS Didier
Hi I would like to know what's new in security with PostgreSQL 11 Thanks in advance Best Regards Didier ROS Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les informations qui y

Problem about partitioned table

2018-10-19 Thread Mehman Jafarov
Hi everyone, I have a problem with partitioned table in PostgreSql. Actually I use the version 10. I created the partitioned table in test environment but face some problems with partitioned table constraint. I google all about it last week and from the official site I get that version 11 will be