Hi,
Yes. Both matches with that specified in the Tools- options in IE
(which is the same we used for configuring in stack builder).
Thanks Regards,
Vishnu S
From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com]
Sent: Wednesday, September 29, 2010 11:04 AM
To:
On 8 September 2010 21:48, Thom Brown t...@linux.com wrote:
Hi,
I noticed that if I run this:
SELECT alias, description, token FROM
ts_debug('http://www.postgresql.org:2345/directory/page.html?version=9.1build=alpha1#summary');
I get:
alias | description |
On Tue, Sep 28, 2010 at 7:46 PM, Scott Ribe scott_r...@killerbytes.com wrote:
On Sep 28, 2010, at 11:50 AM, Dave Page wrote:
You're welcome. I guess it is running the 64bit image - is your
machine Leopard Server?
That's irrelevant. The 32-bit vs 64-bit default is for the kernel and
Hello List,
a lot of recherche and no answer so far. So my question to you:
Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
replication provider (Master) and receiver (client) at the same time?
Can i configure both to
* accept 'insert into ...' stream that changes out (usual
no you can't
but you have have multiple clusters running at the same time on the
same box. Just set them up on different ports, and in different
directories.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 29 September 2010 10:22, p...@bastian-s.de wrote:
Hello List,
a lot of recherche and no answer so far. So my question to you:
Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
replication provider (Master) and receiver (client) at the same time?
Can i configure both to
Hi,
I need to generate aggregates of data coming from a stream.
I could easily doing it inserting data coming from the stream into a table,
and then query it using something like:
select my aggregation function from atable group by a column list
The problem with this approach is that I would
On 29/09/2010 10:52, Leonardo Francalanci wrote:
Hi,
I need to generate aggregates of data coming from a stream.
I could easily doing it inserting data coming from the stream into a table,
and then query it using something like:
selectmy aggregation function from atable group bya column
Christian,
On Wed, 29 Sep 2010, Christian Ramseyer wrote:
Hi List
I have a largish partitioned table, it has ~60 million records in each of 12
partitions. It appears that a Full Text Index could speed up some user
queries a lot.
A quick test with an additional tsvector column revealed
I installed PostgreSql 9.0 Win 64 standard distro.
Stack builder offered in end of installation does not contain
postgresql.conf optimization wizard.
How to optimize postgresql.conf for 64 bit dedicated postgresql windows
2003 server or is default .conf file best for this?
Andrus.
--
In pl/pgsql at any rate, functions which return a set of rows build up
the entire result set in memory and then return the set in one go:
Ok, then pl/pgsql and pl/python (which can't return SETOF) are ruled out.
(Thank you for pointing that out).
But pl/perl seems to do the trick:
PL/Perl
2010/9/29 Andrus kobrule...@hot.ee:
I installed PostgreSql 9.0 Win 64 standard distro.
Stack builder offered in end of installation does not contain
postgresql.conf optimization wizard.
How to optimize postgresql.conf for 64 bit dedicated postgresql windows
2003 server or is default .conf
2010/9/29 Andrus kobrule...@hot.ee:
I installed PostgreSql 9.0 Win 64 standard distro.
Stack builder offered in end of installation does not contain
postgresql.conf optimization wizard.
We updated it for Win64, but it looks like the stackbuilder catalog
wasn't updated to allow it to be
We updated it for Win64, but it looks like the stackbuilder catalog
wasn't updated to allow it to be downloaded on that platform. I've
fixed that - it should be available within an hour or so.
I just installed 9.0 x64
Is it sufficient to run Program files / PostgreSql 9.0 / Application Stack
On Wed, Sep 29, 2010 at 11:37 AM, Andrus kobrule...@hot.ee wrote:
We updated it for Win64, but it looks like the stackbuilder catalog
wasn't updated to allow it to be downloaded on that platform. I've
fixed that - it should be available within an hour or so.
I just installed 9.0 x64
Is it
Hi,
I have this query
SELECT
*
FROM
v_material
WHERE
show_in_recent AND section_id IN (
SELECT
s.id
FROM
section AS s, section AS s2
WHERE
s2.id = 842
AND
s.breadcrumb @ s2.breadcrumb
)
ORDER BY
published_on DESC
LIMIT 3;
Use JOIN sherlock.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Sep 29, 2010 at 5:22 AM, p...@bastian-s.de wrote:
Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
replication provider (Master) and receiver (client) at the same time?
You can implement such a replication using Slony-1.
--
Sent via pgsql-general mailing list
I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
Basically , assuming that psql doesn't show me that FKs are disabled
some code was using 'trigger all' instead of 'user'.
Is that a bug of psql, or a feature ? As far as I can see
pg_catalog.pg_constraint doesn't contain
Adam Wizon adamwi...@mac.com writes:
Thanks for the fast reply. I must have still been connected to the older
database somehow. I cleaned up my installation and restored the database.
No error messages this time. I need to change the pg_hba.conf file. I read
the documentation and its
Where would I type 'show hba_file'? I'm on Mac. Also I downloaded the
distribution from postgresql.org. If I run an initdb and I already restored a
database, will it put the pg_hba.conf file in the 'data' folder?
Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0
Adam
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes:
I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
Basically , assuming that psql doesn't show me that FKs are disabled
some code was using 'trigger all' instead of 'user'.
I think that is today's lesson in
If I run the admin tool from my postgres account, that works fine since
postgres is the owner.
Cc: pgsql-general@postgresql.org
Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0
Thanks for the fast reply. I must have still been connected to the older
database somehow.
2010/9/29 Tom Lane t...@sss.pgh.pa.us:
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes:
I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
Basically , assuming that psql doesn't show me that FKs are disabled
some code was using 'trigger all' instead of
Hello,
I've been writing an application that allows me to edit simple maps. It
involves Postgis but here I think I have run into
a basic Postgres consideration.
I did a bit of editing of a map which involved creating a polygon with a
selection, inserting into a database and reloading
the
On 9/29/2010 11:31 AM, Henri De Feraudy wrote:
Hello,
I've been writing an application that allows me to edit simple maps. It
involves Postgis but here I think I have run into
a basic Postgres consideration.
I did a bit of editing of a map which involved creating a polygon with a
selection,
On Wed, Sep 29, 2010 at 12:38 PM, Andy Colson a...@squeakycode.net wrote:
On 9/29/2010 11:31 AM, Henri De Feraudy wrote:
Hello,
I've been writing an application that allows me to edit simple maps. It
involves Postgis but here I think I have run into
a basic Postgres consideration.
I did a
On 29 Sep 2010, at 18:31, Henri De Feraudy wrote:
I mean, if you are inserting into a table from PLPGSQL do you have to do an
explicit commit at some stage?
I suppose you meant psql here, as otherwise the above statement wouldn't make
sense ;)
Alban Hertroys
--
Screwing up is an excellent
Could someone explain why the following doesn't work?
test=# PREPARE meow(unknown) AS
test-# SELECT $1 as meow;
ERROR: could not determine data type of parameter $1
The problem is that using PDO in PHP, prepared statements aren't
possible if values are used instead of columns in the select
On 09/29/2010 12:10 PM, Oleg Bartunov wrote:
Christian,
On Wed, 29 Sep 2010, Christian Ramseyer wrote:
Hi List
I have a largish partitioned table, it has ~60 million records in each
of 12 partitions. It appears that a Full Text Index could speed up
some user queries a lot.
A quick test with
On Wed, Sep 29, 2010 at 07:08:22PM +0100, Thom Brown wrote:
Could someone explain why the following doesn't work?
test=# PREPARE meow(unknown) AS
test-# SELECT $1 as meow;
ERROR: could not determine data type of parameter $1
The problem is that using PDO in PHP, prepared statements
On 29 September 2010 19:15, Peter Bex peter@xs4all.nl wrote:
On Wed, Sep 29, 2010 at 07:08:22PM +0100, Thom Brown wrote:
Could someone explain why the following doesn't work?
test=# PREPARE meow(unknown) AS
test-# SELECT $1 as meow;
ERROR: could not determine data type of parameter $1
On 09/25/2010 07:03 AM, Tom Lane wrote:
reyreyw...@optonline.net writes:
Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
regards, tom lane
I agree that that
On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
Okay, I understand what's happening. But does the planner need to
understand the type of literals in the select list if it's not used
anywhere else?
Fields sent back to the client also carry their type with them.
There's no unknown
On 29 September 2010 19:41, Peter Bex peter@xs4all.nl wrote:
On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
Okay, I understand what's happening. But does the planner need to
understand the type of literals in the select list if it's not used
anywhere else?
Fields sent back
Are there any commands to see the created index info?
For example, if I have a table A (has 100,000 tuples )with index A_INDEX,
how to see the A_INDEX info, such as the deep of B+ tree?
peng
Peter Bex peter@xs4all.nl writes:
On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
Okay, I understand what's happening. But does the planner need to
understand the type of literals in the select list if it's not used
anywhere else?
Fields sent back to the client also carry
On 29 September 2010 20:02, Tom Lane t...@sss.pgh.pa.us wrote:
Peter Bex peter@xs4all.nl writes:
On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
Okay, I understand what's happening. But does the planner need to
understand the type of literals in the select list if it's not
Hello everyone,
We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
use OIDs to identify a row. I'm planning on adding a serial column to the
tables and modifying the code to use the serial column instead. But I am
curious to find out how close we are before the OID
Howdy,
Does anyone know of any tools or methods to handle centralized user management
within postgres?
I've got about 20 DB servers (and growing) each requiring a different number
and level of user access
(think dev, qa, staging, production, etc.)
Corporate security guidelines state that all
On Wed, 2010-09-29 at 14:21 -0700, David Kerr wrote:
Howdy,
Does anyone know of any tools or methods to handle centralized user
management within postgres?
I've got about 20 DB servers (and growing) each requiring a different number
and level of user access
(think dev, qa, staging,
On Wed, Sep 29, 2010 at 02:23:14PM -0700, Joshua D. Drake wrote:
- Howdy,
-
- Does anyone know of any tools or methods to handle centralized user
management within postgres?
-
- I've got about 20 DB servers (and growing) each requiring a different
number and level of user access
-
Hello,
I've installed the PostgreSQL 9.0 binary package for Windows XP 32-bit
and I'm trying to install the temporal extension module available in
pg_Foundry. One problem I can see that I'm running into is that the
path defined for PGXS in pg_config does not exist:
PGXS = c:/program
On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J
jjtur...@statestreet.com wrote:
Hello,
I’ve installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and
I’m trying to install the temporal extension module available in
pg_Foundry. One problem I can see that I’m running into is that
I am playing with the replication on 9.0 and running into the following.
I have a primary that is running at a colo, and is replicated down to a
secondary here using SLONY. This is working normally.
I decided to set up a replication of the SLONY secondary onto my
sandbox machine to see what I
On Wed, 2010-09-29 at 20:04 -0500, Karl Denninger wrote:
Sep 29 19:58:54 dbms2 postgres[8564]: [2-2] STATEMENT: update post set
views = (select views from post where number='116763' and toppost='1') +
1 where number='116763' and toppost='1'
Sep 29 20:01:11 dbms2 postgres[8581]: [2-1] ERROR:
The log from make shows
echo #define PGBINDIR \/opt/PostgreSQL/9.0/bin\ pg_config_paths.h
echo #define PGSHAREDIR \/opt/PostgreSQL/9.0/share/postgresql\
pg_config_paths.h
echo #define SYSCONFDIR \/opt/PostgreSQL/9.0/etc/postgresql\
pg_config_paths.h
echo #define INCLUDEDIR
Dianne Yumul dia...@wellsgaming.com writes:
We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
use OIDs to identify a row. I'm planning on adding a serial column to the
tables and modifying the code to use the serial column instead. But I am
curious to find out
On 9/29/2010 8:55 PM, Jeff Davis wrote:
On Wed, 2010-09-29 at 20:04 -0500, Karl Denninger wrote:
Sep 29 19:58:54 dbms2 postgres[8564]: [2-2] STATEMENT: update post set
views = (select views from post where number='116763' and toppost='1') +
1 where number='116763' and toppost='1'
Sep 29
Rob Sargent rsarg...@xmission.com writes:
echo #define SYSCONFDIR \/opt/PostgreSQL/9.0/etc/postgresql\
SYSCONFDIR is a place where you might choose to put some handmade
configuration files, but the standard installation doesn't put anything
there. So offhand I don't see a reason why it
50 matches
Mail list logo