Craig Ringer, 14.09.2011 06:20:
I forwarded your message to Dave Page in case the EDB folks needed to
look into this. He commented that:
"Aside from the fact that icacls is hanging for reasons unknown, it
appears to be doing what it is designed to do - it traverses up the
path from the data dire
Hello guys,
i'm trying to use trigger in these two tables below, in order to do
the following;
To cancel the booking of an accommodation, since the customer do the
host (status = "Cancelled") in the book_rooms table. Changing the
state of accommodation to "occupied" (Accommodation Table).
CREAT
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
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
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
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 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
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 multi-m
On 09/13/2011 11:04 PM, Grzegorz Jaśkiewicz wrote:
2011/9/13 Merlin Moncure:
2011/9/13 Grzegorz Jaśkiewicz:
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
posti
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
Hi,
On 14 September 2011 07:44, Brian Fehrle 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.
Try to reduce random_pag
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." B
"Schneider, Thilo" 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 might help to incre
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:
http://postgresql.1045698.n5.nabble.com/warm-standby-apply-wal-archi
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 performan
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 va
On Tue, Sep 13, 2011 at 9:11 AM, Ferruccio Zamuner 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:
>
> create tabl
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:
http://postg
2011/9/13 Grzegorz Jaśkiewicz :
> 2011/9/13 Merlin Moncure :
>> 2011/9/13 Grzegorz Jaśkiewicz :
>>> 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
>> postin
2011/9/13 Merlin Moncure :
> 2011/9/13 Grzegorz Jaśkiewicz :
>> 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 go
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
2011/9/13 Grzegorz Jaśkiewicz :
> 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,
pg_stat_activity,
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 (
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 wrote:
> Could someone point me in the
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 C-Lang
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
On Tue, Sep 13, 2011 at 8:12 AM, Venkat Balaji wrote:
> 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 <
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
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 9.1
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...)"
sup
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\bin>pg_dump -i -h localhost -p
> 5433 -U postgres -f add.sql --column-inserts -t address my_db
>
> C:\Prog
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
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. wrote:
> Hello,
>
> I asked this question on JDBC list, but it seems "dead".
>
> I found alternative JDBC driver marked as Bet
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 o
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 v
35 matches
Mail list logo
