[GENERAL] Build libpq on Win7 failed with error "U1045: spawn failed"

Hello! I try build postgresql-9.3.5 on Windows7 x64 with VisualStudioExpess2013. c:\postgresql-9.3.5\src>nmake -f win32.mak CPU=AMD64 Microsoft (R) Program Maintenance Utility Version 12.00.21005.1 Copyright (C) Microsoft Corporation. All rights reserved. cd include if not exis

Re: [GENERAL] Build libpq on Win7 failed with error "U1045: spawn failed"

On 10/28/2014 07:10 AM, Brilliantov Kirill Vladimirovich wrote: Hello! I try build postgresql-9.3.5 on Windows7 x64 with VisualStudioExpess2013. c:\postgresql-9.3.5\src>nmake -f win32.mak CPU=AMD64 Microsoft (R) Program Maintenance Utility Version 12.00.21005.1 Copyright (C) Microsoft Corporati

Re: [GENERAL] Build libpq on Win7 failed with error "U1045: spawn failed"

Adrian Klaver wrote on 10/28/2014 05:24 PM: First let me say I have not built Postgres on Windows. I did find this: http://www.postgresql.org/docs/9.3/interactive/install-windows-full.html One thing that stands out is: "All commands should be run from the src\tools\msvc directory." You migh

Re: [GENERAL] pg killed by oom-killer, "invalid contrecord length 2190 at A6C/331AAA90" on slaves

On 2014-10-25 13:55:57 -0700, Joe Van Dyk wrote: > One of my postgres backends was killed by the oom-killer. Now, one of my > streaming replication slaves is reporting "invalid contrecord length 2190 > at A6C/331AAA90" in the logs and replication has paused. I have other > streaming replication sla

Re: [GENERAL] Build libpq on Win7 failed with error "U1045: spawn failed"

On 10/28/2014 07:37 AM, Brilliantov Kirill Vladimirovich wrote: Adrian Klaver wrote on 10/28/2014 05:24 PM: First let me say I have not built Postgres on Windows. I did find this: http://www.postgresql.org/docs/9.3/interactive/install-windows-full.html One thing that stands out is: "All com

[GENERAL] How to find earlest possible start times for given duration excluding reservations

Hi! I'm looking for finding ealiest possible start times from reservations table. People work from 10:00AM to 21:00PM in every week day except Sunday and public holidays. Jobs for them are reserved at 15 minute intervals and whole job must fit to single day. Job duration is from 15 minute

Re: [GENERAL] How to find earlest possible start times for given duration excluding reservations

On 28 October 2014 15:10, Andrus wrote: > Hi! > > I'm looking for finding ealiest possible start times from reservations > table. > > People work from 10:00AM to 21:00PM in every week day except Sunday and > public holidays. > > Jobs for them are reserved at 15 minute intervals and whole job must

[GENERAL] cannot drop user

Hi, I've dropped a db and now I'm trying to drop the user that owns all of it, but I can't. dropdb: database removal failed: ERROR: database "tugdb" does not exist [2014-10-28 13:23:40,462] INFO:Dropping user... dropuser: removal of role "tugdbuser" failed: ERROR: role "tugdbuser" cannot be dr

Re: [GENERAL] cannot drop user

"Michael P. Soulier" writes: > Hi, > > I've dropped a db and now I'm trying to drop the user that owns all of it, but > I can't. > > dropdb: database removal failed: ERROR: database "tugdb" does not exist > [2014-10-28 13:23:40,462] INFO:Dropping user... > dropuser: removal of role "tugdbuser"

Re: [GENERAL] cannot drop user

"Michael P. Soulier" writes: > I've dropped a db and now I'm trying to drop the user that owns all of it, but > I can't. > dropdb: database removal failed: ERROR: database "tugdb" does not exist > [2014-10-28 13:23:40,462] INFO:Dropping user... > dropuser: removal of role "tugdbuser" failed: ER

Re: [GENERAL] cannot drop user

On 28/10/14 Jerry Sievers said: > That user owns objects in whatever DB you're sitting in meanwhile trying > to DROP ROLE. (template1?) I'm just running the dropuser command, so if it uses template1, then yes. I'm not sure how they would get there. This is only happening on one box, so perhaps

Re: [GENERAL] pg killed by oom-killer, "invalid contrecord length 2190 at A6C/331AAA90" on slaves

On Tue, Oct 28, 2014 at 7:43 AM, Andres Freund wrote: > On 2014-10-25 13:55:57 -0700, Joe Van Dyk wrote: > > One of my postgres backends was killed by the oom-killer. Now, one of my > > streaming replication slaves is reporting "invalid contrecord length 2190 > > at A6C/331AAA90" in the logs and

Re: [GENERAL] some queries on standby preventing replication updates

On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo < emanuel.ca...@2ndquadrant.com> wrote: > > El 23/10/14 a las 17:40, Joe Van Dyk escibió: > > Hi, > > > > I have a master and a slave database. > > > > I've got hot_standby_feedback turned on, > > max_standby_streaming_delay=-1. I've configured the ma

Re: [GENERAL] some queries on standby preventing replication updates

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 El 28/10/14 a las 15:37, Joe Van Dyk escibió: > On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo < > emanuel.ca...@2ndquadrant.com> wrote: > >> >> El 23/10/14 a las 17:40, Joe Van Dyk escibió: >>> Hi, >>> >>> I have a master and a slave database.

Re: [GENERAL] some queries on standby preventing replication updates

Joe Van Dyk wrote > On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo < > emanuel.calvo@ >> wrote: > >> >> El 23/10/14 a las 17:40, Joe Van Dyk escibió: >> > Hi, >> > >> > I have a master and a slave database. >> > >> > I've got hot_standby_feedback turned on, >> > max_standby_streaming_delay=-1. I

Re: [GENERAL] some queries on standby preventing replication updates

On 28/10/14 19:37, Joe Van Dyk wrote: > On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo > mailto:emanuel.ca...@2ndquadrant.com>> > wrote: > > > El 23/10/14 a las 17:40, Joe Van Dyk escibió: > > Hi, > > > > I have a master and a slave database. > > > > I've got hot_standby_f

Re: [GENERAL] How to find earlest possible start times for given duration excluding reservations

Hi! >Would you be able to adapt this to your needs?: Thank you very much. Great solution. I refactored it as shown below. Query returns only dates for single day. Changing limit clause to 300 does not return next day. How to return other day dates also, excluding sundays and public holidays in p

[GENERAL] "can not able to find scan Function For making NoDB"

Sir, I am working on NoDB But In debug mode of eclipse, i am not able to find scan function that is used for loading a table. Please help me i am not able to go ahead. Regards, gaurav kumar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subsc

Re: [GENERAL] Log-shipping replication in one machine

Thank you for your response. May i know what is the difference between log shipping and streaming replication actually? I'm sorry i am very new in postgreSQL and still confused with these two __ If you reply to this email, your message will be added to the

Re: [GENERAL] "can not able to find scan Function For making NoDB"

On 10/24/2014 11:13 AM, Gaurav Kumar wrote: Sir, I am working on NoDB But In debug mode of eclipse, i am not able to find scan function that is used for loading a table. Please help me i am not able to go ahead. This is the Postgres list. I think you need to find the NoDB list. Regards, g

Re: [GENERAL] pg killed by oom-killer, "invalid contrecord length 2190 at A6C/331AAA90" on slaves

Hello, months ago I have a similar problem with the OOM-Killer. Have a look at http://www.credativ.co.uk/credativ-blog/2010/03/postgresql-and-linux-memory-management I hope that's helpful. Regards, basti On Sat 25.10.2014 22:55 +0200, Joe Van Dyk wrote: > One of my postgres backends was killed

Re: [GENERAL] Log-shipping replication in one machine

On 10/26/2014 09:46 PM, nurul [via PostgreSQL] wrote: Thank you for your response. May i know what is the difference between log shipping and streaming replication actually? I'm sorry i am very new in postgreSQL and still confused with these two For an overview see: http://www.postgresql.org/

Re: [GENERAL] Need guidance on regression.diffs

On 10/28/2014 02:21 AM, Romu Hu wrote: Hi, I'm new to postgresql. I ran the regression tests on my postgresql 9.2.8, and 17 of 131 tests failed. Below is the regression.diffs (sorry for pasting such a long file), I have no clue whethe

Re: [GENERAL] How to find earlest possible start times for given duration excluding reservations

On 28 October 2014 19:14, Andrus wrote: > Hi! > > >Would you be able to adapt this to your needs?: > > Thank you very much. > Great solution. > I refactored it as shown below. > Query returns only dates for single day. Changing limit clause to 300 > does not return next day. > How to retur

Re: [GENERAL] cannot drop user

On Oct 28, 2014, at 1:42 PM, Tom Lane wrote: > Those DETAIL lines are complaining about objects that are in the database > you're currently attached to; the details about object names and so on > would not be available otherwise. So I suspect at some point you > accidentally loaded a pg_dump scri

Re: [GENERAL] How to find earlest possible start times for given duration excluding reservations

On 28 October 2014 20:04, Thom Brown wrote: > On 28 October 2014 19:14, Andrus wrote: > >> Hi! >> >> >Would you be able to adapt this to your needs?: >> >> Thank you very much. >> Great solution. >> I refactored it as shown below. >> Query returns only dates for single day. Changing limit

Re: [GENERAL] How to find earlest possible start times for given duration excluding reservations

Hi! >A correction to this. As it stands, it will show times like the following: Thank you. I posted your solution as alternative to Erwin answer in http://stackoverflow.com/questions/26608683/how-to-find-first-free-start-times-from-reservations-in-postgres Andrus.

Re: [GENERAL] How to find earlest possible start times for given duration excluding reservations

On 28 October 2014 21:07, Andrus wrote: > Hi! > > >A correction to this. As it stands, it will show times like the > following: > > Thank you. > I posted your solution as alternative to Erwin answer in > > http://stackoverflow.com/questions/26608683/how-to-find-first-free-start-times-from-r

[GENERAL] Query optimization

Hello, I'm trying to optimize a query that takes too much time. This is what I have table1(field1, field2... field14): contains about 8.5 million rows table2(f1, f2, f3): contains about 2.5 million rows table3: is empty, and must be filled with data coming from table1 and table2 To fill table3,

Re: [GENERAL] Need guidance on regression.diffs

On 2014/10/29 3:58, Adrian Klaver wrote: On 10/28/2014 02:21 AM, Romu Hu wrote: Hi, I'm new to postgresql. I ran the regression tests on my postgresql 9.2.8, and 17 of 131 tests failed. Below is the regression.diffs (sorry for pasti

Re: [GENERAL] Query optimization

Jorge Arévalo-2 wrote > So, I first generate a common table records_to_insert, using data from > table1 and table2, and then call a function fill_table3_function, in order > to insert the values into table3 (I do more things apart from insert, > that's reason to call a function instead of just rais

Re: [GENERAL] Query optimization

Jorge Arévalo-2 wrote > (SELECT value1,value2,value3,value4,value5, hstore(ARRAY['field9', > 'field10', 'field11', 'field12', 'field13', 'field14'], ARRAY[field9, > field10, field11, field12, field13, field14) as metadata, value7, (select > array((select row(f1, f2) from table2 p where p.field7 = f

Re: [BUGS] [GENERAL] Need guidance on regression.diffs

On Wed, Oct 29, 2014 at 10:44 AM, Romu Hu wrote: > I ran the test against an existing installation (redhat enterprise linux > software collection postgresql92). The postgres server and the tests are > from the same source package. Well, your diffs are telling us the contrary. The additional colum

Re: [BUGS] [GENERAL] Need guidance on regression.diffs

Michael Paquier writes: > On Wed, Oct 29, 2014 at 10:44 AM, Romu Hu wrote: >> I ran the test against an existing installation (redhat enterprise linux >> software collection postgresql92). The postgres server and the tests are >> from the same source package. > Well, your diffs are telling us t

Re: [BUGS] [GENERAL] Need guidance on regression.diffs

On 2014/10/29 11:23, Tom Lane wrote: Michael Paquier writes: On Wed, Oct 29, 2014 at 10:44 AM, Romu Hu wrote: I ran the test against an existing installation (redhat enterprise linux software collection postgresql92). The postgres server and the tests are from the same source package. Well,

[GENERAL] Appending new data to existing field of Json data type

Hello, As i am new to postgresql, i am learning through experimenting things. i have a table with json data type field, so there is some data for example : { [ { a:b, b:c } ] } and now if i append data then it should be like : { [ { a:b, b:c }, { e:f, g:h } ] }