Re: [GENERAL] Error installing 9.5 on Win 2012 R2: data dir not created

2016-01-18 Thread DerekW
There are no differences between the 2 servers that I can imagine would stop this install. Both were sucessfully running PostgrSQL 9.4.5 prior to the update. The /data directory is not even being created. After uninstalling there is no /PostgreSQL subdirectory under C:/Program Files/. The installe

Re: [GENERAL] Execute commands in single-user mode

2016-01-18 Thread Jim Nasby
On 1/10/16 3:44 PM, Andreas Joseph Krogh wrote: It might be about time to come up with an extension that's a replacement for large objects. What would it take to fund such an extension? Time and/or money. It would "have to" support: - Migrate existing LOs away from pg_largeobject -

[GENERAL] Re: [GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

2016-01-18 Thread drum.lu...@gmail.com
On 19 January 2016 at 11:44, dinesh kumar wrote: > Hello, > > On Mon, Jan 18, 2016 at 1:37 PM, drum.lu...@gmail.com < > drum.lu...@gmail.com> wrote: > >> I've created a function that allows me to do an huge update. >> >> But I need to limit this function. I need to do 50k rows (example) and >> th

[GENERAL] Re: [GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

2016-01-18 Thread dinesh kumar
Hello, On Mon, Jan 18, 2016 at 1:37 PM, drum.lu...@gmail.com wrote: > I've created a function that allows me to do an huge update. > > But I need to limit this function. I need to do 50k rows (example) and > then stop it. After that I need to continue from the rows that I've > stopped... I'll ha

[GENERAL] Re: [GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

2016-01-18 Thread drum.lu...@gmail.com
> > It is customary to restrict emails to a single list or at least make > others aware when you do have a legitmate need to cross-post. > > Specifically your post on -admin <“Break” in plpgsql Function - PostgreSQL > 9.2> > > Yes, it didn't belong on -admin in the first place but posting it here >

[GENERAL] Re: [GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

2016-01-18 Thread David G. Johnston
On Mon, Jan 18, 2016 at 2:37 PM, drum.lu...@gmail.com wrote: > I've created a function that allows me to do an huge update. > > But I need to limit this function. I need to do 50k rows (example) and > then stop it. After that I need to continue from the rows that I've > stopped... I'll have to mo

[GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

2016-01-18 Thread drum.lu...@gmail.com
I've created a function that allows me to do an huge update. But I need to limit this function. I need to do 50k rows (example) and then stop it. After that I need to continue from the rows that I've stopped... I'll have to modify the call function *select batch_number()* as well. How can I do th

Re: [GENERAL] CoC [Final]

2016-01-18 Thread Stéphane Schildknecht
On 18/01/2016 19:36, Joshua D. Drake wrote: > On 01/18/2016 10:15 AM, Kevin Grittner wrote: >> On Mon, Jan 18, 2016 at 12:02 PM, Joshua D. Drake >> wrote: >> >>> * Participants who disrupt the collaborative space, or participate in a >>> pattern of behaviour which could be considered harassment w

Re: [GENERAL] CoC [Final]

2016-01-18 Thread Joshua D. Drake
On 01/18/2016 10:38 AM, Karsten Hilbert wrote: On Mon, Jan 18, 2016 at 10:02:33AM -0800, Joshua D. Drake wrote: O.k. so I let every thing sit with V7 for several days and we have received no further feedback. I believe we have reached a point where we can reasonably consider this Final or at le

Re: [GENERAL] CoC [Final]

2016-01-18 Thread Karsten Hilbert
On Mon, Jan 18, 2016 at 10:02:33AM -0800, Joshua D. Drake wrote: > O.k. so I let every thing sit with V7 for several days and we have received > no further feedback. I believe we have reached a point where we can > reasonably consider this Final or at least Final Draft. While the verbiage seems O

Re: [GENERAL] CoC [Final]

2016-01-18 Thread Joshua D. Drake
On 01/18/2016 10:15 AM, Kevin Grittner wrote: On Mon, Jan 18, 2016 at 12:02 PM, Joshua D. Drake wrote: * Participants who disrupt the collaborative space, or participate in a pattern of behaviour which could be considered harassment will not be tolerated. Personally, I was comfortable with

Re: [GENERAL] CoC [Final]

2016-01-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Joshua D. Drake wrote: > This final draft incorporates all reasonable feedback I have received as > well as rewriting it in a more conversational tone from Kevin Grittner's > efforts. Looks great to me. Thanks for all your efforts in this.

Re: [GENERAL] CoC [Final]

2016-01-18 Thread Kevin Grittner
On Mon, Jan 18, 2016 at 12:02 PM, Joshua D. Drake wrote: > * Participants who disrupt the collaborative space, or participate in a > pattern of behaviour which could be considered harassment will not be > tolerated. Personally, I was comfortable with the rest of it, but this one made me squirm

[GENERAL] CoC [Final]

2016-01-18 Thread Joshua D. Drake
Hello, O.k. so I let every thing sit with V7 for several days and we have received no further feedback. I believe we have reached a point where we can reasonably consider this Final or at least Final Draft. This final draft incorporates all reasonable feedback I have received as well as rewr

Re: [GENERAL] Error installing 9.5 on Win 2012 R2: data dir not created

2016-01-18 Thread Adrian Klaver
On 01/18/2016 07:40 AM, DerekW wrote: I am running Windows Server 2012 R2 x64 and upgrading from 9.4.5 to 9.5. I was unable to get pg_upgrade to work so my upgrade path is: 1) Backup with pg_dumpall 2) Uninstall 9.4 3) Install 9.5 4) Restore data This worked sucessfully on one server. I am now ha

[GENERAL] Error installing 9.5 on Win 2012 R2: data dir not created

2016-01-18 Thread DerekW
I am running Windows Server 2012 R2 x64 and upgrading from 9.4.5 to 9.5. I was unable to get pg_upgrade to work so my upgrade path is:1) Backup with pg_dumpall2) Uninstall 9.43) Install 9.54) Restore dataThis worked sucessfully on one server. I am now having issues following the same procedure on a

[GENERAL] Re: [pgsql-pkg-yum] Missing RHEL rpm(pg_catcheck-95) in postgres 9.5 repo.

2016-01-18 Thread Devrim GÜNDÜZ
Hi, On Mon, 2016-01-18 at 06:26 +, Kaliappa, Karthic wrote: > We are looking to upgrade our application from postgres 9.4 to 9.5, > but we are unable to find the RPM named 'pg_catcheck-95' for RHEL (ht > tp://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/). > Whereas it is available for Fedora,

Re: [GENERAL] [BDR] Best practice to automatically abort a DDL operation when one node is down

2016-01-18 Thread Sylvain MARECHAL
What is the best practice to make sure the DDL operation will fail, possibly after a timeout, if one of the node is down? statement_timeout Ok. Thank-you for pointing this. I have just tried it, and this work great even for nodes that are not properly power off (plug removed).