-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There seems to be a disconnect between the mailing list and the
newsgroup right now. I received a bunch of replies via email that did
not show up in the newsgroup. (I did not receive any messages that were
sent to the mailing list and not to me
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with. Slony i presume, although schema
chanages are not propagated.
thanks
jef peeraer
--
Sent via pgsql-general
Hi,
I've been trying to get to the bottom of the differences between a vacuum and a
vacuum full, it seems to me that the difference is that a vacuum full also
recovers disk space(and locks things making it less than useful on production
servers). But I believe that both will fix the
Hello,
I am a developer working on postgres. I just wrote a function which ll
return a refcurosor as shown below.
CREATE OR REPLACE FUNCTION reffunc(refcursor)
RETURNS refcursor AS
$BODY$
BEGIN
OPEN $1 FOR SELECT * FROM SAM1;
RETURN $1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
On 05/08/2008 08:21, Jef Peeraer wrote:
would be the best option to go with. Slony i presume, although schema
chanages are not propagated.
Schema changes *are* propagated in Slony, using the EXECUTE SCRIPT
statement:
http://www.slony.info/documentation/stmtddlscript.html
Ray.
On Mon, Aug 04, 2008 at 05:00:31PM -0400, Rajarshi Guha wrote:
On Aug 4, 2008, at 4:55 PM, Francisco Reyes wrote:
select a.cid as ac, b.cid as bc, count(*) from aic_cid a left
outer join
aic_cid b on a.cid b.cid and a.id = b.id where b.cid is not null
group by
a.cid, b.cid order by
Is there anything simpler than processing the search_path to obtain
the same effect of
using namespace XXX
or if I'd like to execute the same set of operations on the same
objects just in a different schema?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general
Tom Lane [EMAIL PROTECTED] writes:
(Rather than trying to browbeat configure into
doing this, I'd suggest
manually adjusting CFLAGS in src/Makefile.global,
then make clean and
rebuild.)
eh? either of these should work fine:
./configure --enable-debug CFLAGS=-O0
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
(Rather than trying to browbeat configure into doing this, I'd suggest
manually adjusting CFLAGS in src/Makefile.global, then make clean and
rebuild.)
eh? either of these should
In response to Jef Peeraer [EMAIL PROTECTED]:
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with.
Your description of you requirements is very lacking, so much
On Tue, 5 Aug 2008, Bill Moran wrote:
In response to Jef Peeraer [EMAIL PROTECTED]:
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with.
Your
On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote:
Hi,
I've been trying to get to the bottom of the differences between a vacuum
and a vacuum full, it seems to me that the difference is that a vacuum full
also recovers disk space(and locks things making it less than useful on
production
In response to Jef Peeraer [EMAIL PROTECTED]:
On Tue, 5 Aug 2008, Bill Moran wrote:
In response to Jef Peeraer [EMAIL PROTECTED]:
i read about the replication possibilities with postgresql. If i just
need
some replication ( without failover stuff ) to 1 standby server, what
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
The trouble with that approach is that it overrides *everything* that
configure would normally put into CFLAGS. I only want one thing
changing, please ... this is confusing enough already.
Eh?
Sorry, memory failed
Hello,
In our application we need a pattern based text search, that is if user
supplies 'foo bar' he receives only documents containing words that begin
with 'foo' or 'bar', including themselves (something similar to MySQL '+foo*
+bar*' text search query). Currently we use separate table for
tsearch can help you; i have a system with it ... and its ok.
El mar, 05-08-2008 a las 18:03 +0400, Vyacheslav Kalinin escribió:
Hello,
In our application we need a pattern based text search, that is if
user supplies 'foo bar' he receives only documents containing words
that begin with
Vyacheslav Kalinin [EMAIL PROTECTED] writes:
In our application we need a pattern based text search, that is if user
supplies 'foo bar' he receives only documents containing words that begin
with 'foo' or 'bar'
There's support for prefix text search in CVS HEAD, but not in any
released version
Adrian Klaver wrote:
On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote:
WARNING: database mydb must be vacuumed within 177009986 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
mydb.Which is reason I ask the question, is full vacuum backup useful
for
On Tue, August 5, 2008 9:21 am, Jef Peeraer wrote:
i read about the replication possibilities with postgresql. If i just need
some replication ( without failover stuff ) to 1 standby server, what
would be the best option to go with. Slony i presume, although schema
chanages are not
On Tue, Aug 5, 2008 at 7:34 AM, Bill Moran
[EMAIL PROTECTED] wrote:
In response to Jef Peeraer [EMAIL PROTECTED]:
You'd probably be best with Slony, just don't replicate that 1 table
that you'll need to write to.
That's one of my favorite things about slony.
--
Sent via pgsql-general
Matthew T. O'Connor [EMAIL PROTECTED] writes:
On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote:
WARNING: database mydb must be vacuumed within 177009986 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
mydb.
BTW, what version of PostgreSQL is this?
Tom Lane wrote:
Matthew T. O'Connor [EMAIL PROTECTED] writes:
BTW, what version of PostgreSQL is this? Database-wide vacuum is no
longer required for XID wraparound issues. I think this was an 8.3
change but might have happened in 8.2, I don't remember.
8.2. But you could still get that
Matthew T. O'Connor [EMAIL PROTECTED] writes:
Tom Lane wrote:
8.2. But you could still get that message, even in CVS HEAD, if
autovacuum was failing to complete for some reason (and had been
failing for quite a long time).
Should that message to updated since a database-wide vacuum is no
Hi. I have a database that is created and populated by a Perl script.
(FWIW, the size of this database is about 12GB, according to
pg_database_size()).
If, right after the database is built, I connect to it and manually run
VACUUM ANALYZE, I get the warning
NOTICE: max_fsm_relations(1000)
In response to Kynn Jones [EMAIL PROTECTED]:
Hi. I have a database that is created and populated by a Perl script.
(FWIW, the size of this database is about 12GB, according to
pg_database_size()).
If, right after the database is built, I connect to it and manually run
VACUUM ANALYZE, I
Hi,
I have recently tried to install pgsql on Windows but I get the
following error consistently !
Error : psql : recieved invalid response to SSL negotiation !
This error is encountered as soon as I try to start psql ! The installation
completes fine , but I'm not able to do anything
I had to move my database to a new disk. I dropped the original after a pg_dump
and then removed the old directory. I then ran initdb on the new location,
created the database and restored from the pg_dump.
My problem now is that I have to supply the full pathnames to start or stop the
Bayless Kirtley wrote:
I had to move my database to a new disk. I dropped the original after
a pg_dump and then removed the old directory. I then ran initdb on
the new location, created the database and restored from the pg_dump.
My problem now is that I have to supply the full pathnames to
On Tue, Aug 5, 2008 at 12:45 PM, Bayless Kirtley [EMAIL PROTECTED] wrote:
I had to move my database to a new disk. I dropped the original after a
pg_dump and then removed the old directory. I then ran initdb on the new
location, created the database and restored from the pg_dump.
My problem
Hi,
Is Heikki's Visibility Map patch included for the Postgresql 8.4 version
http://archives.postgresql.org/pgsql-hackers/2007-11/msg00142.php
If not whats the status of that patch? Im especially interested in the
index-only scan mentioned there!!!
Thanks
Hello all,
I have C code which defines some user defined postgres functions. This
code has been used with Postgres version 7.4 and it uses the
VARATT_SIZEP macro.
I updated to Postgres version 8.3 and attempted to compile my C code and
noticed that the VARATT_SIZEP macro (which my code
http://privatepaste.com/cbY2S4JhtA
Very little difference with the -O0
__
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at
Yahoo!
On Tue, Aug 05, 2008 at 06:03:19AM +0200, Henry wrote:
just much simpler to use -- not as flexible and as powerful as Slony, but
if all you need to do is replicate some tables with minimum fuss and
without having to learn a new language, then Skytools (based on my
personal experience with a
On 8/5/08, Don Pannese [EMAIL PROTECTED] wrote:
I have C code which defines some user defined postgres functions. This code
has been used with Postgres version 7.4 and it uses the VARATT_SIZEP macro.
seems that macro was deprecated in 8.3... this is the commit that removed it:
What replaces the VARATT_SIZEP macro in version 8.3? I have
spent a long
time checking the documentation and have not found the
answer.
SET_VARSIZE
__
Not happy with your email address?.
Get the one you really want -
Hi,
i´m trying to do a trigger that its called when update or insert, that
update the tsvectors, for text-search. Here´s my code:
create table x(
cod serial,
texto text,
vectors tsvector,
constraint pk primary key(cod)
);
CREATE OR REPLACE FUNCTION atualiza_vectors() RETURNS trigger AS $$
Sim Zacks [EMAIL PROTECTED] writes:
Results below:
... but given that, I wonder whether the cost isn't from fetching
the toasted messageblk data, and nothing directly to do with either
the encode() call or the ~~ test. It would be interesting to compare
the results of
Okay, so subtracting
Glyn Astill [EMAIL PROTECTED] writes:
What replaces the VARATT_SIZEP macro in version 8.3? I have spent a
long time checking the documentation and have not found the answer.
SET_VARSIZE
Yes; you should always use VARSIZE() to fetch the length and
SET_VARSIZE() to set it. If you need your
On Tue, Aug 5, 2008 at 6:53 PM, Tom Lane [EMAIL PROTECTED] wrote:
There's support for prefix text search in CVS HEAD, but not in any
released version ...
regards, tom lane
Oh, does that mean it won't be released until 8.4?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I was reading the Wikipedia entry on GiST (http://
en.wikipedia.org/wiki/GiST) and it mentions
Although originally designed for answering Boolean selection queries,
GiST can also support nearest-neighbor search, and various forms of
Finally figured out what was wrong. The data folder had incorrect
permissions after unzipping the base backup. For me, the solution was
unchecking the Inherit from parent the permission entries that apply to
child objects option in the Advanced Security Settings dialog for the
data folder
41 matches
Mail list logo