Hello!
I try build postgresql-9.3.5 on Windows7 x64 with VisualStudioExpess2013.
c:\postgresql-9.3.5\srcnmake -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
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\srcnmake -f win32.mak CPU=AMD64
Microsoft (R) Program Maintenance Utility Version 12.00.21005.1
Copyright (C) Microsoft
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 might
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 slaves
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
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
On 28 October 2014 15:10, Andrus kobrule...@hot.ee 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
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 dropped
Michael P. Soulier msoul...@digitaltorque.ca 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
Michael P. Soulier msoul...@digitaltorque.ca 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
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
On Tue, Oct 28, 2014 at 7:43 AM, Andres Freund and...@2ndquadrant.com
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
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 master and slave
-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.
I've got
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've configured the master
On 28/10/14 19:37, Joe Van Dyk wrote:
On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo
emanuel.ca...@2ndquadrant.com 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
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
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
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
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,
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 j...@tanga.com wrote:
One of my postgres
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:
On 10/28/2014 02:21 AM, Romu Hu wrote:
Hi,
I'm new to postgresql. I ran the regression tests
http://www.postgresql.org/docs/9.2/static/regress-run.html 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
whether
On 28 October 2014 19:14, Andrus kobrule...@hot.ee 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
On Oct 28, 2014, at 1:42 PM, Tom Lane t...@sss.pgh.pa.us 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
On 28 October 2014 20:04, Thom Brown t...@linux.com wrote:
On 28 October 2014 19:14, Andrus kobrule...@hot.ee 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.
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.
On 28 October 2014 21:07, Andrus kobrule...@hot.ee 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
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,
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
http://www.postgresql.org/docs/9.2/static/regress-run.html on my
postgresql 9.2.8, and 17 of 131 tests failed. Below is the
regression.diffs (sorry for
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 raising
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 =
On Wed, Oct 29, 2014 at 10:44 AM, Romu Hu huru...@gmail.com 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
Michael Paquier michael.paqu...@gmail.com writes:
On Wed, Oct 29, 2014 at 10:44 AM, Romu Hu huru...@gmail.com 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.
34 matches
Mail list logo