On 09/27/10 11:18 PM, novnovice wrote:
That's a surprising response. But it makes sense, at least as one
perspective. I have written light duty sync systems but figured that there
would be some battle tested postgresql solution that was more robust than I
could cobble together. As in, if I inves
Hello
see
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
Regards
Pavel Stehule
2010/9/28 AI Rumman :
> I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump.
> But now I found that, most of the queries in my applicaiton are being
> failed.
On 28 September 2010 07:37, AI Rumman wrote:
> I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump.
> But now I found that, most of the queries in my applicaiton are being
> failed. Invesitigating the problem, I found that no function is available in
> the DB to CAST INT to TEXT e
I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump.
But now I found that, most of the queries in my applicaiton are being
failed. Invesitigating the problem, I found that no function is available in
the DB to CAST INT to TEXT etc.
Most of the queries are failed because implicit ca
On 28/09/10 11:25, Tim Uckun wrote:
> On Tue, Sep 28, 2010 at 3:39 PM, Tom Lane wrote:
>> Tim Uckun writes:
>>> Is there a way to tell postgres to stop any query that runs longer
>>> than a specified amount of time? Say an hour?
>>
>> Setting statement_timeout would do that. You ought to figure
That's a surprising response. But it makes sense, at least as one
perspective. I have written light duty sync systems but figured that there
would be some battle tested postgresql solution that was more robust than I
could cobble together. As in, if I invest 40 hours learning replication
system X,
[Please keep the thread on the mailing list]
For the stackbuilder, are you behind any proxy? Can you open the url mentioned
in the error message via your browser? You can set the appropriate proxy values
on the first page of stackbuilder.
Slony-I Path will be where your slony binaries reside.
On 09/27/10 8:08 PM, novnovice wrote:
Can anyone recommend a relatively simple merge replication package that would
work well on windows and which relies on one of the current postgresql
versions? 9 would be fine for my needs. I'm a fairly unsophisticated
postgresql user; and not very experience
On 09/27/2010 03:37 AM, Tom Lane wrote:
Kevin Jardine writes:
I have a query structured like this:
SELECT stuff FROM
(SELECT more stuff FROM
table1
ORDER BY field1) AS q1
INNER JOIN table2 ON ( ... )
and have found that the INNER JOIN is ignoring the order set for q1.
The final results ar
On Sep 27, 2010, at 23:20 , Tim Uckun wrote:
>> Why are you messing with ctid? Does the table have no key? If not, you
>> should fix that first.
>>
>
> I got the idea from here
>
> http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks
If your table already has a key (some column or combinat
On Tue, Sep 28, 2010 at 3:39 PM, Tom Lane wrote:
> Tim Uckun writes:
>> Is there a way to tell postgres to stop any query that runs longer
>> than a specified amount of time? Say an hour?
>
> Setting statement_timeout would do that. You ought to figure out
> what's causing the performance proble
Can anyone recommend a relatively simple merge replication package that would
work well on windows and which relies on one of the current postgresql
versions? 9 would be fine for my needs. I'm a fairly unsophisticated
postgresql user; and not very experienced with replication on other
databases. S
> Why are you messing with ctid? Does the table have no key? If not, you should
> fix that first.
>
I got the idea from here
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
On Sep 27, 2010, at 22:08 , Tim Uckun wrote:
> update to_be_deleted set mark = true where ctid = any (array( select
> ctid from to_be_deleted limit 10));
Why are you messing with ctid? Does the table have no key? If not, you should
fix that first.
Michael Glaesemann
grzm seespotcode net
-
Tim Uckun writes:
> Is there a way to tell postgres to stop any query that runs longer
> than a specified amount of time? Say an hour?
Setting statement_timeout would do that. You ought to figure out
what's causing the performance problem, though, instead of just
zapping things ...
>
> The other thing that just hit my mind, is that you mind need to bump
> up work_mem a bit, just for the session. so
> SET work_mem=32M
>
>
> and that should make it slightly faster.
I tried the method suggested. I created a table of IDs and a field
called "mark". I indexed both fields.
Then
On 09/27/10 6:36 PM, Mike Christensen wrote:
Thus, the users table already has:
MikeChristensen1
MikeChristensen2
MikeChristensen3
MikeChristensen4
I want to write a SQL query that figures out that MikeChristensen5 is
the next available username and thus suggest it. Here's some things I
could
Thanks! That looks like what I need..
On Mon, Sep 27, 2010 at 6:29 PM, mark wrote:
> Try http://www.pgadmin.org/download/macosx.php
> ?
>
>
> ..: Mark
>
>
>
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike C
Hi all -
Let's say the user signs up for an account on my site and they need to
pick a unique user name. They type in:
MikeChristensen
However, me and several of my dopplegangers already have accounts.
Thus, the users table already has:
MikeChristensen1
MikeChristensen2
MikeChristensen3
MikeCh
Try http://www.pgadmin.org/download/macosx.php
?
..: Mark
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen
Sent: Monday, September 27, 2010 6:42 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL]
I'd like to run pgAdmin on my Mac, however, I don't want to run
Postgres Server. I've found if I do the one-click install on OS/X, it
installs everything and doesn't really give me an option to just
install client tools.
1) Is there a way to install just pgAdmin?
2) Is there a way to uninstall j
On Tue, Sep 28, 2010 at 12:37 AM, Tim Uckun wrote:
>> If the table is large, I sometimes use the following pattern:
>
> The table is very large so I will use your advice thanks.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> ht
I have a situation where there are dozens of daemons hitting the same
postgres database. They all run different types of queries but each
daemon runs the same set of queries over and over again.
Sometimes some queries get "stuck" in that they run for hours and
hours. They never stop running. Kil
> If the table is large, I sometimes use the following pattern:
The table is very large so I will use your advice thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sep 27, 2010, at 8:02 , Tim Uckun wrote:
> What is the best strategy for deleting orphaned records from a large table.
>
> The usual NOT IN is very slow so there must be a better way in
> postgres for dealing with these.
If the table is large, I sometimes use the following pattern:
1. Creat
On 9/27/2010 4:53 PM, Tom Lane wrote:
The reason it tells you that data will be destroyed is that that could
very well happen.
Re-parsing this, I think there was a mis-communication :
I'm not at all suggesting that the doc should _not_ say that data will
be corrupted.
I'm suggesting that in
On 9/27/2010 4:53 PM, Tom Lane wrote:
The reason it tells you that data will be destroyed is that that could
very well happen. If the system decides to put new data into what will
appear to it to be an empty page, then the damaged data on disk will be
overwritten, and then there's no hope of re
David Boreham writes:
> On 9/27/2010 4:40 PM, Jeff Davis wrote:
>> zero_damaged_pages is not meant as a recovery tool. It's meant to allow
>> you to pg_dump whatever data is not damaged, so that you can restore
>> into a fresh location.
> It'd be useful for future generations if this were inclu
On 9/27/2010 4:40 PM, Jeff Davis wrote:
It does zero the page in the buffer, but I don't think it marks it as
dirty. So, it never really makes it to disk as all-zeros.
Ah ha ! This is certainly consistent with the observed behavior.
zero_damaged_pages is not meant as a recovery tool. It's me
Hi -
I use Dave Page's one-click installers for Mac OS X:
http://www.enterprisedb.com/products/pgdownload.do#osx
I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will
not load because it is looking for Perl 5.10 in the System dirs and I
only have 5.8.8:
$ ./createlang
On Mon, 2010-09-27 at 15:07 -0600, David Boreham wrote:
> Is the zero_damaged_pages feature expected to work in 8.3.11 ?
>
> I have a fair bit of evidence that it doesn't (you get nice messages
> in saying that the page is being zeroed, but the on-disk data does not
> change).
> I also see quite
Is the zero_damaged_pages feature expected to work in 8.3.11 ?
I have a fair bit of evidence that it doesn't (you get nice messages
in saying that the page is being zeroed, but the on-disk data does not
change).
I also see quite a few folk reporting similar findings in various form
and mailing
Gurjeet Singh wrote:
On Sun, Sep 26, 2010 at 9:37 PM, Tom Lane wrote:
The SQL standard explicitly disavows any particular
output row order unless there is a top-level ORDER BY. (In fact,
unless things have changed recently an ORDER BY in a sub-select isn't
even legal per spec.)
Following up on other replies, and agreeing that SQL has no inherent row
ordering and it is only by accident that you are seeing such ...
The *only* way to reliably preserve sort order is by explicitly encoding the
order in your data, by maintaining a column or columns through to the outermost
On Sun, Sep 26, 2010 at 9:37 PM, Tom Lane wrote:
>
> The SQL standard explicitly disavows any particular
> output row order unless there is a top-level ORDER BY. (In fact,
> unless things have changed recently an ORDER BY in a sub-select isn't
> even legal per spec.)
>
>
Not sure about the SQL s
Hi all,
Having a little problem with my large objects. In 8.4 the db owner was
'andy', but my web connected as payuser (which had appropriate permissions).
The backup/restore to pg9 made all the large objects owned by 'andy',
and I'm guessing payuser does not have select rights.
GRANT seem
Please keep the thread on the mailing list.
On Mon, Sep 27, 2010 at 5:59 PM, Padmanabha, Shruthi (UMKC-Student)
wrote:
> Hello Dave,
>
> I was trying to install PostgreSQl 8.4.4-1 on my Windows 64bit Vista machine.
> The machine does not have Microsoft Visual C++ installed on it . I did not
> f
> -Original Message-
> From: Kevin Jardine [mailto:kevinjard...@yahoo.com]
> Sent: Sunday, September 26, 2010 3:15 PM
> To: pgsql-general@postgresql.org
> Subject: Preserving order through an inner join
>
> I have a query structured like this:
>
> SELECT stuff FROM
> (SELECT more stuf
I'm testing pg_upgrade out and ran into a couple of problems. First when I
did pg_upgrade --check I got the tsearch2 tables preventing the upgrade from
happening:
Database: testdatabase
public.pg_ts_dict.dict_init
public.pg_ts_dict.dict_lexize
public.pg_ts_parser.prs_start
public.pg_t
prior to 8.4 not in will be slow. Just use left join.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Oleg Bartunov writes:
> We never expected gevel will be used by users :-)
It's very very useful when developing custom GiST indexes!
--
dim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
Get gevel from cvs, address is on http://www.sai.msu.su/~megera/wiki/Gevel
btw, have you seen http://www.sai.msu.su/~megera/wiki/Rtree_Index ?
Oleg
On Mon, 27 Sep 2010, paolo wrote:
Hi all,
we are making some experiments with postgresql and postgis. We need to
visualize R-trees and are tryin
Hello,
If you have used EnterpriseDB's One Click Installer to install PostgreSQL 8.4,
then you can use Stackbuilder to install Slony for PG 8.4.
For making Slony work with pgAdmin, you need to put the Slony-I path in the
options file of pgAdmin. Open File Menu --> Options --> [In General Tab] S
Hello, I have some problems using character class matching (e.g. [:alpha:]).
For example I have a table:
CREATE TABLE re_test (text_column character varying (50) NOT NULL);
Notice, that there is some specific characters.
INSERT INTO re_test VALUES ('AŠDF');
INSERT INTO re_test VALUES ('AŠDF45')
Hi all,
we are making some experiments with postgresql and postgis. We need to
visualize R-trees and are trying to use GiST and gevel. During the
installation phase of gevel we had the following output:
sed 's,MODULE_PATHNAME,$libdir/gevel,g' gevel.sql.in >gevel.sql
gcc -no-cpp-precomp -O2 -Wall
Hi,
I have downloaded slony-I(slony-I-2.0.2R-pg84.zip) from the site
http://developer.pgadmin.org/~hiroshi/Slony-I/. But when I tried to
create a new Replication cluster using PgAdmin(After doing all other
steps mentioned in http://www.pgadmin.org/docs/1.8/slony-example.html )
the 'OK' button i
Hey Andre,
Try pg_dump -a --inserts ...
// Dmitriy
-
The voice input and output is very good in this
http://www.tomtop.com/black-ps3-wireless-bluetooth-headset-for-playstation-3.html?aid=z
Wireless PS3 Headset . It is compatible with all PS3 games.Buy from Reliable
http://www.tomtop.c
Looks like package was lost during transition.
I am rebuilding it, and I'll let you know when I upload it.
Regards,
-
The voice input and output is very good in this
http://www.tomtop.com/black-ps3-wireless-bluetooth-headset-for-playstation-3.html?aid=z
Wireless PS3 Headset . It is compat
Hi all,
we are making some experiments with postgresql and postgis. We need to
visualize R-trees and are trying to use GiST and gevel. During the
installation phase of gevel we had the following output:
sed 's,MODULE_PATHNAME,$libdir/gevel,g' gevel.sql.in >gevel.sql
gcc -no-cpp-precomp -O2 -Wall
On 9/27/2010 6:51 AM, Devrim GÜNDÜZ wrote:
They are ready:
http://yum.pgrpms.org/8.3/redhat/rhel-5-x86_64/repoview/pg_filedump.html
http://yum.pgrpms.org/8.3/redhat/rhel-5.0-i386/repoview/pg_filedump.html
Thanks !
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Sun, 2010-09-26 at 22:17 -0600, David Boreham wrote:
>
> As far as I can see there is no pre-built pg_filedump binary for the
> PDGD yum repository (8.3.11 for RHEL5). Before I embark on building it
> from source I figured I'd ask here if I'm correct that there is no
> binary hidden somewhere
What is the best strategy for deleting orphaned records from a large table.
The usual NOT IN is very slow so there must be a better way in
postgres for dealing with these.
I know it's best not to have the orphans in the first place but in
this case it happened and I need to clean up before I can
On Sun, 2010-09-26 at 22:17 -0600, David Boreham wrote:
>
> As far as I can see there is no pre-built pg_filedump binary for the
> PDGD yum repository (8.3.11 for RHEL5). Before I embark on building it
> from source I figured I'd ask here if I'm correct that there is no
> binary hidden somewhere
On Sep 27, 2010, at 9:47 AM, David Boreham wrote:
>
> As far as I can see there is no pre-built pg_filedump binary for the PDGD yum
> repository (8.3.11 for RHEL5). Before I embark on building it from source I
> figured I'd ask here if I'm correct that there is no binary hidden somewhere
> in
On Sep 25, 2010, at 3:20 PM, Andre Lopes wrote:
> Hi,
>
> I need to generate the dump of a PostgreSQL database only with the data with
> INSERT's. It is possible to do this?
>
> Best Regards,
>
Use switch -a and --insert. For more information you can use pg_dump --help
Thanks & Regards,
Vi
On Mon, Sep 27, 2010 at 01:29, Heine Ferreira wrote:
> Hi
>
> Does Postgresql 9.0 still have the problem with the desktop heap on windows?
> I know you can extend the desktop heap on windows but Microsoft says on
> their web site you musn't extend it beyond 20K.
> That allows for about 300 connect
On Mon, Sep 27, 2010 at 6:30 AM, Padmanabha, Shruthi (UMKC-Student)
wrote:
> Hello,
>
>
>
> I was unable to install PostgreSQL 8.4.4 successfully. The error I received
> was “Database Cluster Initialisation Failed" error during PostgreSQL
> install”. I selected the windows version from the link
>
On Fri, 2010-09-24 at 11:35 -0700, prof_cleverson wrote:
>
> PGCluster installed but when connecting to the Load Balancer gives the
> error:
>
> Error connect to server:server closed the connection unexpectedly
> This probably means the server terminated abnormally before or while
> process the r
I realize that synchronous replication is in the works for 9.1, but
for 9.0, could you hack your way to synchronous replication by polling
the standby's pg_last_xlog_receive_location() and waiting until it's
>= pg_current_xlog_location() from your last transaction? Any major
pitfalls here (besides
59 matches
Mail list logo
