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
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,
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.
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 heine.ferre...@gmail.com 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
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 event:
Columns:
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
EnterpriseDB
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 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
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 containing
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 the php
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
SM the
Zitat von AI Rumman rumman...@gmail.com:
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
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(conn,
On Tue, Jun 7, 2011 at 7:46 AM, Юрий EGO mail_...@list.ru 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++) {
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 (comming from
wstrzalka wstrza...@gmail.com 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)
2011/6/7 andr...@a-kretschmer.de:
Zitat von AI Rumman rumman...@gmail.com:
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
On Fri, Jun 3, 2011 at 5:09 PM, Esmin Gracic esmin.gra...@gmail.com 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
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
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 pavel.steh...@gmail.com wrote:
2011/6/7 andr...@a-kretschmer.de:
Zitat von AI Rumman rumman...@gmail.com:
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
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
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
Simon Windsor simon.wind...@cornfield.me.uk 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 ...
On Tue, Jun 7, 2011 at 10:26 PM, Simon Windsor
simon.wind...@cornfield.me.uk 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
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.
Thanks. my
On Tue, Jun 7, 2011 at 2:38 PM, Andreas Kretschmer
akretsch...@spamfence.net 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
-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?
Also,
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
rjgonz...@estrads.com.ar wrote:
On 06/07/2011 03:05 PM, Owen Marinas wrote:
Added the lines in the Master
root@ip-172-19-1-37:~#
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 Nobel
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
On 07/06/11 20:45, Peter Geoghegan wrote:
On 6 June 2011 21:18, Heine Ferreiraheine.ferre...@gmail.com 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
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, SSL off
On Tue, 7 Jun 2011 23:04:04 +0100, Simon Riggs wrote:
On Tue, Jun 7, 2011 at 10:26 PM, Simon Windsor
simon.wind...@cornfield.me.uk 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
39 matches
Mail list logo