RE: Foreign Key locking / deadlock issue.... v2

2018-03-26 Thread HORDER Phil
psql> select version(); PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit

PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

2018-03-26 Thread nmmulla
Hi, We are upgrading our VMware version from 5.5 to 6.5. Is PostgreSQL version 9.1 to 10.1 compatible on VMware vSphere ESXI 6.5 and harware version 13. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

2018-03-26 Thread nmmulla
We are upgrading Vmware to version 6.5. Operating system for virtual servers will not be changing. The other change that will be happening is VM hardware version which will be upgraded from current version ( 9 or 10) to version 13. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-gen

Re: [GENERAL] missing public on schema public

2018-03-26 Thread Alvaro Herrera
Was this ever fixed? -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Query performance

2018-03-26 Thread hmidi slim
I want to compare the performance of some queries so I created those tables: *CREATE TABLE reservation1 (room int, name varchar(255), during daterange);CREATE TABLE reservation2 (room int, name varchar(255), start_date date, end_date date);* then: *INSERT INTO public.reservation1(name, room,

Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

2018-03-26 Thread Joshua D. Drake
On 03/26/2018 07:03 AM, nmmulla wrote: We are upgrading Vmware to version 6.5. Operating system for virtual servers will not be changing. The other change that will be happening is VM hardware version which will be upgraded from current version ( 9 or 10) to version 13. Your compatibility is b

Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

2018-03-26 Thread nmmulla
Thanks JD. Like i said we are not changing OS at all. WE are just upgrading VMWare from ESXi 5.5 to 6.5 and hardware from version 10 to 13. We are using Linux 6, 7. By just upgrading VMWare will it affects the performane of postgres databases? -- Sent from: http://www.postgresql-archive.org/P

Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

2018-03-26 Thread David G. Johnston
On Mon, Mar 26, 2018 at 1:28 PM, nmmulla wrote: > Thanks JD. > > Like i said we are not changing OS at all. WE are just upgrading VMWare > from > ESXi 5.5 to 6.5 and hardware from version 10 to 13. > > We are using Linux 6, 7. > > By just upgrading VMWare will it affects the performane of postgre

Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

2018-03-26 Thread Michael Paquier
On Mon, Mar 26, 2018 at 01:49:30PM -0700, David G. Johnston wrote: > You should probably ask this question on the VMWare forums since its their > software that would or would not have the performance improvements. > PostgreSQL will benefit from any memory and disk-related virtualization > enhanceme

Re: [GENERAL] missing public on schema public

2018-03-26 Thread Michael Paquier
On Mon, Mar 26, 2018 at 12:46:38PM -0300, Alvaro Herrera wrote: > Was this ever fixed? Ugh. I have added a reminder on the open item page for v11 as an older bug: https://wiki.postgresql.org/wiki/PostgreSQL_11_Open_Items#Older_Bugs -- Michael signature.asc Description: PGP signature

Problem with postgreSQL

2018-03-26 Thread Gian mario Caggiu
Hi, I'm a student and I downloaded postgreSQL to my Mac but I found a problem. The program does not start, I do not understand why, but that's not what scares me. The fact is that a virtual user has been created called 'postgreSQL' which has appropriated all the functions of the administrator us

Warning of .partial wal file in PITR and Replication Environment

2018-03-26 Thread Amee Sankhesara - Quipment India
[Quipment Logo] Hello, We have a windows setup for PostgreSQL(Version 9.6). We have setup replication and PITR on this PostgreSQL server. For doing some OS migration activity for the PostgreSQL database servers We created two new replication server and promoted to new master server for the sam

Re: Problem with postgreSQL

2018-03-26 Thread Adrian Klaver
On 03/26/2018 04:41 AM, Gian mario Caggiu wrote: Hi, I'm a student and I downloaded postgreSQL to my Mac but I found a problem. The program does not start, I do not understand why, but that's Where did you download it from? What version of Postgres? How did you install it? not what scares m

Autonomous transaction, background worker

2018-03-26 Thread Thiemo Kellner
Hi I try to setup a logging facility and want it to do its work asynchronously in autonomous transactions. I have read http://blog.dalibo.com/2016/08/19/Autonoumous_transactions_support_in_PostgreSQL.html and chapter 47 of the documentation believing those articles are about the same. However

Re: Warning of .partial wal file in PITR and Replication Environment

2018-03-26 Thread Michael Paquier
On Mon, Mar 26, 2018 at 11:52:53AM +, Amee Sankhesara - Quipment India wrote: > Warning : The failed archive command was: copy > "D:\PostgreSQL\9.6\data\pg_xlog\00010A8800F8.partial" > "\\10.0.0.35\Archive_Replication\00010A8800F8.partial" | > copy "D:\PostgreSQL\9.6\da