On Mon, 2004-10-18 at 14:49, Ed L. wrote:
I *think* I'm seeing vacuum analyze queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
No.
#vacuum_cost_delay = 0# 0-1000
On Oct 18, 2004, at 1:09 AM, Joel wrote:
There is no need to give either the postgres user or root a password,
much less a shell or a login directory, if you use sudo.
(And I have no idea why Apple would suggest using the system
preferences
user pane to add the postgres user unless they are
Hello
I know it is possible to time isolated queries through the settting of the
\timing option in psql. This makes PgSQL report the time it took to
perform one operation.
I would like to know how one can get a time summary of many operations, if
it is at all possible.
Thank you.
Tim
In the last exciting episode, [EMAIL PROTECTED] (Ed L.) wrote:
I *think* I'm seeing vacuum analyze queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
My settings:
On Sun, Oct 17, 2004 at 03:30:32 -0400,
Mike Mascari [EMAIL PROTECTED] wrote:
I'm thinking that the WHERE clauses condition should read:
WHERE l1.p_pkey is not null OR l2.p_key is not null;
That seems to make more sense. I was puzzling about that condition myself.
If both keys where not
Hello ppl,
Imagine some online system, based on PgSql. There are 'many' parts which
depends on each other. I will give small example, but instead of simple
table imagine changing tenths various tables (editing). So, 'change table A'
can be work for hours.
There are tables tableA and
Hello there,
I am thinking how to solve another typical problem of online systems
with combination of thin client... Imagine simple case, 2 users are going to
edit 'same' datas. Both see on the 'screen' the same, after they started
edit them. First one changes datas and submit changes
Is a dump and reload required when going from beta1 to beta3?
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I used to do it this way :
Suppose you have a web form to edit data from a table... you add a field
in your table which contains a version identifier for that data, then you
UPDATE ... WHERE ... AND version_id = the old version id. The version_id
is passed around in a session variable
in spite of the efforts of the french mailing list, an paper with some
grossieres erreurs...I apolgize
http://www.01net.com/article/253508.html
---(end of broadcast)---
TIP 6: Have you searched our list archives?
On Thu, Oct 14, 2004 at 08:58:32PM +0200, [EMAIL PROTECTED] wrote:
Hello
Does PostgreSQL provide anything comparable with the functionality of
MySQL Cluster?
I appreciate all information.
No, in two ways:
1. There is not currently any in-transaction cross-machine
replication system
Yes saying that PostgreSQL does not have any hot backup option ... testing a
RH-7.3 version in august 2004 when we are in v7.4.5 ... :o(
And it's one of the main computer science management newspaper in
France ... :o(
Le Lundi 18 Octobre 2004 18:58, Masse Jacques a écrit :
in spite of the
BiggerSQL is an advanced Cocoa based Postgresql Browser/Editor
for Mac OSX users.
BiggerSQL lives at http://homepage.mac.com/levanj/Cocoa
BiggerSQL is capable of displaying images, playing mp3s, displaying
movies and flash content. ie BiggerSQL is multimedia aware.
From this versions release
[EMAIL PROTECTED] (Lada 'Ray' Lostak) writes:
Imagine some online system, based on PgSql. There are 'many' parts which
depends on each other. I will give small example, but instead of simple
table imagine changing tenths various tables (editing). So, 'change table A'
can be work for hours.
On 10/15/2004 4:20 AM, Mark Gibson wrote:
Andrew Sullivan wrote:
On Wed, Oct 06, 2004 at 05:25:58PM +0100, Mark Gibson wrote:
I had to remove Slony's schema manually as I was having problems
with it. I was in the process of removing all Slony related stuff,
and all my slave tables when this
Some time ago (May 2004), we were making changes to a Postgresql server
to allow a host to connect (pg_hba.conf). When we restarted the server,
and restarted the AOLserver process, there was only one table left. All
the ACS tables were gone.
As we were troubleshooting the problem, we found the
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?
-Josh
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Are you looking for something different than vacuumdb?
http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
-tfo
On Oct 18, 2004, at 3:23 PM, Josh Close wrote:
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?
-Josh
---(end
On 10/18/2004 12:49 AM, Ed L. wrote:
I *think* I'm seeing vacuum analyze queries launched automatically on an
8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted).
Is this something new in 8.0 and to be expected?
Are you running Slony by any chance?
Jan
--
We thought that this might be an AOLserver problem, however, through our
investigation and comments from posts to the OpenACS board, we believe
this is an error with PostgresSQL.
We are hoping that someone might have some ideas or any experience with
this. Thanks!!
Are you vacuuming? How
It is possible to mainteners of this list to keep this list from
/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Now, we are invade with users that aren't used to read the
Eric wrote:
It is possible to mainteners of this list to keep this list from
/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Now, we are invade with users that aren't used to
Roberts, Adam [EMAIL PROTECTED] writes:
The following is a link to the last post we had with this same problem:
http://openacs.org/forums/message-view?message_id=185837
Given the comment about 500M pg_clog, I would venture that you aren't
doing adequate vacuuming and have therefore run into a
On Monday October 18 2004 2:39, Jan Wieck wrote:
On 10/18/2004 12:49 AM, Ed L. wrote:
I *think* I'm seeing vacuum analyze queries launched automatically on
an 8.0.0beta3 (unless I have a rogue autovac running that I haven't
spotted). Is this something new in 8.0 and to be expected?
Are
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
[EMAIL PROTECTED] wrote:
Are you looking for something different than vacuumdb?
http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
-tfo
I think so. As far as I can tell, you can either vacuum a whole db, or
individual tables.
On Mon, 2004-10-18 at 17:38 -0400, Eric wrote:
The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Isn't the purpose to promote PostgreSQL? not *nix-only flavors?
Hmm..other open source projects that run on Windows servers... apache,
Hmm..other open source projects that run on Windows servers... apache,
mysql, php, python, perl, etc etc etc... Porting it to Windows is a
great thing.. the more that open source gets its way into the use of all
markets, the more acceptable it becomes in the mainstream..and the less
control
Hello.
For a project we are planning cost management. Each user should pay
for the cost he/she generates on the postgresql server.
The idea is that a query should be charged by the ammount of CPU time
used and/or the ammount of data read from disk.
The acctual time (in milliseconds) it took to
hi,Gaetano Mendola:
you wrote:
Ann wrote: I found the reason of this question and fixed the bug :))
Why then don't you share it ?
em ,because i make a stupid mistake in programming!! :((
I made use of transactions to ensure database consistency, and then, i called PQexec() to
Please forgive me if I'm posting to the wrong mailing list. I am working
with Windows XP and the beta2-dev3 version of PostgreSQL. The issue I am
having is under a login name that has administrative rights to the machine
the program is running on (a program I wrote), database access is allowed
and
I try to detect potential memory management bugs of my program with valgrind.PostgreSQL is at version 8.0 beta2. Operating System is Red Hat Enterprise Linux 3.Valgrind is at version 2.2.0.
After Program terminated, Valgrind reports a memory lost error information as follows:
==13524== 208 bytes
Michael Hannon wrote:
Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat
Enterprise server, version 3.0). We find ourselves in an awkward
position: we have a database of attributes relating to students that
uses as its primary key the ID number of the student. This is
Hi,
We would like use Postgresql as
our database. For high availability is it possible to cluster DB in Postgresql.
Appreciate if you can let me know how this can be achieved.
Else is there any other way to achieve High Availability
in POstgresql as this is mission critical system.
Hello,
I'm using postgreSQL 8.0 beta1 and JDK 1.4.
I have following problem:
I have create test table that contains only unique column :
CREATE TABLE UNIQUE_COLUMN_TEST (
TEST_ID INTEGER,
CONSTRAINT TEST_ID_UQ UNIQUE (TEST_ID)
)
Within one transaction I have insert a few records
I'm a first-time user with PostgreSQL so please forgive my ignorance.
I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL
Essential Reference (New Riders). So far, so good. I think learning
PostgreSQL will not be as difficult as I thought it would be. I've also
been
Magnus, et al.,
This is, what initdb -d says:
listing
D:\tmp\datainitdb -d
Running in debug mode.
VERSION=8.0.0beta3
PGDATA=d:/tmp/data
share_path=c:/msys/1.0/share/postgresql
PGPATH=c:/msys/1.0/bin
POSTGRES_SUPERUSERNAME=postgresql
POSTGRES_BKI=c:/msys/1.0/share/postgresql/postgres.bki
I am unable to use the CREATE USER command with numeric user names
(i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
a problem somewhere with how I have things configured? Is there are
workaround?
Any help would be greatly appreciated.
--
Ed
Thanks Martijn:
It worked. I was having issues with 7.4.2, run memory ans disk checks
and hardware seems ok, that's why I decided to upgrade to 7.4.5, but
unfortunately I'm still experiencing data corruption.
Ruben.
ruben20 wrote:
-- Forwarded Message ---
From: Martijn van
Hi,
It seems to me that
a bug was introduced in 8.0 version.
(I was previously
using 7.2.3 so I don't really know in which version the comportment
changed...).
I'm using Beta2 version on WIN32 platform.
I'm not sure where to find it exactly, but does anyone know how much
data a column of type text in a postgres DB can hold?
Thanks
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
On Wed, 2004-10-13 at 06:31, Ed Stoner wrote:
I am unable to use the CREATE USER command with numeric user names
(i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
a problem somewhere with how I have things configured? Is there are
workaround?
A username is an
On Wed, 2004-10-13 at 14:58, John Ossmann wrote:
I'm not sure where to find it exactly, but does anyone know how much
data a column of type text in a postgres DB can hold?
There is no limit on what text itself can contain. However, a field of
any data type can contain at most 1GB (compressed --
hello, everyone
I know PgSQL dev team has no windows installer for the 8.0 version
except for the project in pgfoundry. I don't know how pgfoundry do it,
but I strongly sugguest the PgSQL team consider of using NSIS as the
installer tool. NSIS is an open source installer maker for windows, many
John Ossmann wrote:
I'm not sure where to find it exactly, but does anyone know how much
data a column of type text in a postgres DB can hold?
it's in the manual, in the Data Types section. the manual says around 1GB.
btw, TEXT is one of those postgres-specific features that makes you
stick
Google slony
Regards,
aaron.glenn
On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao
[EMAIL PROTECTED] wrote:
Hi,
We would like use Postgresql as our database. For high availability is it
possible to cluster DB in Postgresql. Appreciate if you can let me know how
this can be
Ah, yes. You're right.
Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.
-tfo
On Oct 18, 2004, at 6:02 PM, Josh Close wrote:
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
[EMAIL PROTECTED]
At 07:53 p.m. 11/10/2004, Marc G. Fournier wrote:
[snip]
As a result, for those using anoncvs, you will now be required to
re-checkout your source tree, as the paths stored by CVS in CVS/Root
throughout your tree will be wrong.
This was discussed beforehand on -hackers, but it appears that
47 matches
Mail list logo