Magnus Hagander [EMAIL PROTECTED] writes:
If I remember correctly, after a few where's this new release snafus,
the order of the day now is to silently release the new version,
announcing it on -hackers only, until all the ftp mirrors have updated,
then to announce it publicly when all the
Pat Maddox wrote:
I want to start using slony for replication, and have a question about
setting table IDs when creating replication sets. The docs say that
you have to be careful in what IDs you assign to the tables - if
there's a relationship between two tables, the parent needs to have a
Benjamin Arai wrote:
Hi,
I upgraded to 8.2.4 but there was no significant change in performance.
I did notice that hte query appears to be executed incorrectly.
I have pasted the EXPLAIN ANALYZE below to illustrate:
=# explain analyze select s_content,textdir from (SELECT * from
My colleague who speaks more C than me came up with the code below
which works fine for us. Will the memory allocated for lexeme be freed
Nice, except self-defined utf8 properties. I think it will be much better to use
pg_mblen(char*). In this case your dictionary will work with any supported by
On Tue, 24 Apr 2007 11:14:43 +1200
Andrej Ricnik-Bay [EMAIL PROTECTED] wrote:
On 4/24/07, Felix Kater [EMAIL PROTECTED] wrote:
Hi,
the messages returned by PQerrorMessage() contain a trailing new
line. So, they doesn't nicely integrate into strings formatted by
printf.
Is there a
On 4/24/07, Mageshwaran [EMAIL PROTECTED] wrote:
I want to do replication using WAL , please tell the methods by which
log shipping is done ie moving the wal files to slaves and executing it.
Not possible at the moment: the log shipping facility that was
introduced in 8.2 only lets you set up
Dear all,
About the pg_buffercache view:
I couldn't find the description for this view in the manual at
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
However I found the readme file provided in the /contrib./pg_buffercache of
the source code for version 8.2.3
Here it's written
On 4/24/07, Richard Huxton [EMAIL PROTECTED] wrote:
Pat Maddox wrote:
I want to start using slony for replication, and have a question about
setting table IDs when creating replication sets. The docs say that
you have to be careful in what IDs you assign to the tables - if
there's a
Sounds like theoretically it could matter, but in practice it doesn't.
I'd like a more definite answer though.
You could ask the slony guys directly ;) They'd know a lot more about it
than the pg-general list would.
http://lists.slony.info/mailman/listinfo
--
Postgresql php tutorials
Pat Maddox wrote:
Sounds like theoretically it could matter, but in practice it doesn't.
I'd like a more definite answer though.
Well, most of the locking issues with Slony seem to be with
administrative commands (setting up a replication set, altering it)
which require taking locks. If your
Hi,
I am trying to use cursors and I am really frustrated already. Do I
need to install an extension?
1. Problem number one is that what ever I use in front of the fetch
command it is not being accepted, it gives a syntax error. If I use a
number ,all or forward it gives an error
Hello,
I have a problem with backing up a database. The original db runs on a SuSE
ES 9 box in Unicode. Version 7.4.2
The recovery db is supposed to run on a windows xp box. The encoding is
UTF-8. Version 8.1
On the linux box I did:
pg_dumpall outfile
On the windows box I did:
psql -f
Hello,
I am writing an application that reads information from my PostgreSQL
database. If I cause the program to crash and the program ends without
gracefully disconnecting from the database, there is an open connection
still left in the database.
How does the PostgreSQL server handle clients
I did already, but this still does not help me write a simple while loop
that goes through all data and stops at the last row.
Joris Dobbelsteen wrote:
See the postgresql documentation at:
http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html
-Original Message-
Anton Andreev wrote:
Hi,
I am trying to use cursors and I am really frustrated already. Do I
need to install an extension?
No, you just need to have a look at the docs.
http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING
1. Problem number
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
Dear all,
About the pg_buffercache view:
I couldn't find the description for this view in the manual at
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
However I found the readme file provided in the
Dear Mr. Bill Moran,
Thank you for your answer.
1) To be more clear I would like to construct a query using the reldatabase
column. In that query you quoted I can't identify the reldatabase column. I
want a query that will help me to list how many buffers are used by each
database
Peter Neu wrote:
Hello,
I have a problem with backing up a database. The original db runs on a SuSE
ES 9 box in Unicode. Version 7.4.2
If you're keeping this installation, see about upgrading to the latest 7.4.x
The recovery db is supposed to run on a windows xp box. The encoding is
UTF-8.
On Tue, Apr 24, 2007 at 05:53:02AM -0700, Jeff Lanzarotta wrote:
Hello,
I am writing an application that reads information from my PostgreSQL
database. If I cause the program to crash and the program ends without
gracefully disconnecting from the database, there is an open connection
still
Jeff Lanzarotta wrote:
Hello,
I am writing an application that reads information from my PostgreSQL
database. If I cause the program to crash and the program ends without
gracefully disconnecting from the database, there is an open connection
still left in the database.
How does the PostgreSQL
OK, thanks. I figured the server would at some point in time clear the
connection up, my question now is when does that happen? Any idea how
long the connection sit around before the server cleans it up? Someone
else said possibly an hour...
--- Magnus Hagander [EMAIL PROTECTED] wrote:
On Tue,
Hey guys,
I needed to implement an audit trail engine and decided to do it on the
database layer.
I already have a basic but fully functional audit trail system implemented
on my PostgreSQL 8.2 server. It has been done using PL/PGSQL
and triggers and it works pretty well.
Here's what I need to
On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote:
OK, thanks. I figured the server would at some point in time clear the
connection up, my question now is when does that happen? Any idea how
long the connection sit around before the server cleans it up? Someone
else said
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's
plenty of SYSV memory available.
The call to
OK, that is what the other fellow said... It depends on the TCP/IP
stack...
Thanks again for the clarification.
--- Magnus Hagander [EMAIL PROTECTED] wrote:
On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote:
OK, thanks. I figured the server would at some point in time clear
Don't forget to cc: the mailing list.
Peter Neu wrote:
Hello,
thanks for the fast reply. This works. I don't really need the dumpall
because I usually just back up one db.
I noticed the dump is now a binary file. Means that I will have to migrate
to 7.4.17 if this is the preferable release
On Wed, 2007-04-18 at 16:43 -0400, Bill Moran wrote:
In response to Drew Myers [EMAIL PROTECTED]:
I've been given a task to build a couple of geographically separate
servers, which are capable of replicating data between each other.
I've surfed through various google results, and
In response to Brad Nicholson [EMAIL PROTECTED]:
On Wed, 2007-04-18 at 16:43 -0400, Bill Moran wrote:
In response to Drew Myers [EMAIL PROTECTED]:
I've been given a task to build a couple of geographically separate
servers, which are capable of replicating data between each other.
Hi,
I wanted to setup a simple generic type trigger. What a mean by generic
is that i don't want to hardcode the
NEW.column or OLD.column calls, i searched for a way to loop over
the NEW/OLD rowtypes but could not figure out how it should be done.
This led me to attempt to do it in a way which
On Tue, Apr 24, 2007 at 07:16:38AM -0700, Jeff Lanzarotta wrote:
OK, that is what the other fellow said... It depends on the TCP/IP
stack...
Thanks again for the clarification.
Note, there are two cases. If only the program crashes but the system
is fine, the kernel will close the socket for
On Tue, Apr 24, 2007 at 05:35:09PM +0200, Andy Dale wrote:
Hi,
I wanted to setup a simple generic type trigger. What a mean by generic
is that i don't want to hardcode the
NEW.column or OLD.column calls, i searched for a way to loop over
the NEW/OLD rowtypes but could not figure out how it
Andy Dale wrote:
Hi,
I wanted to setup a simple generic type trigger. What a mean by generic
is that i don't want to hardcode the
NEW.column or OLD.column calls, i searched for a way to loop over
the NEW/OLD rowtypes but could not figure out how it should be done.
Don't use plpgsql - that's
I am trying to use cursors and I am really frustrated already. Do I
need to install an extension?
No, it's all in the documentation:
http://www.postgresql.org/docs/current/static/plpgsql-control-structures
.html#PLPGSQL-RECORDS-ITERATING
1. Problem number one is that what ever I use in front
Martijn van Oosterhout [EMAIL PROTECTED] writes:
The only time the server will wait for a time out is if the server and
the client are on different machines and something disrupts actual
communications.
Right, you need connectivity loss to create an issue --- a client
program crash doesn't
I forgot to add the link to the article I've mentioned:
http://www-128.ibm.com/developerworks/db2/library/techarticle/0302stolze/0302stolze.html#section2b
This is what I'd like to do on PostgreSQL,
Thanks,
Marcelo.
On 4/24/07, Marcelo de Moraes Serpa [EMAIL PROTECTED] wrote:
Hey guys,
I
So it looks like the STOPPING of the service actually
succeeded, albeit
it took a while (more than the usual sessions open?). The
STARTING is
the one that actually failed (is that because the STOP was still in
process?). The question is why -- in a RESTART situation
Thanks for the quick response, i think will try it with python or perl.
Cheers,
Andy
On 24/04/07, Richard Huxton [EMAIL PROTECTED] wrote:
Andy Dale wrote:
Hi,
I wanted to setup a simple generic type trigger. What a mean by
generic
is that i don't want to hardcode the
NEW.column or
Can WAL files be used to create/update a warm standby on a different minor
version of PostgreSQL (eg, using files from a server running 8.2.3 on an
8.2.4 server, or vice-versa?)
I suspect this is a FAQ, but I didn't see it in the docs on WALs and PITR
(section 23.3)
--
Mike Nolan
George Pavlov [EMAIL PROTECTED] writes:
i have examined the stop() and start() and i think i understand why the
stop() reported a failure (it took to long), but i don't understand how
the start() could have reported success:
Stopping postgresql service: [FAILED]
Starting postgresql service:
hi all,
I installed postgresql 8.2.3 in a freebsd server, my client application is
written in C++ builder + zeoslib and I haven't any problem until now, but now
with 8.2.3 version I have many connection that remains in FIN_WAIT_2, any
suggest?
regards,
Enrico
---(end of
On Tuesday 24 April 2007 10:57, Michael Nolan [EMAIL PROTECTED] wrote:
Can WAL files be used to create/update a warm standby on a different
minor version of PostgreSQL (eg, using files from a server running 8.2.3
on an 8.2.4 server, or vice-versa?)
I suspect this is a FAQ, but I didn't see
Marcelo de Moraes Serpa wrote:
Here's what I need to do: Somehow save the user_id of the **application**
user who have done the update/delete action to the log row.
I've read an article on IBM's developer site which teaches how to do just
that (get the application's user id and save it the
Marcelo de Moraes Serpa [EMAIL PROTECTED] writes:
I forgot to add the link to the article I've mentioned:
http://www-128.ibm.com/developerworks/db2/library/techarticle/0302stolze/0302stolze.html#section2b
This is what I'd like to do on PostgreSQL,
So, translating it to a simpler example:
Thank you for the replies.
@Richard: I've thought about having one DB user for each APP user. However,
a coworker told me that it would infeasible to do that on the web
enviroment, specifically for J2EE where a DB connection pool is used, so I
gave up on that.
@Jorge: Is this connection id you
On Tue, 2007-04-24 at 09:02 +0530, Mageshwaran wrote:
Hi ,
I want to do replication using WAL , please tell the methods by which
log shipping is done ie moving the wal files to slaves and executing it.
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
--
Brad
Marcelo de Moraes Serpa [EMAIL PROTECTED] writes:
@Richard: I've thought about having one DB user for each APP user. However,
a coworker told me that it would infeasible to do that on the web
enviroment, specifically for J2EE where a DB connection pool is used, so I
gave up on that.
Why?
Is it possible at all to use conditional joins in views?
ie:
select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
(a.otherfield ?) )
I have a few 15-20 table joins that i'd like to push into views.
i've never wanted to push something with a conditional join into a
view before,
I have a server running Windows Server 2003 32-bit that has 8GB of
memory. Our system administrator installed PAE (Physical Address
Extensions) which I know MS SQL Server will use, but I'm not sure if
PostgreSQL will.
Can PostgreSQL use the memory above 2GB and 4GB?
Am Dienstag, 24. April 2007 21:43 schrieb Jonathan Vanasco:
Is it possible at all to use conditional joins in views?
ie:
select a.* , b.* from a inner join b ON ( (a.id = b.id) AND
(a.otherfield ?) )
I have a few 15-20 table joins that i'd like to push into views.
i've never wanted
I'm considering re-architecting a database to make use of many, many
schemas over time, it would probably grow to be on the order of 3,000
or so, with each schema holding ~100 tables. Is that an absurd amount, or
well within postgres' limits? I haven't been able to find any information
on
Well, that makes sense: if the shutdown took more than a
minute then the
stop script action would give up waiting, and then the
start action
would see the postmaster running and go away happy. (It's a bit odd
that service start actions are supposed to treat already running
as OK, but
Marcelo de Moraes Serpa [EMAIL PROTECTED] writes:
Hey guys,
Mine is an web application - three tier. The app connects to the db using
only one user and it has it's own authentication system and doesn't
rely on the database for user management.
I solved the problem using a C program and
I am experiencing a blocking situation in my database (Postgresql 8.1.8
on Redhat). When I do a ps -ef|grep postgres I see two processing
that are idle in transaction and they stay there indefinitely.
I'm running JBoss (the problem is in JBossMQ) and I'm having trouble
pinpointing the
guys,
i want to log some data everyday. for this i can do 1 of 2 things:
1) i can create an empty 'template' table and copy it everyday before
data logging including defaults.
# including constraints (thanks greg) doesn't work but more on that later.
helps-
i avoid spending more time on lengthy
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marcelo de
Moraes Serpa
Sent: dinsdag 24 april 2007 21:06
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Audit-trail engine: getting the
application's
Roger,
This statement runs but the table isnt actually updated. Slightly odd.
I ran the subquery, which makes perfect sense and nothing was
returned. If I remove the AND temp.id junctions.id part I get loads
of results returned but if I run the update with the the adjusted
subquery I get ERROR:
On Apr 23, 12:31 am, [EMAIL PROTECTED] (Tom Lane) wrote:
[EMAIL PROTECTED] writes:
When I try to initiate tsearch2 in 8.2.4, I got the following error.
ERROR: incompatible library /usr/local/pgsql/lib/tsearch2.so:
missing magic block
Apparently you have a pre-8.2 version installed in
On Apr 23, 2:10 am, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote:
On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote:
[EMAIL PROTECTED] writes:
When I try to initiate tsearch2 in 8.2.4, I got the following error.
ERROR: incompatible library /usr/local/pgsql/lib/tsearch2.so:
On Apr 23, 4:11 pm, [EMAIL PROTECTED] wrote:
On Apr 23, 2:10 am, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote:
On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote:
[EMAIL PROTECTED] writes:
When I try to initiate tsearch2 in 8.2.4, I got the following error.
ERROR:
In running a query I receive the error:
ERROR: variable not found in subplan target lists
The version is 8.1.5
I can find references to this message. Seems there was a bug in older
versions. Should I be finding this in 8.1.5? Any advice?
Thank you and much appreciated.
Mark
On Monday 23 April 2007 01:21, Mageshwaran wrote:
Hi ,
I am new to postgresql, I have been assigned a task of upgrading
postgresql to higher version.
In our company we are using 7.1.1,7.1.3,7.4.5 versions of postgresql,
can you please tell me which is the stable and suitable version in 8.x
Hi,
Here is my first table:
Table1
name| ids
-
Peter| 2, 3, 4, 5
Jack| 100, 34, 3
Both name and ids are in text format.
Here is my second table
Table2
id | Flag | Title
-
2 | Red| good
3 | Blue | poor
4 | Green| middle
id is in integer
Hi,
Apparently, the amount of free space on the partition makes a big
difference in performance. I went from about 30% free space to about
5% and this triggered the performance issues. As soon as freed up
the drive to about 30% free space again the performance issues went
away.
Ben [EMAIL PROTECTED] writes:
I'm considering re-architecting a database to make use of many, many
schemas over time, it would probably grow to be on the order of 3,000
or so, with each schema holding ~100 tables. Is that an absurd amount, or
well within postgres' limits? I haven't been
Mike Goldner [EMAIL PROTECTED] writes:
Is there any way to increase the debug logging or issue a query so that
I could find the actual select statements that are idle?
Huh? Idle in transaction means there *isn't* any active SQL statement
--- those backends are waiting for the next client
Angva [EMAIL PROTECTED] writes:
In running a query I receive the error:
ERROR: variable not found in subplan target lists
Please provide a complete test case.
regards, tom lane
---(end of broadcast)---
TIP 6: explain
66 matches
Mail list logo
