[ADMIN] Problems creating users

2003-11-08 Thread alvaro
Hi, I got this little problem creating users: I want to connect to my db with a new user and I must create it like if he was a superuser, otherwise I can not conncet to my database. Could some body help me Thanks a lot Alvaro ---(end of broadcast

[ADMIN] Problem doing pg_dumpall

2003-11-22 Thread alvaro
d because of error pg_dumpall: pg_dump failed on dbsa, exiting How can I solve this problem? How can I tell what is the OID 102548365? is it related to an index or a table or what? I search the web looking for answers to these questions but I cludn't find them.

[ADMIN] SOS ---- Could you help me with postgresql.....????

2004-03-19 Thread alvaro
ed the max_connections to 150 (/var/lib/pgsql/data/postgresql.conf), could this be the the source of the problem???. Thanks a lot for your help. I'm sorry to bother you but your the only one "I know" that knows more about Postgresql than I (I'm l

Re: [ADMIN] SOS ---- Could you help me with postgresql.....????

2004-03-25 Thread alvaro
Mr. Szabo this is part of the output of the vacuumdb command DETAIL: dead row versions cannot be removed yet. There were unused item pointers. pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.02 sec. INFO: vacuuming "public.tbl_fact_consumos" INFO: index "ind_fact_consumos" now

[ADMIN] Problem doing pg_dumpall

2004-04-19 Thread alvaro
have to recover the schema and then all the data...? I know that maybe this not a big deal because in the worst case I can create the Indexes and constraints manually, but I really want to know why is that? Am I donig things wrong..? I hope you can help me... Thanks for taking some of y

Re: [ADMIN] SOS ---- Could you help me with postgresql.....????

2004-07-29 Thread alvaro
7;t exist but I restart postmaster several times and postmaster still iniocates that condition how can I fix this? Thanks a lot for your help, Alvaro ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] SOS ---- Could you help me with pg_resetxlog

2004-07-29 Thread alvaro
n undo the resetxlog operation -Please say yes...- Thanks a lot, Alvaro Thanks a lot for your help, Alvaro ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[ADMIN] Postgresql Server Restart continuously

2004-08-27 Thread alvaro
the hardware plataform is roboust (I guess) Dell power edge 6600, 16Gb RAM, SCSI RAID 5 (200Gb total), 4 cpus. Do you think that this values a correct or maybe one of those are the origin of the problem...? Thanks in advance, Alvaro ---(end of broad

Re: [ADMIN] Postgresql Server Restart continuously

2004-09-10 Thread alvaro
immediately, by now the error reported by the postgresql server does not appear anymore. Special Thanks to Mr. Tom Lane for your concern since we post a message for first time. Alvaro alvaro ( at ) audifarma ( dot ) com ( dot ) co writes: > I'm having some strange problem with a server po

Re: [ADMIN] Performances

2006-12-28 Thread Alvaro Herrera
ng looks like, depends on how exact you want the result to be. So the question to you is, what do you want that number for? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---

Re: [ADMIN] server process (PID xxx) was terminated by signal 7

2007-01-22 Thread Alvaro Herrera
> guess what signal 7 means. Please look in its /usr/include/signal.h > (or more likely, some sub-file that includes) to find out the symbolic > name of the signal, and report that. kill -l is mandated by POSIX to return the list of signal names and numbers. -- Alvaro Herrera

Re: [ADMIN] Upgrading to 8.2, changes in user/group management scripts

2007-01-22 Thread Alvaro Herrera
require a lot more in-depth intervention by myself and other staff. Instead of deleting stuff from pg_authid directly, use DROP ROLE. If this doesn't work because the role owns something, you may use a combination of DROP OWNED and REASSIGN OWNED. -- Alvaro Herrera

Re: [ADMIN] Problem with compiling postgresql-8.2.1

2007-01-31 Thread Alvaro Herrera
uot;postgresql-base" tarball or some such, which doesn't include the regression test files. Try downloading the full tarball (I don't know what is it named). I wonder if it isn't time to remove the split tarballs. Do they buy us anything? -- Alvaro Herrera

Re: [ADMIN] Is it normal for Autovacuum running continuously?

2007-02-13 Thread Alvaro Herrera
I doubt your performance problem is related to autovacuum. When you say "overall performance seems to be slow", it means you haven't actually measured individual queries and found that they are actually slow, no? > I'm running 8.1.4 on Redhat EL4.3. > > Is this normal

Re: [ADMIN] tabla pg_user Ayuda......

2007-02-14 Thread Alvaro Herrera
ase Con que usuario haces los VACUUM? Si no es un superusuario, se salta las tablas de sistema por no tener permisos. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end

Re: [pgsql-es-ayuda] [ADMIN] tabla pg_user Ayuda......

2007-02-14 Thread Alvaro Herrera
with ID 1 does not exist ja ja ja ... Baja postmaster y levanta una sesion en modo standalone. Creo que es postgres -P -O (Mira postgres --help; depende de la version). Ahi dentro puedes hacer el insert into pg_shadow, pero primero trata con CREATE USER. -- Alvaro Herrera

Re: [pgsql-es-ayuda] [ADMIN] tabla pg_user Ayuda......

2007-02-14 Thread Alvaro Herrera
er el cambio sin restricciones. Postmaster puede subir sin ningun superusuario, asi que podras levantarlo despues aunque no arregles el problema. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. --

Re: [pgsql-es-ayuda] [ADMIN] tabla pg_user Ayuda......

2007-02-14 Thread Alvaro Herrera
una sesion directamente. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgsql-es-ayuda] [ADMIN] tabla pg_user Ayuda......

2007-02-15 Thread Alvaro Herrera
Jaime Casanova escribió: > Alvaro, un vacuum como superusuario podria haber arreglado algo? o > hubiera tenido que borrar la tupla que pareciera mas vieja? o ninguna > de ambas podria haber funcionado? estoy asumiendo que el problema es > el que mencione arriba, no se me ocurre que

Re: [pgsql-es-ayuda] [ADMIN] tabla pg_user ...

2007-02-15 Thread Alvaro Herrera
is mailing list, so treat my letter only as suggestion. > :-) Sorry :-( I thought this was being discussed in the pgsql-es-ayuda list. If I've spammed the pgsql-admin list on spanish it's not been intentionally. I certainly don't have the time to translate everything we w

Re: [ADMIN] WAL files backup

2007-02-15 Thread Alvaro Herrera
Note that recovery.conf does not go into the share/ directory, but in data/. And it must be present _only_ when you want the system to attempt the recovery, not before. Also I didn't see any pg_start_backup() nor pg_stop_backup() calls in your procedure. --

Re: [ADMIN] WAL files backup

2007-02-16 Thread Alvaro Herrera
f you want to write in spanish, please use the pgsql-es-ayuda list and I'll be happy to help you there. If you want to stick to this list, please use english only. I find it hard to follow what you're doing in the format you're using. -- Alvaro Herrera

Re: [ADMIN] Built-in log rotation

2007-02-19 Thread Alvaro Herrera
ymore. > Does it perform a > copy/truncate of the logfile? I know in older versions of postgres, if > you tried to move the log file, and create one with the same name, the > server wouldn't actually write to it without a restart...at least in > linux it wouldn&

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Alvaro Herrera
to talk to previous server versions. That switch is there only for connecting to a database of a _newer_ version that pg_dump's, and it's generally problematic because sometimes an older pg_dump doesn't know how to read the newer system catalogs. -- Alvaro Herrera

Re: [ADMIN] [pgsql-es-ayuda] INSTALACION ADICIONAL POSTGRES

2007-03-14 Thread Alvaro Herrera
alar en /opt/postgres, pero lo mas probable es que te arroje el mismo error. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 1: if posting/reading th

Re: [ADMIN] [pgsql-es-ayuda] INSTALACION ADICIONAL POSTGRES

2007-03-15 Thread Alvaro Herrera
bla corrupta > > he copiado la carpeta global, de produccion al de prueba y funciona > bien ,, pero no puedo replicar el problema Por que no tratas de resolver el problema en la maquina en que se produce? -- Alvaro Herrerahttp://www.CommandP

Re: [ADMIN] [pgsql-es-ayuda] INSTALACION ADICIONAL POSTGRES

2007-03-15 Thread Alvaro Herrera
obre la maquina de produccion borro la tabla pg_shadow y la creo con el > dump que tengo del otro servidor funcionara ?? Que tiene que ver la tabla pg_shadow? La verdad es que como no has entregado ningun detalle sobre el problema de corrupcion de datos que tienes, no hay ninguna forma de dar

Re: [ADMIN] autovacuum question

2007-03-27 Thread Alvaro Herrera
dea what caused this? E.g. a postgres client > seeing an older version of the data? "Older" means that the postgres > client was started today and it saw the data from 2 days ago, then > suddenly it started to see the fresh data. Maybe because the

Re: [ADMIN] autovacuum question

2007-03-30 Thread Alvaro Herrera
;s done, it'll go away. Check the logs; if autovacuum is getting stuck on something (for example failing to start for some databases), then an error will be logged. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Compan

Re: [ADMIN] alter user log entry, too much information ;)

2007-04-06 Thread Alvaro Herrera
DT,594,idle LOG: statement: alter > user myadminuserid encrypted password 'myadminseridpw'; > > seems like the encrypted version of 'myadminseridpw' would be a good idea > in the log. Is there away to config that? No, but if you&#x

Re: [ADMIN] Bytea question

2007-04-11 Thread Alvaro Herrera
eceive text file > insert file into bytea field > insert trigger fires > - read file contents > - post contents into production tables > > Is this at all possible, or am I going to need to store the original file > and store/pass the file contents? -- Alvaro Herrera

Re: [ADMIN] Bytea question

2007-04-11 Thread Alvaro Herrera
Chris Hoover escribió: > No, I need to store the entire file as received into the database. Then you original question does not make any sense to me, because if you pass the entire file content, why would Postgres *not* be able to read it? > On 4/11/07, Alvaro Herrera <[EMAIL PROTECTE

Re: [ADMIN] Auto vacuum

2007-04-19 Thread Alvaro Herrera
disabled in pg_autovacuum? naptime set too high? I suggest you turn log_min_messages more verbose, to DEBUG2, and see if there are any entries in there regarding autovacuum. If it's running, you would see it. You would get a message after autovacuum_naptime seconds. How long is autovacu

Re: [ADMIN] Auto vacuum

2007-04-19 Thread Alvaro Herrera
Carol Walter wrote: > My pg_catalog.pg_autovacuum table contains no entries. Good. Now, are there autovacuum entries in the server log? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 supp

Re: [ADMIN] Auto vacuum

2007-04-19 Thread Alvaro Herrera
one. If it's not logging anything but planner statistics, then maybe those are the only things configured to be logged, which would be weird but I think it's possible. Change log_min_messages to debug2 and try again. A lot more messages should show up, including some about auto

Re: [ADMIN] Auto vacuum

2007-04-19 Thread Alvaro Herrera
m that query. > > select * from pg_settings where name = 'autovacuum'; Actually could you please try select * from pg_settings where name like 'autovacuum%'; so that all the other settings show up as well? -- Alvaro Herrerahttp://www.Com

Re: [ADMIN] infinite blocking statements in 8.2.3

2007-05-02 Thread Alvaro Herrera
itly) cant be killed. What are they doing? We've added interrupt checks in most of the loops, so queries can normally be killed quickly, but maybe we've missed just the one you're running. -- Alvaro Herrerahttp://www.CommandPrompt.com/ Postgre

Re: [ADMIN] VACUUM FULL ANALYSE hanging

2007-05-02 Thread Alvaro Herrera
the best option. It is also easier to do than dump/restore. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 7: You can

Re: [ADMIN] infinite blocking statements in 8.2.3

2007-05-03 Thread Alvaro Herrera
nough. Enough for what? You still haven't said what the problem was. I am unsure if I should be concerned. It now sounds like ordinary slowness caused by table bloat. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Compan

Re: [ADMIN] infinite blocking statements in 8.2.3

2007-05-10 Thread Alvaro Herrera
res is away however the dead process is further present. I can stop > these also only with kill -9. > > Does someone have an idea where the problem is and as I this to avoid can? Maybe now you can find the time to answer the questions. -- Alvaro Herrera

Re: [ADMIN] How overcome wait for vacuum full?

2007-05-15 Thread Alvaro Herrera
lating a month's worth of dead tuples), run a non-full vacuum more often (say, once a day or more). It doesn't lock the table so the app can continue to be online while it runs. If you have too many dead tuples and are desperate to get the table in a reasonable non-bloated state, try CLUST

Re: [ADMIN] How overcome wait for vacuum full?

2007-05-15 Thread Alvaro Herrera
Nick Urbanik wrote: > Thank you Alvaro, > > On 15/05/07 18:53 -0400, Alvaro Herrera wrote: > >Instead of waiting a month for the time when you can take the > >application offline (thus accumulating a month's worth of dead tuples), > >run a non-full vacuum more ofte

Re: [ADMIN] WAL file utilization question

2007-05-16 Thread Alvaro Herrera
s, except right after checkpoints as you noted. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will

Re: [ADMIN] What happens on a commit?

2007-05-22 Thread Alvaro Herrera
send This means that 60% of the time spent by system calls is due to network operations. But they account to 18.3 seconds, whereas this > real27m21.090s > user0m5.379s > sys 0m23.073s says that the total time spent is 27:21. So you have to explain the remai

Re: [ADMIN] What happens on a commit?

2007-05-23 Thread Alvaro Herrera
s on what the transaction did. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [ADMIN] Role based database access

2007-05-24 Thread Alvaro Herrera
oosen freely. In the database name you can specify "@file", which points to a file containing a list of database names that the pg_hba.conf lines applies to. One idea is to have the database creation routine put a line into that file (which would be specific to each user). -- A

Re: [ADMIN] Question about HeapTupleHeaderData

2007-05-25 Thread Alvaro Herrera
utility commands (CREATE TABLE, etc) may increment the command counter more than once (internal implementation detail you should not care about). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [ADMIN] ERROR: invalid memory alloc request size

2007-05-28 Thread Alvaro Herrera
/kerkbode/images/blank.gif\\\"\"\n\"2007-04-20\"; > \"18:07:06\" \"192.168.0.100\" \"69\" > \"http://develop.christians.co.za/phpAdsNew/adx.js\"\n\"20";..., > len=337739539, is_client_to_server=5 '\005') at mbutil

Re: [ADMIN] pg_dump: Error message from server: ERROR: compressed data is corrupt

2007-05-30 Thread Alvaro Herrera
10 (SunOS server3 5.10 Generic_125101-05 ), > pg_data_dir on zfs mirrored pool. I've checked status of pool and got: Apparently ZFS betrayed you, and the data it recovered is not as good as it seems to think. If it were recovered correctly you wouldn't be getting this error. -- Alvaro

Re: [ADMIN] Auto Vacuum question?

2007-06-04 Thread Alvaro Herrera
However it is not normal if it loses track of that dead space. One thing you can and should do is adjust the autovacuum settings (for example lowering the vacuum scale factor and threshold values). Another is to correctly set the FSM values. Have you done both? -- Alvaro Herrera

Re: [ADMIN] Auto Vacuum question?

2007-06-05 Thread Alvaro Herrera
Charles.Hou wrote: > On 6 4 , 10 49 , [EMAIL PROTECTED] (Alvaro Herrera) wrote: > > It is normal that the tables grow a bit to a stationary state of dead > > space (generated by UPDATE and DELETE). However it is not normal if it > > loses track of that dead space. One thi

Re: [ADMIN] Change order of table-columns in pg_catalog.pg_attribute.attnum

2007-06-06 Thread Alvaro Herrera
Erwin Brandstetter escribió: > Hi group! > > If I want to change the default order of two columns of a table, can I > just manipulate the values in > pg_catalog.pg_attribute.attnum? It works -- as long as the table is empty. -- Alvaro Herrera

Re: [ADMIN] 8.2.4 Won't Build 8.1 Functional Indexes

2007-06-06 Thread Alvaro Herrera
dt at time zone 'GMT'), 'yyymmdd') I am not sure if this actually works -- but you would need to change the queries as well. The point is that the time zone is now fixed, instead of being dependent on a GUC variable. -- Alvaro Herrera http://www.amazon.com/gp/reg

Re: [ADMIN] 8.2.4 Won't Build 8.1 Functional Indexes

2007-06-06 Thread Alvaro Herrera
Tom Lane escribió: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > You can't do this because to_date and other functions are not immutable. > > 8.2 seems to be more picky about this -- the date conversions of > > timestamptz columns are dependent on the current

Re: [ADMIN] Postgres8.2 - turning off BINGLOG/PARSELOG

2007-06-19 Thread Alvaro Herrera
SELECTLOG (and SELECTDETAIL because there are the actuall > parametars)? I don't think so. You can increase log_min_duration_statement a bit so that only statements that take "long" are logged. -- Alvaro Herrerahttp://www.Comma

Re: [ADMIN] reindex in v8.2

2007-06-19 Thread Alvaro Herrera
k your indexes sizes for a while. If you don't notice a problem you can forget it entirely. Most people gets away without it. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---

Re: [ADMIN] checkpoint_timeout irrelevant in 8.1.9

2007-06-20 Thread Alvaro Herrera
There's a function you can use for that, pg_switch_xlog(). -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "In Europe they call me Niklaus Wirth; in the US they call me Nickel's worth. That's because in Europe they call m

Re: [ADMIN] hot restart of posgtresql

2007-07-03 Thread Alvaro Herrera
; Why have you got SHMALL set to half a GB when you have Postgres > configured to ask for over 3 GB? Hmm, isn't shmall measured in pages? I think the problem may be that he changed the settings in sysctl.conf but he hasn't rebooted since, so the kernel is ru

Re: [ADMIN] More than one pg_database entry for database

2007-07-05 Thread Alvaro Herrera
etting rid of the > bogus row, but what you should be able to do to let pg_dump work is to > rename misp to something else. You can rename it back after getting > through the dump/reload, of course. Or roll the XID counter back, vacuum the table, and restore the XID to the original

Re: [ADMIN] Catalog insertion

2007-07-08 Thread Alvaro Herrera
saying: "System catalog > modifications are currently disallowed". > > Please, I need help to know how to allow to modify the system catalog . What CREATE TABLE exactly? -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "No hay cielo po

Re: [ADMIN] Catalog insertion

2007-07-09 Thread Alvaro Herrera
owed. Oh, you can't do that. It's disallowed by policy. If you want to create catalogs you need to be in standalone or bootstrap mode (typically they are created by declaring a src/include/catalog/*.h file and having it be included in postgres.bki by the genbki script). -- Alvaro Herrera

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Alvaro Herrera
same server. You may be able to explain yourself better there (and I'll be able to respond more quickly). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadc

Re: [ADMIN] 8.2.4 patches?

2007-07-10 Thread Alvaro Herrera
:25 mha * src/backend/port/win32_sema.c (1.3.2.1): Set maximum semaphore count to 32767 instead of 1. Fixes errorcode 298 when unlocking a semaphore more than once. Per report from Marcin Waldowski. 2007-04-23 12:52 neilc * doc/src/sgml/ref/create_function.sgml (1.70.2.2): Fix

Re: [ADMIN] 8.2.4 patches?

2007-07-11 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Ray Stell wrote: > >> Are there critical security or performance patches that should be > >> applied to 824 and how could I have determined this without this post? > > > The changelog afte

Re: [ADMIN] 8.2.4 patches?

2007-07-11 Thread Alvaro Herrera
Bruce Momjian wrote: > Alvaro Herrera wrote: > > Tom Lane wrote: > > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > > > Ray Stell wrote: > > > >> Are there critical security or performance patches that should be > > > >> app

Re: [ADMIN] Anyone seen this message?

2007-07-12 Thread Alvaro Herrera
> It doesn't give any other info. Has anyone seen this message, and more > importantly, what do I do about it. Don't use a mismatching psql version with the server version. -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "Now I have my system r

Re: [ADMIN] Anyone seen this message?

2007-07-12 Thread Alvaro Herrera
ing the libpq.so is a different > major version? No. It is only a problem for psql because it uses some queries that assume things about the system catalogs (for example psql 8.2 assumes that pg_index.indisvalid exists, which it doesn't on 8.1). Did you win the bet? -- Alv

Re: [ADMIN] syslog: log line length?

2007-07-18 Thread Alvaro Herrera
one entry. Postgres does not split entries. They are split by infelicities in the underlying facilities used (pipes). There's ongoing work to fix this problem. In the meantime, I think you could work around it by using syslog instead of redirect_stderr. -- Alvaro Herrera

Re: [ADMIN] No create table

2007-07-27 Thread Alvaro Herrera
ermission away (if he had one at all actually). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 3: Have you checked our

Re: [ADMIN] instaling Libxml2

2007-07-29 Thread Alvaro Herrera
makes it not have them (maybe it got them revoked, or maybe the initial installation was done with a different user). Get a listing of users (\u in psql) and pick one for the -U switch that has superuser privileges. -- Alvaro Herrerahttp://www.CommandPrompt.com/

Re: [ADMIN] stracing a connection

2007-08-01 Thread Alvaro Herrera
#x27;ll be using something like "strace -p [pid] [command]", what should I > use for [command]? strace -p pid gdb -p pid You don't need to specify the command at all. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command

Re: [ADMIN] Migration Between Releases

2007-08-15 Thread Alvaro Herrera
. (This is Postgres-specific). Peter wasn't flaming at all. -- Alvaro Herrerahttp://www.advogato.org/person/alvherre Jason Tesser: You might not have understood me or I am not understanding you. Paul Thomas: It feels like we're 2 people divided by a common la

Re: [ADMIN] Yet Another Socket .s.PGSQL.5432 Problem

2007-08-16 Thread Alvaro Herrera
p psql -- Alvaro Herrera Developer, http://www.PostgreSQL.org/ "The eagle never lost so much time, as when he submitted to learn of the crow." (William Blake) ---(end of broadcast)--- TIP 9: In versions below 8.0, the pla

Re: [ADMIN] reindexdb hangs

2007-08-25 Thread Alvaro Herrera
the place where the list of rels is built, but that scans only pg_index, so it doesn't have access to the namespace of each rel. So one idea would be to get the pg_class row for each candidate, but that seems slow. Another idea would be to just add all the candidates and silently skip the t

Re: [ADMIN] vacuum killed because of out of memory

2007-08-27 Thread Alvaro Herrera
perating system configured to overcommit memory will do this. The usual suggestion is to configure it not to. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(e

Re: [ADMIN] How to monitor resources on Linux.

2007-08-28 Thread Alvaro Herrera
> postmasters running. Each database is tuned according to need. We allow > anywhere between 5-50 max connections. So what I am looking for is? Any of work_mem or maintenance_worm_mem set too high can cause excessive memory usage. What do you have these set to? -- Alvaro Herrera

Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread Alvaro Herrera
Medi Montaseri escribió: > I see...thank you for the clarification...one more question... > How does PG protects itself from a run-away code (eg an endless loop) ? It doesn't. > In other words, does PG run the "untrusted" code in a seperate > proces

Re: [ADMIN] reindexdb hangs

2007-08-29 Thread Alvaro Herrera
ster temporary tables of other sessions So, patch attached. > Are there any other commands to be worried about? I can't see any > besides VACUUM/ANALYZE, and those seem covered. I can't think of any. -- Alvaro Herrerahttp://www.CommandPrompt

Re: [ADMIN] transaction ID query

2007-08-30 Thread Alvaro Herrera
y were vacuumed Examine the pg_stat views, though I am not sure if the vacuum columns were already in 8.1. In any case, in 8.1 Xid wraparound is tracked per-database, so you need database-wide vacuums. In 8.2 it is per table so it is easier to keep up to date. -- Alvaro Herrera

Re: [ADMIN] reindexdb hangs

2007-08-30 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Yeah, an extra fetch of the pg_class row doesn't seem all that nice. > >> I think you'd want to check it in approximately the same two places > >> where pg_c

Re: [ADMIN] reindexdb hangs

2007-09-10 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > I'm not sure I follow. Are you suggesting adding a new function, > > similar to pg_class_ownercheck, which additionally checks for temp-ness? > > No, I was just suggesting adding the check

Re: [ADMIN] reindexdb hangs

2007-09-12 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > I am unsure if I should backpatch to 8.1: the code in cluster.c has > > changed, and while it is relatively easy to modify the patch, this is a > > rare bug and nobody has reported it in CLUSTER (not ma

Re: [ADMIN] Telecom(Colombia) - Error postgresql

2007-09-12 Thread Alvaro Herrera
o que tiene ese valor, muestralo aca y vemos que se hace con el. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "Before you were born your parents weren't as boring as they are now. They got that way paying your bills, cleaning up your room and listening t

Re: [ADMIN] How to repair if file pg_clog/0000 is deleted

2007-09-21 Thread Alvaro Herrera
xmuinn wrote: > Files under directory pg_clog are deleted. > How to rebuild files under the directory? Restore from backup. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of bro

Re: [ADMIN] postgresql para windows para 64 bits

2007-10-17 Thread Alvaro Herrera
GONZALEZ GONZALEZ EUSEBIO wrote: > Existe alguna versión de postgresql para Windows 64 bits? No por el momento. PS: esta es una lista en inglés. Si quieres hacer consultas en español te sugiero la lista pgsql-es-ayuda. -- Alvaro Herrerah

Re: [ADMIN] could not open file "global/pg_database"

2007-10-18 Thread Alvaro Herrera
file in $PGDATA? Who's the owner? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 9: In versions below 8.0,

Re: [ADMIN] Postgres database is not logging any messages after the reboot

2007-10-19 Thread Alvaro Herrera
utomatically remounted read-only by the operating system, it's because serious trouble is ahead. Rebooting to remount read-write seems a recipe for disaster unless you have corrected the problem. This may be a Linux kernel bug, a disk/cable/controller failure, or something else. -- Alva

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Alvaro Herrera
age () > #1 0x080baccf in ginInsertValue () > #2 0x080b81b7 in gin_xlog_cleanup () So it looks like a bug in the gin xlog code, which makes sense because it's new. Can you please execute in that gdb session the command "bt full" and send the output? -- Alvaro Herrera

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-25 Thread Alvaro Herrera
Craig McElroy wrote: > Alvaro: > I just tried, but I only get "No symbol table info available." after each > line of the trace. Well, we have two possibilities: 1. you send us a complete, reproducible test case, 2. you recompile with debugging enabled (configure --enable-d

Re: [ADMIN] Installing PostgreSQL as Admin

2007-10-30 Thread Alvaro Herrera
Nandakumar Tantry wrote: > Does any-ne know how to install PostgreSQL with > Administrator account? If not how will I do it? Any documentation > available? You can't. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4&q

Re: [ADMIN] how to check objects dependency??

2007-10-31 Thread Alvaro Herrera
ogs, thus we cannot give you the object names (only the fact that they exist). -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "PHP is what I call the "Dumb Monkey" language. [A]ny dumb monkey can code

Re: [ADMIN] how to check objects dependency??

2007-11-02 Thread Alvaro Herrera
use the commands DROP OWNED and REASSIGN OWNED to drop the objects by a given role, and respectively assign them to someone else. (8.2 only). -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "Ninguna manada de bestias ti

Re: [ADMIN] alter table serial->int

2007-11-08 Thread Alvaro Herrera
is a macro for "int with a default". -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Alvaro Herrera
tocol, this is exactly what you would see. Is there any reason you're so fond of top-posting? -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio) --

Re: [ADMIN] idle in transaction...unexpected EOF on client connection

2007-11-09 Thread Alvaro Herrera
Tena Sakai escribió: > Aside from that, can this be caused by many deleted > rows from tables (and having neglected to vacuum)? No. -- Alvaro Herrerahttp://www.advogato.org/person/alvherre Major Fambrough: You wish to see the frontier? John Dunbar: Yes sir, befor

Re: [ADMIN] postgres bogged down beyond tolerance

2007-11-14 Thread Alvaro Herrera
with a performance problem. If you haven't ever vacuumed your database, do so now and try again. (Actually, have a read of the "maintenance" chapter in the manual). -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" Voy

Re: [GENERAL] [ADMIN] "global/pg_control": Permission denied

2007-11-15 Thread Alvaro Herrera
Richard Broersma Jr wrote: > --- On Thu, 11/15/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > > What is the problem with the file? > > I looked at the pg_control file, postgres had the proper permission to it. > > > Why is it not accessible to Postgre

Re: [GENERAL] [ADMIN] "global/pg_control": Permission denied

2007-11-15 Thread Alvaro Herrera
ng > Postgres and restoring from a dump? What is the problem with the file? Why is it not accessible to Postgres? My guess is that something (antivirus?) was messing with the file when the system died. -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC Y dijo

Re: [ADMIN] Get a list of ALL tables

2007-11-20 Thread Alvaro Herrera
a database-wide vacuum. You can't exclude tables. If you want to be able to do that you'll need to jump to 8.2. -- Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 "Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañan

Re: [ADMIN] Enhancement request

2007-11-30 Thread Alvaro Herrera
VACUUM SCHEMA in 8.2 so it doesn't make any sense to try to compare it against the old autovac. And you can bet that in 8.4 autovac will have even more goodies. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" &q

  1   2   3   4   5   6   >