On 6/06/2011 8:59, Thomas Guettler wrote:
Hi,
how do you store recurring events in a database?
Selecting all events in a week/month should be fast (comming from an index).
My solution looks like this:
Table event:
Columns: id, name, recurring, start_datetime, end_datetime
recurring is weekl
On Tue, 7 Jun 2011 23:04:04 +0100, Simon Riggs wrote:
On Tue, Jun 7, 2011 at 10:26 PM, Simon Windsor
wrote:
I have been using Postgres for many years and have recently discover
Greenplum, which appears to be a heavily modify Postgres based,
multi node
DB that is VERY fast.
All the tests tha
On 8/06/2011 2:04 AM, Owen Marinas wrote:
2011-06-07 17:53:04 UTC FATAL: no pg_hba.conf entry for replication
connection from host "172.19.1.101", user "postgres", SSL off
2011-06-07 17:53:09 UTC FATAL: no pg_hba.conf entry for replication
connection from host "172.19.1.101", user "postgres", SS
On 07/06/11 20:45, Peter Geoghegan wrote:
On 6 June 2011 21:18, Heine Ferreira wrote:
Hi
Does Postgres run on the Starter Edition of Windows Vista and Windows 7?
Starter edition can only run 3 programs at a time. I'm not sure how
that's counted, and how it will roll with PG's multi-process
a
I am not an expert but I will try to explain.
replication user has access to WAL stream, bypassing any revoked
permission on any database.
I think that is the reason to force a specific user with specific
permissions for replicationyou don't want user x reading WAL stream
while you don't
On June 7, 2011 04:38:16 PM owen marinas wrote:
> Thx, Merci, Gracias Rodrigo
> it worked indeed, Im wondering why replication is not included in "All"
>
Probably because it gives access to all the data being written to the
database.
--
Obama has now fired more cruise missiles than all other N
Thx, Merci, Gracias Rodrigo
it worked indeed, Im wondering why replication is not included in "All"
regards
Owen
On Tue, Jun 7, 2011 at 2:40 PM, Rodrigo Gonzalez
wrote:
> On 06/07/2011 03:05 PM, Owen Marinas wrote:
>>
>> Added the lines in the Master
>> root@ip-172-19-1-37:~# cat /etc/postgresq
> -Original Message-
> Maybe...
>
> Yeah, i think, 16 MByte isn't the real limit, yes. And i've seen queries
larger
> than that limit, but i can't find the link, sorry.
> (maybe depesz.com, dunno, can't remember, i'm sorry)
>
What kind of use-case would generate that large of a query?
On Tue, Jun 7, 2011 at 2:38 PM, Andreas Kretschmer
wrote:
> Yeah, i think, 16 MByte isn't the real limit, yes. And i've seen
> queries larger than that limit, but i can't find the link, sorry.
> (maybe depesz.com, dunno, can't remember, i'm sorry)
The thread linked seems to mainly be talking abou
On Jun 7, 2011, at 5:18 PM, Pavel Stehule wrote:
> Hello
>
> no, it means some different.
>
> we tested a SQL about 20MB with success.
>
> The maximum of varlena is 1GB - so it is necessary to be possible send
> a query longer 1GB. But you need a free RAM 3-5x larger then query
> size.
>
Tha
On Tue, Jun 7, 2011 at 10:26 PM, Simon Windsor
wrote:
> I have been using Postgres for many years and have recently discover
> Greenplum, which appears to be a heavily modify Postgres based, multi node
> DB that is VERY fast.
>
> All the tests that I have seen suggest that Greenplum when implemen
"Simon Windsor" writes:
> I have been using Postgres for many years and have recently discover
> Greenplum, which appears to be a heavily modify Postgres based, multi node
> DB that is VERY fast.
Very fast on a very narrow set of use cases ...
regards, tom lane
--
Sent
Hi
I have been using Postgres for many years and have recently discover
Greenplum, which appears to be a heavily modify Postgres based, multi node
DB that is VERY fast.
All the tests that I have seen suggest that Greenplum when implemented on a
single server, like Postgres, but with several
On 06/07/2011 03:05 PM, Owen Marinas wrote:
Added the lines in the Master
root@ip-172-19-1-37:~# cat /etc/postgresql/9.0/main/pg_hba.conf |grep trust
host all postgres 172.19.1.101/32 trust
You need in pg_hba.conf
hostreplication repuser 172.19.1.101/32 md5
Database
Hi,
I configured replication in 2 AWS instances.
I have shell scripts to dynamically configure the Ips after the
instances are UP.
the Postgres versions are the same in master & slave, also the
architecture of instances.
Added the lines in the Master
root@ip-172-19-1-37:~# cat /etc/postgre
Pavel Stehule wrote:
> 2011/6/7 :
> >
> > Zitat von AI Rumman :
> >
> >> Is there any maximum size limit for a query string in Postgresql 9.0.1?
> >> If yes, what is it ?.
> >>
> >
> > Not sure, but maybe 16 MByte, see
> > http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
>
> is
Greetings!!
I'm not sure why the query is not using the gist index in the table
base.parishes. Any suggestions?
__
CREATE TABLE base.parishes
(
gid serial NOT NULL,
parish text,
"COUNT" integer,
"SUM_AREA" double precision,
"SUM_ELECTO" double
Hi,
I configured replication in 2 AWS instances.
I have shell scripts to dynamically configure the Ips after the
instances are UP.
the Postgres versions are the same in master& slave, also the
architecture of instances.
Added the lines in the Master
root@ip-172-19-1-37:~# cat /etc/postgresql
On Fri, Jun 3, 2011 at 5:09 PM, Esmin Gracic wrote:
> another option is using sqlite for storing images. All data is in single
> file. (or files if you organize it that way) easier backup etc... you have
> some db benefits and retaining solid speed vs file system. Haven't used
> this, but seems as
2011/6/7 :
>
> Zitat von AI Rumman :
>
>> Is there any maximum size limit for a query string in Postgresql 9.0.1?
>> If yes, what is it ?.
>>
>
> Not sure, but maybe 16 MByte, see
> http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
isn't it limit for PHP?
Pavel
>
>
> --
> Sent vi
wstrzalka wrote:
> Hi
>
>Is there any estimate where 9.1 potentially could be released?
Sure. When it's ready ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I
Le mardi 07 juin 2011 à 13:28 +0200, Thomas Guettler a écrit :
>
> On 07.06.2011 09:57, Vincent Veyron wrote:
> > Le lundi 06 juin 2011 à 12:59 +0200, Thomas Guettler a écrit :
> >
> >> how do you store recurring events in a database?
> >>
> >> Selecting all events in a week/month should be fast
On Tue, Jun 7, 2011 at 7:46 AM, Юрий EGO wrote:
> Hello!
>
> I have a code (libpq):
>
> char textbuffer[120];
> res = PQexec(conn, "COPY
> table_name(\"serial_column",\"int_column",\"bytea_column\") FROM STDIN");
> if(PQresultStatus(res) == PGRES_COPY_IN)
> {
> for(int n=0; n < 10; n++) {
> sprint
Hello!
I have a code (libpq):
char textbuffer[120];
res = PQexec(conn, "COPY
table_name(\"serial_column",\"int_column",\"bytea_column\") FROM STDIN");
if(PQresultStatus(res) == PGRES_COPY_IN)
{
for(int n=0; n < 10; n++) {
sprintf(textbuffer, "1\t%i\t'text'\n", n);
int copydatares = PQputCopyData
Zitat von AI Rumman :
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what is it ?.
Not sure, but maybe 16 MByte, see
http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
Hi Scott,
SM> Snip. Those are ALL either AccessShareLock (which is very low level
SM> and non-blocking) or virtual tx locks, which again don't block
SM> anything but their own transaction. Nothing there screams "locks!"
SM> for a better view of locks and how they're blocking things you can use
S
On Tue, 7 Jun 2011 08:21:27 -0700, Shad Keene wrote:
> I'm
getting some errors all of a sudden when using PHP and Perl to connect
to my postgresql database.
>
> I'm running Red Hat Enterprise Linux
Client release 5.6 (Tikanga)
> And php-5.1.6-27.el5_5.3
>
perl-5.8.8-32.el5_5.2
>
> Here's th
I'm getting some errors all of a sudden when using PHP and Perl to connect to
my postgresql database.
I'm running Red Hat Enterprise Linux Client release 5.6 (Tikanga)
And php-5.1.6-27.el5_5.3
perl-5.8.8-32.el5_5.2
Here's the php error when trying to connect:
PHP Warning: PHP Startup: Unable
Hi Craig and mailing list
On 07.06.2011 00:54, Craig Ringer wrote:
> On 06/06/2011 06:59 PM, Thomas Guettler wrote:
>> Hi,
>>
>> how do you store recurring events in a database?
>
> I use two tables: one table that stores the recurring event, and another
> that's essentially a materialized view c
On Tue, 07 Jun 2011 06:44:02 +0800, Craig Ringer wrote:
On 06/06/2011 09:26 PM, Condor wrote:
Can you explain little more how i can use database-level or
user-level
SET commands to set log_statement for only one of them ?
http://www.postgresql.org/docs/current/static/sql-set.html
http://www
Hello
no, it means some different.
we tested a SQL about 20MB with success.
The maximum of varlena is 1GB - so it is necessary to be possible send
a query longer 1GB. But you need a free RAM 3-5x larger then query
size.
Regards
Pavel Stehule
2011/6/7 Vibhor Kumar :
>
> On Jun 7, 2011, at 4:0
On Jun 7, 2011, at 4:09 PM, AI Rumman wrote:
> Is there any maximum size limit for a query string in Postgresql 9.0.1?
> If yes, what is it ?.
track_activity_query_size parameter.
http://www.postgresql.org/docs/9.0/static/runtime-config-statistics.html
Thanks & Regards,
Vibhor Kumar
Enterprise
On 07.06.2011 09:57, Vincent Veyron wrote:
> Le lundi 06 juin 2011 à 12:59 +0200, Thomas Guettler a écrit :
>
>> how do you store recurring events in a database?
>>
>> Selecting all events in a week/month should be fast (comming from an index).
>>
>> My solution looks like this:
>>
>> Table even
On 6 June 2011 21:18, Heine Ferreira wrote:
> Hi
>
> Does Postgres run on the Starter Edition of Windows Vista and Windows 7?
Starter edition can only run 3 programs at a time. I'm not sure how
that's counted, and how it will roll with PG's multi-process
architecture, but my guess would be not we
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what is it ?.
On 7/06/2011 3:35 PM, Toby Corkindale wrote:
On 07/06/11 09:00, Craig Ringer wrote:
On 06/07/2011 04:18 AM, Heine Ferreira wrote:
Hi
Does Postgres run on the Starter Edition of Windows Vista and Windows 7?
As far as I know PostgreSQL is not explicitly tested on Windows ...
Starter Edition. W
Hi
Is there any estimate where 9.1 potentially could be released?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Le lundi 06 juin 2011 à 12:59 +0200, Thomas Guettler a écrit :
> how do you store recurring events in a database?
>
> Selecting all events in a week/month should be fast (comming from an index).
>
> My solution looks like this:
>
> Table event:
>
> Columns: id, name, recurring, start_datetime,
On 06/07/11 12:35 AM, Toby Corkindale wrote:
Looking at the Windows 7 Starter FAQ, I don't see why it wouldn't work..
You're limited to 2 GB of memory, but that'll be enough to get by on
for local development and stuff.
the user management is even more crippled than it is in win7 Home,
makin
On 07/06/11 09:00, Craig Ringer wrote:
On 06/07/2011 04:18 AM, Heine Ferreira wrote:
Hi
Does Postgres run on the Starter Edition of Windows Vista and Windows 7?
As far as I know PostgreSQL is not explicitly tested on Windows ...
Starter Edition. Whether it will work depends on how crippled th
40 matches
Mail list logo
