Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

2008-03-26 Thread Alvaro Herrera
xec them. > If we are OK with restricting the scope of the "pg" program to > client-side functionality, then there's no problem. Perhaps we can put the server-side functionality on pg_ctl. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The Postgr

Re: [GENERAL] page is uninitialized --- fixing

2008-03-26 Thread Alvaro Herrera
> > That sort of looks like it could be data loss, can someone explain what > happened? It means someone extended the table, but didn't get around to actually putting tuples on it and committing. Four transactions were doing this when the system crashed. No co

Re: [GENERAL] PostgreSQL Replication with read-only access to standby DB

2008-03-26 Thread Alvaro Herrera
ch were a step towards that goal. (The point here is that a hot standby needs to be able to execute readonly transactions.) -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

2008-03-26 Thread Alvaro Herrera
o do. > Perhaps something like changing "postmaster" to "postgresqld", It is already called "postgres" on newer versions. > "pg_ctl" to "safe_postgresqld", Now that's plain weird. -- Alvaro Herrerahttp://w

Re: [GENERAL] Reindex does not finish 8.2.6

2008-03-26 Thread Alvaro Herrera
8.0 I'm not sure. Was this issue solved? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.p

Re: [GENERAL] postgresql is slow with larger table even it is in RAM

2008-03-25 Thread Alvaro Herrera
Please stop reposting your questions to multiple groups. Since all your questions are about performance, please stick to the pgsql-performance list. Posting to pgsql-sql is not really appropriate, and in pgsql-admin you're totally off-topic. -- Alvaro He

Re: [GENERAL] Checking if Aggregate exists

2008-03-24 Thread Alvaro Herrera
e argument type(s) as well. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] INFINITE RECURSION with rules...

2008-03-23 Thread Alvaro Herrera
srdjan wrote: > /* > *My goal is to calculate and insert automatically the value of "tot" > when I insert a row into table b.* > */ Use a trigger. It's a lot simpler. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Repl

Re: [GENERAL] MySQL to Postgres question

2008-03-22 Thread Alvaro Herrera
to a column after creation created issues, versus using the > serial type which did not. He is wrong in that you *can* attach the same information that SERIAL does if you use ALTER SEQUENCE .. OWNED BY after the fact. If you don't, then he's right. pg_dump d

Re: [GENERAL] dynamically generated SQL and planner/performance

2008-03-22 Thread Alvaro Herrera
's something like > execute select res fron functionB() into _res; > since the "complicated" part is inside each functionB I shouldn't > expect any great loss. > > Is it? Correct -- the part that's being discarded each time here is the SELECT that

Re: [GENERAL] dynamically generated SQL and planner/performance

2008-03-22 Thread Alvaro Herrera
/pgSQL does no caching at all for that query, and asks the planner for a new plan each time. Also, new in 8.3 is a facility for "plan invalidation", which means that every time the server executes something that makes that plan stale, the cache is dropped and the plan is rebuilt next time

Re: [GENERAL] shared memory/max_locks_per_transaction error

2008-03-17 Thread Alvaro Herrera
s how much shared memory the server will use. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] LOCK TABLE HELP

2008-03-17 Thread Alvaro Herrera
somebody already holds the lock, so your LOCK TABLE is just waiting for the holder to release it ... Have a look around the pg_locks view. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -

Re: [GENERAL] postgre vs MySQL

2008-03-14 Thread Alvaro Herrera
Steve Crawford escribió: > Alvaro Herrera wrote: >> Also, it is MVCC-safe only from 8.3 upwards; on older versions >> it (incorrectly) deletes dead tuples that are still visible to old >> transactions. > > More interesting. I may have a broken mental-model. I *thought

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread Alvaro Herrera
all methods and functions). Have I to Lock the table, perform some > operation on this table, and unlock the table all in the same function > scope? What do you mean it doesn't work? How exactly it fails? If anything, I'd suggest to send the LOCK TABLE in a separate PQexec() c

Re: [GENERAL] postgre vs MySQL

2008-03-14 Thread Alvaro Herrera
ey preprocess a different repository in order to create an obfuscated GPL source tree. (I have a memory of comments in the source that looked like it referred to some internal knowledge base or bug tracking system. But frankly it is a dim memory and could very well be related to the PHP source o

Re: [GENERAL] Reindex does not finish 8.2.6

2008-03-14 Thread Alvaro Herrera
Clodoaldo escribió: > 2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>: > > A quick look into pg_locks should tell you if it's blocking. > > pg_prepared_xacts is empty and pg_locks has 288 rows: > > # select locktype, mode, count(*) as total > from pg_locks gro

Re: [GENERAL] Reindex does not finish 8.2.6

2008-03-14 Thread Alvaro Herrera
Clodoaldo escribió: > Postgresql was restarted twice, but yes, it is as if the crash left > some kind of permanent lock somewhere. A prepared transaction perhaps? SELECT * FROM pg_prepared_xacts; A quick look into pg_locks should tell you if it's blocking. -- Alv

Re: [GENERAL] postgre vs MySQL

2008-03-13 Thread Alvaro Herrera
sactions. Of course, the main problem with CLUSTER is that it needs about 2x the disk space of table + indexes. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] Reindex does not finish 8.2.6

2008-03-13 Thread Alvaro Herrera
Clodoaldo escribió: > 2008/3/13, Alvaro Herrera <[EMAIL PROTECTED]>: > > Clodoaldo escribió: > > > > > > > Now what is happening is that reindex does not finish even with a > > > small 6,500 rows table and after a reboot. In top there is no CPU or

Re: [GENERAL] Reindex does not finish 8.2.6

2008-03-13 Thread Alvaro Herrera
Clodoaldo escribió: > Now what is happening is that reindex does not finish even with a > small 6,500 rows table and after a reboot. In top there is no CPU or > memory usage by postmaster and vmstat shows no disk activity. Hmm, are you vacuuming the system catalogs appropriately? -

[GENERAL] pgfoundry is down

2008-03-13 Thread Alvaro Herrera
Hi, pgFoundry seems down. Any chance you could take a look at it? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] postgre vs MySQL

2008-03-12 Thread Alvaro Herrera
al _need_ or it's there just because the other aspects of the system are so crappy. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] Trouble with Savepoints in postgres

2008-03-12 Thread Alvaro Herrera
Please always ensure that the list is copied on replies (use "Reply to all") so that other people can help you. sam escribió: > On Mar 11, 5:39 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > sam escribió: > > > > > Iam not able to understand if this i

Re: [GENERAL] Trouble with Savepoints in postgres

2008-03-11 Thread Alvaro Herrera
sam escribió: > Iam not able to understand if this is a version problem or the way iam > using savepoints is wrong.Please advice. It is. You cannot use savepoints in PL/pgSQL functions (or any function for that matter). You can use EXCEPTION clauses instead. -- Alvaro H

Re: [GENERAL] Database OID xxxxx now seems to belong to "foo"

2008-03-11 Thread Alvaro Herrera
e system shuts itself down (but autovac gets a chance to fix the problem for you before that happens, even if it's turned off). Perhaps it's a bug fixed between 8.2.0 and 8.2.6 (which is why you should upgrade), but perhaps it hasn't been discovered yet. So pleas

Re: [GENERAL] gsoc ideas

2008-03-10 Thread Alvaro Herrera
an do this or not.). I don't think this is very interesting because you can do pg_dump -t foo | psql -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general maili

Re: [GENERAL] Ask ctid

2008-03-10 Thread Alvaro Herrera
, 1 This would be a bug. Please post the unmodified output of select ctid, xmin, xmax, cmin, cmax, id_absensi, id_user, tanggal from absensi The ctid column must differ because it is the physical address of the tuple. -- Alvaro Herrerahttp://www.Command

Re: [GENERAL] v8.3 + UTF8 errors when restoring DB

2008-03-10 Thread Alvaro Herrera
indows-1252 Most likely, your source data is not Win1252 but some other different encoding, so the pg_dump/pg_restore into a Win1252 database mangled it. Perhaps you oughta initdb the new database with the same encoding that the original database had, or declare the client_encoding on the pg_restore

Re: [GENERAL] Changing column names in tables 2

2008-03-05 Thread Alvaro Herrera
attnum >0 and > attrelid= ( from above query) Don't do that. It's far better to create a shell script, or PL/pgSQL function, whatever suits you, to get the table/column names from the catalog and then produce the ALTER TABLE commands you need. Playing directly with the catalogs

Re: [GENERAL] Removing Users and Revoking Privileges

2008-02-29 Thread Alvaro Herrera
't solve your problem; I'm just mentioning it in case you're looking for reasons to migrate to a newer version. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcas

Re: [GENERAL] errors in pg_restore on windows?

2008-02-29 Thread Alvaro Herrera
the end of the restore as errors. > > Are you saying they are really just warnings? They only mean that the debugger functions could not be loaded. If you're not using the debugger, they are irrelevant -- in a way, they are "just warnings". -- Alvaro Herrera

Re: [GENERAL] partitioning using dblink

2008-02-28 Thread Alvaro Herrera
veloper.skype.com/SkypeGarage/DbProjects/PlProxy -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

Re: [GENERAL] "=" or ":=" ?

2008-02-28 Thread Alvaro Herrera
find any > information about "=". It's exactly the same. := is the documented way, but = is also accepted and behaves identically. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] initlocation on windows

2008-02-28 Thread Alvaro Herrera
tlocation or tell me what I'm doing wrong please. initlocation hasn't existed since a few years. The current way to do what you want is to use CREATE TABLESPACE: http://www.postgresql.org/docs/current/interactive/sql-createtablespace.html -- Alvaro Herrera

Re: [GENERAL] what happens if something goes wrong in transaction?

2008-02-28 Thread Alvaro Herrera
A B escribió: > Hi. newbie question, but what will happen if I do > > begin work; > select ... > insert ... > and so on... > commit > > and somewhere a query fails. will I get an automatic rollback? Of course. -- Alvaro Herrerah

Re: [GENERAL] Regarding interval conversion functions and a seeming lack of usefulness

2008-02-27 Thread Alvaro Herrera
Bill Moran wrote: > It just seemed like this would be something so common that there'd > be something in existence already. I guess I was wrong. Yeah, I have wished for the same thing myself. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The Postgre

Re: [GENERAL] autovacuum not freeing up unused space on 8.3.0

2008-02-27 Thread Alvaro Herrera
-- duplicating the original index DROP INDEX index; which does not need to grab a lock for a long period. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)

Re: [GENERAL] utf8 issue

2008-02-26 Thread Alvaro Herrera
Y transaction_import, line 59358 Did you try setting client_encoding beforehand? I think a simple PGOPTIONS="client_encoding=latin9" pg_restore ... should suffice. Now, if you have mixed UTF8 and Latin1/Latin9 data, you are hosed (meaning you'll have to wade through the stuff an

Re: [GENERAL] autovacuum not freeing up unused space on 8.3.0

2008-02-26 Thread Alvaro Herrera
ALYZE on the first place? If it's just to see how many dead space there is, I suggest you peek into pg_stat_user_tables instead, which is less invasive. Autovacuum itself should run ANALYZEs as needed (and you can, of course, tune it if you feel it's not frequent enough in the default confi

Re: [GENERAL] autovacuum not freeing up unused space on 8.3.0

2008-02-25 Thread Alvaro Herrera
s its task. For this to happen you need to be doing ALTER TABLE or similar however; normal UPDATE/INSERT/DELETE should not cause autovacuum to cancel itself. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Developme

Re: [GENERAL] no-arg cluster and locks ...

2008-02-24 Thread Alvaro Herrera
_locks, pg_stat_activity, the deadlock message? (Hmm, it would be helpful if the deadlock checker were to save the pg_locks contents and perhaps pg_stat_activity in a file, whenever a deadlock is detected.) -- Alvaro Herrerahttp://www.

Re: [GENERAL] text and bytea

2008-02-22 Thread Alvaro Herrera
lperl is nice however. Perhaps we could get around the problem by using byteaout/textin. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Analogue to SQL Server UniqueIdentifier?

2008-02-19 Thread Alvaro Herrera
things in the same package, and we don't have any interest in porting most of the stuff only to get something that we can get more easily by hooking into Windows native calls. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prom

Re: [GENERAL] dynamic crosstab

2008-02-19 Thread Alvaro Herrera
.4? How about returning generic rows? Is that possible? It would be really neat if you didn't have to specify the return type in the query that invoked the crosstab. I keep wondering if there's a way to "pivot" (transpose) a result set defined by the standard. -- Alvaro Herrer

[GENERAL] greylisting no longer working?

2008-02-19 Thread Alvaro Herrera
Hi, It seems the greylisting setup stopped quarantining emails? I'm getting a lot more spam in pgsql-hackers and the other lists I moderate, and nothing in the headers suggest that they were greylisted at all. Did something happen? -- Alvaro Herrera

Re: [GENERAL] SPI-functions and transaction control

2008-02-18 Thread Alvaro Herrera
RY blocks. There are many fine details here, perhaps too many if you're not battered enough in C. I think I would suggest trying to do it purely with SQL, temp tables, etc. If you can afford a table lock, it could be a lot easier and faster than setting a savepoint per tuple. -- Alvaro

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-18 Thread Alvaro Herrera
ndling IIRC in 7.3 (or was it 7.2?) was a big change for pg_dump, and I don't think we would have liked to backpatch the pg_dump changes. Also, AFAIK the sequences stuff with OWNED BY also needed the newer pg_dump, which is more recent (8.2?). I don't think it's as rare as y

Re: [GENERAL] PG quitting sporadically!!

2008-02-15 Thread Alvaro Herrera
s one clue; this is the other: > LOG: test message did not get through on socket for statistics collector > LOG: disabling statistics collector for lack of working socket This is a bad sign. For one thing, it means autovacuum, if enabled, is not really working at all (which can, in t

Re: [GENERAL] dynamic crosstab

2008-02-14 Thread Alvaro Herrera
it, but I know it is supposed to be a replacement to SPSS). -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 4: Have you search

Re: [GENERAL] SELECT CAST(123 AS char) -> 1

2008-02-13 Thread Alvaro Herrera
Ken Johanson wrote: > Alvaro Herrera wrote: >> If you are arguing that the spec's definition of the CHARACTER type is >> not really very useful, I think you are going to find a lot of >> supporters. You can send your complaints to the SQL committee; but >> then, i

Re: [GENERAL] SELECT CAST(123 AS char) -> 1

2008-02-13 Thread Alvaro Herrera
the SQL committee; but then, it is unlikely that this is going to change anytime soon because of the fear of breaking backwards compatibility. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. --

Re: [GENERAL] Storing images as BYTEA or large objects

2008-02-13 Thread Alvaro Herrera
Koen Vermeer wrote: > The large-objects-are-actually-files thing applies to my situation, so > unless there is some 'large objects are / will be deprecated' argument, > I guess I stick with large objects. Certainly there is no such argument.

Re: [GENERAL] Storing images as BYTEA or large objects

2008-02-13 Thread Alvaro Herrera
th the client and server. To get the bytes back unescaped, I think you could use a binary cursor. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of bro

Re: [GENERAL] character conversion problem about UTF-8-->SHIFT_JIS_2004

2008-02-13 Thread Alvaro Herrera
ourself -- see src/backend/utils/mb/Unicode. I think you would have to edit the sjis-0213-2004-std.txt file to add those characters, then run UCS_to_SHIFT_JIS_2004.pl to generate the updated .map file, then regenerate the shared lib at src/backend/utils/mb/conversion_procs/utf8_and_shift_

Re: [GENERAL] 8.3 and uuid: unable to run uuid-ossp.sql

2008-02-13 Thread Alvaro Herrera
g your distribution packages, which would likely put it in /usr/lib or another well-known place where you won't need any of these additional fixups. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.

Re: [GENERAL] end of life for pg versions...

2008-02-12 Thread Alvaro Herrera
Ivan Sergio Borgonovo wrote: > On Tue, 12 Feb 2008 16:15:23 -0300 > Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > > Ivan Sergio Borgonovo wrote: > > > > > Is it just vaporware... maybe... but still there are pros and > > > cons of having a bland sche

Re: [GENERAL] end of life for pg versions...

2008-02-12 Thread Alvaro Herrera
Ivan Sergio Borgonovo wrote: > Is it just vaporware... maybe... but still there are pros and cons of > having a bland schedule for EOL and new releases. We do have a schedule: http://developer.postgresql.org/index.php/PostgreSQL_8.4_Development_Plan -- Alvaro H

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > I don't find this very surprising ... I would suggest using "reindex > > index" for each index instead. I'm not sure if REINDEX TABLE is > > supposed to be deadlock-free. > &g

Re: [GENERAL] Some Autovacuum Questions

2008-02-12 Thread Alvaro Herrera
ble to read the vaccuming or analyzing state of a given > table manually? Are there any indicatores in statistic tables, wich > the autovacuum demaon is using too wich can show me the progress of a > running autovacuum? Yes, they are kept in pg_stat_all_tables.

Re: [GENERAL] Working with huge amount of data. RESULTS!

2008-02-12 Thread Alvaro Herrera
from this random garbage to make it easier for > indexing? Using trigrams perhaps? Try checking whether pg_trgm fits your needs. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Alvaro Herrera
database 163880909; blocked by process 32450. I don't find this very surprising ... I would suggest using "reindex index" for each index instead. I'm not sure if REINDEX TABLE is supposed to be deadlock-free. -- Alvaro Herrerahttp://www.Com

Re: [GENERAL] oids

2008-02-11 Thread Alvaro Herrera
8.3 -- you may want to try that. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] pg_stat_activity xact_start and autovacuum

2008-02-11 Thread Alvaro Herrera
processes apart in pg_stat_activity. Perhaps we could have added a column in pg_stat_activity indicating processes that don't hold old tuples, but I feel that would have been a little too much. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_stat_activity xact_start and autovacuum

2008-02-11 Thread Alvaro Herrera
pg_stat_activity should be NULL... > Why does it matter? Monitoring. It's good to know the age of oldest > running transaction, and autovacuuming is well, adding noise. Autovacuum certainly uses transactions ... ?? -- Alvaro Herrerahttp://www.Comm

Re: [GENERAL] Kernel kills postgres process - help need

2008-02-10 Thread Alvaro Herrera
ications), what is the best way to process with a pooler ... > install one on each node or one on each database ? I don't really know the answer to this, but if you have one per database server, then all the web nodes are going to share the connections to that databa

Re: [GENERAL] POLL: Women-sized t-shirts for PostgreSQL

2008-02-08 Thread Alvaro Herrera
e PG polo shirts >> available. > > O.k., o.k. :) I will look into costs. Hmm, did this go anywhere? I still look for the shiny new Pg polos on the mail every day, only to be disappointed. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Com

Re: [GENERAL] Fossology Install & Config Issues...

2008-02-07 Thread Alvaro Herrera
al=localhost user=fossy > password=fossy' > Connection status: '1' > ERROR: Failed to open database Weird. Are you sure you are connecting to the same postmaster? i.e. are the port settings the same? -- Alvaro Herrerahttp://www.CommandProm

Re: [GENERAL] Kernel kills postgres process - help need

2008-02-07 Thread Alvaro Herrera
r do you recommand, and what will be the improvement for > us ? The two most recommended ones I've seen around here are pgbouncer and pgpool. I think pgbouncer is supposed to perform better, at the cost of not having certain bells and whistles (which you may not need anyway). -- Alvaro

Re: [GENERAL] PostgreSQL 8.3.0 RPMs are available for download

2008-02-06 Thread Alvaro Herrera
use the openSUSE build service to build the RPMs for other distros too (the various Fedoras, CentOS, RHEL); they advertise it as working for that, though I wasn't able to find an actual list of supported distributions. -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] Lets get the 8.3 Announcement on the front page of Digg

2008-02-05 Thread Alvaro Herrera
uy is the Postgres Architect? Hmm, I'm guessing there are still a lot of things that are directly related to Stonebraker's work. I'm fairly sure there were code comments about PostQUEL commands somewhere. -- Alvaro Herrerahttp://www.CommandPromp

Re: [GENERAL] Is my db dead ?

2008-02-05 Thread Alvaro Herrera
? Before you start randomly zeroing stuff, do you have any files in pg_clog? What does that directory look like? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)-

Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Alvaro Herrera
them >> together. > I did essentially that, outside of make, for ppc/i386 doing 2 separate builds > and then using lipo to join each file in bin and lib. Sure looks like this should be doable with only Makefile rules. I very much doubt it would be pain

Re: [GENERAL] Is my db dead ?

2008-02-05 Thread Alvaro Herrera
CET > Time of latest checkpoint:Thu 11 Jan 1116953 03:46:31 CET > LC_COLLATE: > LC_CTYPE: What's the full pg_controldata output? Can you send the pg_control file as a binary attachment? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Rep

Re: [GENERAL] commit fails, rollback needed?

2008-02-04 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > Hi, > > when committing a transaction returns with an error: Do I have to > rollback the transaction in this case? No; it is already rolled back. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Co

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Alvaro Herrera
gresqlconference.org and planetpostgresql.org (etc) mean. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 3: Have you checked our extensive F

Re: [GENERAL] PGSQL ERROR: FATAL: terminating connection due to administrator command

2008-02-04 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > Alvaro Herrera wrote: >> It's not unlikely that the server is crashing. This should not happen. >> Please examine the logs and let us know what you find. >> >> If it's indeed crashing, we would like to see a more complete report >

Re: [GENERAL] backup tableoids (pg_class.oid) ?

2008-02-04 Thread Alvaro Herrera
y that there will be an additional hurdle when trying to restore, because the referenced table would not have been created in the first place. That said, IMHO the idea of storing metadata as part of data is a bad idea. -- Alvaro Herrerahttp://www.CommandPromp

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Alvaro Herrera
Dave Page wrote: > Even a new domain seems odd to me - if this is to be official, then > surely it should be under postgresql.org. +1 -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(

Re: [GENERAL] PGSQL ERROR: FATAL: terminating connection due to administrator command

2008-02-04 Thread Alvaro Herrera
processing the request. It's not unlikely that the server is crashing. This should not happen. Please examine the logs and let us know what you find. If it's indeed crashing, we would like to see a more complete report (possibly including a backtrace from a core dump). -- Alvaro Her

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-01 Thread Alvaro Herrera
g/certification program. Regarding Cesar Villanueva, I bet you can reach him at [EMAIL PROTECTED] -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)---

Re: [GENERAL] Dump schema without the functions

2008-02-01 Thread Alvaro Herrera
e > newly created via > > pg_restore -l geodataportal.public | grep -v FUNCTION > > pgdump.geodataportal.public.no-func > > has only the TOC. But no data... Then you feed that file to pg_restore -L, along the original dump file. -- Alvaro Herrera

Re: [GENERAL] PL/Tcl implementation

2008-01-31 Thread Alvaro Herrera
tool fits the bill. If you cannot find out at a keystroke where to find the definition of NameStr() you are doomed [to take a lot longer to understand what's going on]. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL C

Re: [GENERAL] Log file permissions?

2008-01-31 Thread Alvaro Herrera
Vivek Khera wrote: > > On Jan 31, 2008, at 10:21 AM, Alvaro Herrera wrote: > >> I think you should be able to chmod the files after they have been >> created. The postmaster changes its umask to 0077, so no file is >> group-readable. I don't think is configurabl

Re: [GENERAL] Log file permissions?

2008-01-31 Thread Alvaro Herrera
er changes its umask to 0077, so no file is group-readable. I don't think is configurable either. Perhaps we should add a log_file_group option, to which we would chgrp() the log files. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company -

Re: [GENERAL] [ADMIN] Backup

2008-01-31 Thread Alvaro Herrera
> Simon Riggs wrote: >> As far as I am concerned, if any Postgres user loses data then we're all >> responsible. Remember, our license says this software is given without any warranty whatsoever, implicit or explicit, written or implied, given or sold, alive or deceased.

Re: [GENERAL] Log file permissions?

2008-01-31 Thread Alvaro Herrera
t; how your distro does things (perhaps modifying the startup script). Actually, as of 8.0 there is specialized process that captures stderr and saves it to log files. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Dev

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-30 Thread Alvaro Herrera
vincent wrote: > True, but that only works for experienced 'nerds' who get a kick out of > connecting dots. Joe Average want's a bit more assistance, a bit more > guidance. Have you read the Tutorial section of the docs? What do you feel it is missing? Can you contr

Re: [GENERAL] [pgsql-advocacy] PostgreSQL professionals group at LinkedIn.com

2008-01-28 Thread Alvaro Herrera
1717C03 > > How is that different than the existing Postgres group? Is there an existing Postgres group? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end o

Re: [GENERAL] postgres 8.3 rc-1 ispell installation problem

2008-01-20 Thread Alvaro Herrera
marcelo Cortez escribió: > i've tried too with > convmv -f iso-8859-1 --notest -t utf-8 es_ES.dic > whitout success too. convmv only recodes the name of the file -- the content is not affected. To recode the file content you need iconv. --

Re: [GENERAL] plpythonu

2008-01-20 Thread Alvaro Herrera
s so much easier (and > less maintenance) to include it as a function. Having the trusted language does not mean you lose the untrusted one. We have both plperl and plperlu, for example. -- Alvaro Herrerahttp://www.CommandPrompt.com/ T

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-20 Thread Alvaro Herrera
h towards index insertion. I doubt we want to know _all_ the entries beforehand; that would probably involve disk-spilling, etc. Perhaps accumulate a reasonable number (using up to work_mem?) and insert those in batches. -- Alvaro Herrerahttp://www.CommandPrompt

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-18 Thread Alvaro Herrera
Dave Page wrote: > That said, is zlib used by toast or do we have some other code for > that? If it is used for that, do we record it's presence or absence in > pg_control? Nope, toast uses its own compression code. -- Alvaro Herrerahttp://www.Com

Re: [GENERAL] case dumbiness in return from functions

2008-01-18 Thread Alvaro Herrera
> if the standard doesn't specify any obligation to convert the name ? Actually I think the standard mandates case-folding (though to upper case rather than lower, i.e. the other way around) -- Alvaro Herrerahttp://www.CommandPrompt.com/

Re: [GENERAL] pg_dumpall

2008-01-17 Thread Alvaro Herrera
n dumping stuff; -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_dumpall

2008-01-17 Thread Alvaro Herrera
tabase's dump produced by pg_dumpall is, of course, self-consistent. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] testing the news gateway

2008-01-17 Thread Alvaro Herrera
Hello! This is just a test, please ignore. If you don't ignore it, I'll ignore you. Thanks, -- Alvaro Herrera ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] Sun's PostgreSQL contribution?

2008-01-16 Thread Alvaro Herrera
can be seen from time to time. They're not just marketing ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Alvaro Herrera
ad it if you say > yes. Did anything happen? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] 8.3-beta4, analyze and db owner

2008-01-15 Thread Alvaro Herrera
done according to your > comment. The message, if emited, should say then that only superuser > can analyze those tables. How about this patch. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development

<    6   7   8   9   10   11   12   13   14   15   >