Re: [GENERAL] [BUGS] Where clause in pg_dump: need help

2016-07-09 Thread Prashanth Adiyodi
Hi Sameer, Please see comments inline Prashanth Adiyodi Technical Account Manager Skype: prashanth.adiyodi Mob: +91-9819488395 [celltick] From: Sameer Kumar [mailto:sameer.ku...@ashnik.com] Sent: Friday, July 08, 2016 3:18 PM To: Francisco Olarte; Prashanth Adiyodi Cc: pgsql-general@postgresql

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 12:09 PM, arnaud gaboury wrote: % dnf info postgresql Last metadata expiration check: 2 days, 20:46:44 ago on Wed Jul 6 23:17:54 2016. Installed Packages Name: postgresql Arch: x86_64 Epoch : 0 Version : 9.5.3 Release : 1.fc24 Have you installe

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 8:45 PM, Adrian Klaver wrote: > On 07/09/2016 11:40 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: >

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 11:40 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver wrote: On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: On 07/09/2016 08:08 AM, arnaud gaboury wrote: I understand you are confused, as I am to

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver wrote: > On 07/09/2016 11:06 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2016 08:08 AM, arnaud gaboury wrote: > > I understand you are confused, as I am too and tried too many thin

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: On 07/09/2016 08:08 AM, arnaud gaboury wrote: I understand you are confused, as I am too and tried too many things with no success. I have postgresql 9.5.3 installed, and the upgrade was from

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: > On 07/09/2016 08:08 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote:

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 08:08 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 1:00 AM,

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 08:59 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 5:08 PM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, a

Re: [GENERAL] Pgadmin access to Postgresql

2016-07-09 Thread Tom Lane
Luciano Martin Galletti writes: > The server doesn't accept connections: the connection library reports > could not connect to server: Connection refused (0x274D/10061) Is the > server running on host "IP_OF_THE_SERVER" and accepting TCP/IP connections on > port 5432? > Do i have to set som

Re: [GENERAL] Pgadmin access to Postgresql

2016-07-09 Thread Adrian Klaver
On 07/09/2016 08:00 AM, Luciano Martin Galletti wrote: i'm tryng to access to a db that is on a my server. The port is 5432 open and accept tcp/ip connections. Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection re

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 5:08 PM, arnaud gaboury wrote: > On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver > wrote: >> On 07/09/2016 03:09 AM, arnaud gaboury wrote: >>> >>> On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury >>> wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrot

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: > On 07/09/2016 03:09 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury >> wrote: >>> >>> On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury >>> wrote: On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jimén

[GENERAL] Pgadmin access to Postgresql

2016-07-09 Thread Luciano Martin Galletti
i'm tryng to access to a db that is on a my server. The port is 5432 open and accept tcp/ip connections. Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host "I

[GENERAL] PostgreSQL image for rkt on CoreOS

2016-07-09 Thread Derek Mahar
Where may I find a PostgreSQL App Container Image (ACI) for rkt on CoreOS? I understand that rkt can use the official PostgreSQL Docker image available on Docker Hub, but it would be beneficial to also have an rkt-tested ACI image. Thank you, Derek

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez wrote: El 7/7/16 a las 0:14, Devrim Gündüz escribió: Hi, Fedora packages ha

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: > On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury > wrote: >> On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez >> wrote: >>> El 7/7/16 a las 0:14, Devrim Gündüz escribió: >>> Hi, Fedora packages have an executable (not

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: > On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez > wrote: >> El 7/7/16 a las 0:14, Devrim Gündüz escribió: >> >>> Hi, >>> >>> Fedora packages have an executable (not sure about its name, but check a >>> package called postgresql-upg

Re: [GENERAL] Running query without trigger?

2016-07-09 Thread Christian Elmerot
On 2016-07-09 08:20, haman...@t-online.de wrote: Hi, a table is associated with a trigger for normal use. An admin (someone with ALTER privilege) can disable tthe trigger, run some bulk update, and then re-enable it. This means, however, that normal user activity has to be locked out. There

Re: [GENERAL] Running query without trigger?

2016-07-09 Thread Berend Tober
haman...@t-online.de wrote: Hi, a table is associated with a trigger for normal use. An admin (someone with ALTER privilege) can disable tthe trigger, run some bulk update, and then re-enable it. This means, however, that normal user activity has to be locked out. There are two possible sce