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
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
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,
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
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
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what is it ?.
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
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 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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
"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
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
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 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
> -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?
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
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
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 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
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 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 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
40 matches
Mail list logo
