On 13/09/11 10:54, Reid Thompson wrote:
Could someone point me in the right direction..
Thanks - reid
Given the example data,
how do I write a query that will give me the resultset:
[snip]
I.E. for each distinct val, return the record with the most recent date.
Isn't it something simple like
On 09/12/11 7:40 PM, Rogel Nocedo wrote:
C:\dbbackup does not exist yet.
Please advise.
make the directory first. you can't write a file to a nonexistent
directory.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent
Hello,
I asked this question on JDBC list, but it seems dead.
I found alternative JDBC driver marked as Beta 2 (actually last time
bumped to Beta 2.1) http://softperience.eu/pages/cmn/ngpgjdbc.xhtml.
We still test it. Those features are, mainly, in our interest
- binary transfer
- possibility of
I looked at the link.
Where is the code ? What license ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Sep 13, 2011 at 4:18 AM, Jimmy K. jimmypg...@gmail.com wrote:
Hello,
I asked this question on JDBC list, but it seems dead.
I found alternative JDBC driver
Merlin Moncure, 12.09.2011 21:28:
With the second attempt, the installer again hang during initdb. Checking
the state using ProcessExplorer I could see that the installer script was
waiting for icacls.exe to set permissions for the user currently running the
installer. It was running [icacls.exe
On 13/09/2011 03:40, Rogel Nocedo wrote:
Hi!
How can I please a directory folder where my backup files will be
placed? I am calling pg_dump
C:\Program Files (x86)\PostgreSQL\9.0\binpg_dump -i -h localhost -p
5433 -U postgres -f add.sql --column-inserts -t address my_db
C:\Program Files
On Monday 12 September 2011 22:51:54 Reid Thompson wrote:
test=# select distinct on (val1) val1, val2, val3 from (SELECT
max(val3) OVER (PARTITION BY val1), * FROM sampledata) as sq where val3
= max order by val1;
Other things I've tried (was limited to PG8.3 so no OVER (PARTITION...)
Yes. I would be excited to know if there is a possibility of multi-master
replication system on Postgres.
We will be soon using 9.1 Streaming replication.
Thanks
Venkat
On Tue, Sep 13, 2011 at 1:31 AM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
Congratulations on the release of
Hello.
This might be the wrong place to post my question, but any help is appreciated.
Did any one used Jenkins for Postgresql unit testing, and what are the
available unit testing plug-ins?, is there is a tutorial for that ?
Thanks in advance
On Tue, Sep 13, 2011 at 8:12 AM, Venkat Balaji venkat.bal...@verse.inwrote:
Yes. I would be excited to know if there is a possibility of multi-master
replication system on Postgres.
We will be soon using 9.1 Streaming replication.
Thanks
Venkat
On Tue, Sep 13, 2011 at 1:31 AM, Aleksey
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Dear all,
first let me thank the PostgreSQL developers for implementing the incredibly
helpful window functions. This is one of the features I use most often.
But, as my requirements are perhaps a bit special, I always want more ;)
Now I am trying to implement my own window function using
I would think to do it like
SELECT DISTINCT ON (val) val,date ORDER BY date DESC, val ASC
I haven't tested this, but it's similar to things I've done recently,
and I'm pretty sure this will do what you want.
On Mon, Sep 12, 2011 at 8:54 PM, Reid Thompson jreidthomp...@gmail.com wrote:
Could
I'm starting to play with PostgreSQL 9.1, thank you all for this nice
and sweet piece of software.
I've two hosts in my cluster:
a) postgresql master
b) postgresql standby
I've created two tables on master:
create table test_logged (id serial, nome text);
create unlogged table test_unlogged
2011/9/13 Grzegorz Jaśkiewicz gryz...@gmail.com:
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
yup -- you destroyed all the evidence. if it happens again, try
posting some more info, particularly what's going on with locks,
Reid,
where any one of these 3
11 2011-01-01
11 2011-01-01
13 2011-01-01
or any one of these 2
31 2011-01-05
32 2011-01-05
are suitable for val = 1, val = 3 respectively.
Can you please describe in words what you are trying to
2011/9/13 Merlin Moncure mmonc...@gmail.com:
2011/9/13 Grzegorz Jaśkiewicz gryz...@gmail.com:
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
yup -- you destroyed all the evidence. if it happens again, try
posting some more
2011/9/13 Grzegorz Jaśkiewicz gryz...@gmail.com:
2011/9/13 Merlin Moncure mmonc...@gmail.com:
2011/9/13 Grzegorz Jaśkiewicz gryz...@gmail.com:
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
yup -- you destroyed all the
As I try to restore my data, I get the warning message:
pg_restore: [archiver] input file does not appear to be a valid archive (too
short?)
Ok, but the job ends with green status, I want it to finish with error. Is
there any way of using $? there?
--
View this message in context:
On Tue, Sep 13, 2011 at 9:11 AM, Ferruccio Zamuner nonsolos...@diff.org wrote:
I'm starting to play with PostgreSQL 9.1, thank you all for this nice and
sweet piece of software.
I've two hosts in my cluster:
a) postgresql master
b) postgresql standby
I've created two tables on master:
On Tue, 2011-09-13 at 16:39 +0200, Hannes Erven wrote:
Reid,
where any one of these 3
11 2011-01-01
11 2011-01-01
13 2011-01-01
or any one of these 2
31 2011-01-05
32 2011-01-05
are suitable for val = 1, val = 3
On 09/12/11 1:01 PM, Aleksey Tsalolikhin wrote:
Now that you have streaming replication both async and sync, are you
working on multi-master replication?
general case multimaster replication is extremely hard to do 'right'.
all solutions compromise data integrity and/or create huge
just an update from my tests
i restored from the backup. the db is about 2.5TB and the wal archives were
about 300GB. the recovery of the db was completed after 3 hours. thx to all
for your help
--
View this message in context:
Schneider, Thilo t.schneid...@fraport.de writes:
Currently I access rows of the window partition using the
WinGetFuncArgInPartition function. However, what I noticed is that
this function seems incredibly slow when the partition looked at is
rather large - for my case about 1245000 rows.
It
Hi all,
I've got a large table that has 15 million + rows in it, and a set
of queries I've been trying to speed up. The table has a primary key
column, and a couple hundred other columns.
These queries basically do a 'select max(primary_key_column) from table
group by column1, column2.
Hi,
On 14 September 2011 07:44, Brian Fehrle bri...@consistentstate.com wrote:
2. I have appropriate indexes where they need to be. The issue is in the
query planner not using them due to it (i assume) just being faster to scan
the whole table when the data set it needs is as large as it is.
Hi,
Some months ago, I ran some (probably naive) benchmarks looking at how
pgbench performed on an identical system with differing filesystems. (on
Linux).
Since then the kernel-level version of ZFS became usable, and there have
been improvements to btrfs, and no doubt various updates in the
On 09/13/2011 11:04 PM, Grzegorz Jaśkiewicz wrote:
2011/9/13 Merlin Moncuremmonc...@gmail.com:
2011/9/13 Grzegorz Jaśkiewiczgryz...@gmail.com:
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
yup -- you destroyed all the
On 09/13/2011 04:01 AM, Aleksey Tsalolikhin wrote:
Congratulations on the release of 9.1.0!
Lots of great features, I for one can't wait to try out unlogged
tables, that should help a lot in our environment.
Now that you have streaming replication both async and sync, are you
working on
On 09/13/2011 06:43 PM, Craig Ringer wrote:
On 09/13/2011 04:01 AM, Aleksey Tsalolikhin wrote:
Congratulations on the release of 9.1.0!
Lots of great features, I for one can't wait to try out unlogged
tables, that should help a lot in our environment.
Now that you have streaming replication
I'm sorry Reid, driving back home I realized that the previous query I
suggested didn't do what I was expecting, cause it would compute all of val2
for each val1, even if they belonged to another group (not for a particular
val1/date pair), or in other words, to another date.
I've considered this
On 09/13/2011 08:15 PM, Toby Corkindale wrote:
Hi,
Some months ago, I ran some (probably naive) benchmarks looking at how pgbench
performed on an identical system with differing filesystems. (on Linux).
Since then the kernel-level version of ZFS became usable, and there have been
improvements
On Tuesday, September 13, 2011 7:57:44 am artdias90 wrote:
As I try to restore my data, I get the warning message:
pg_restore: [archiver] input file does not appear to be a valid archive
(too short?)
Ok, but the job ends with green status, I want it to finish with error. Is
there any
On 09/13/2011 02:44 PM, Thomas Kellerer wrote:
It turned out that it tries the following:
(Note that the selected data directory is c:\Daten\db\pgdata91)
icacls C:\ /grant tkellerer:RX
(Changing the permission for the whole harddisk!!)
I forwarded your message to Dave Page in case the EDB
34 matches
Mail list logo