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

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

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: > > >

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:

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

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

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