[ADMIN] Partial dump backup -T parameter and sequence incorrect inclusion

2013-06-27 Thread Daniel Vázquez
Hi here! Postgres 9.1 pg_backup with -T parameter excluding dump explicit table. Then when pg_restore any object of excluded table are restored EXCEPT the sequence. That's a problem because if use -c to clean try to drop existent sequence object and then raises dependency error. Thanks!

[ADMIN] postgres user with automate rsync and private/public key pairs

2013-06-14 Thread Daniel Vázquez
Hi here! Centos 6.4 Postgres 9.1 I want to automate rsync backups from server1 to server2 via ssh using the postgres(linux deamon user) and a pair of private/public keys generated by ssh-keygen I generated the keys in Server1 and copy and added id_rsa.pub to /var/lib/pgsql/.ssh/authorized_keys i

[ADMIN] Problem with data migration from 9.1 to 9.2

2013-03-04 Thread Daniel Krysiak
.1 Moving back and run 9.1 to use pg_dumpall is quite impossible, or at least vary difficult with Arch Linux, so I would really appreciate some other suggestions. -- Daniel Krysiak -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Data corruption / recover

2013-02-28 Thread Daniel Paval
On 28.02.2013 18:48, Scott Marlowe wrote: On Thu, Feb 28, 2013 at 7:21 AM, Tom Lane wrote: Daniel Paval writes: We're dealing with the following situation (PG version is 7.4.30): 7.4? I sure hope you're going to migrate onto something less obsolete once you get out of this proble

[ADMIN] Data corruption / recover

2013-02-28 Thread Daniel Paval
Hi, We're dealing with the following situation (PG version is 7.4.30): somehow, a DB has gone missing from pg_database (psql \l listing doesn't show it anymore). More, while you can still \c to it, a \d table listing only shows a fraction of the tables. A \d on the existing tables shows missi

[ADMIN] listing installed modules

2011-12-27 Thread Daniel Vázquez
How to get a list of contrib module installed extensions on Postgresql 8.4?? I see \dx command for 9.1 but not works on 8.4 thx!

[ADMIN] Unaccent contrib module for PostgreSQL 8

2011-09-21 Thread Daniel Vázquez
Hi guys, I read in Unaccent contrib module that's compatible with PostgresSQL 8.4 and 9.x I know it is by default on PostgreSQL 9.x contrib folder, but how I can install it on a PostgreSQL 8.4 production running Server??. Unaccent module is not in postgresql 8.4 contrib folder by default. Thanks

[ADMIN] Unaccent contrib module for PostgreSQL 8.4

2011-09-21 Thread Daniel Vázquez
Hi guys, I read in Unaccent contrib module that's compatible with PostgresSQL 8.4 and 9.x I know it is by default on PostgreSQL 9.x contrib folder, but how I can install it on a PostgreSQL 8.4 production running Server??. Unaccent module is not in postgresql 8.4 contrib folder by default. Thanks

Re: [ADMIN] problem about postgresql installation and user login

2011-01-11 Thread Daniel J. Summers
some may not.  In Ubuntu, the "postgresql" package is a meta-package, pointing to the latest version (at this time, "postgresql-8.4" - Ubuntu can be slow to roll to new major versions). -- Daniel J. Summers Owner, DJS Consulting GEEKCODE 3.12 GCS/IT d s-:+ a C++ P---

Re: [ADMIN] "root" execution not permitted. and busybox

2010-12-23 Thread Daniel J. Summers
t, and the su command can't complete, you may still be running as root. -- *Daniel J. Summers* *Owner, DJS Consulting* E-mail • Website <http://djs-consulting.com> • Support <http://support.djs-consulting.com> • Tech Blog<http://techblog.djs-consulting.com> GEEKCODE 3.12

Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Daniel J. Summers
that's unacceptable, you might try indexing that field; I don't know if max uses them, but it'd be worth a try. -- _____ Daniel J. Summers Owner, DJS Consulting Albuq

Re: [ADMIN] getting list of columns from a query

2010-08-22 Thread Daniel J. Summers
On 08/22/2010 05:27 PM, c k wrote: As I am using MS Access for a long time, many tools like ms access provides a way to get the list of columns from a query. (using filed list in combo boxes in ms access). But is it possible to get such list of columns from a query where it is not known to the

[ADMIN] Installing PostgreSQL

2010-06-02 Thread Daniel, Clyde D (Derrick)
Good Afternoon, I am trying to install PostgreSQL on my desktop and it is asking for a password. Everything I type in is not working it gives me this error: Any help would be greatly appreciated. Thanks <>

[ADMIN] pitrtools package wrong dependency (binary packages)

2010-06-02 Thread DANIEL CRISTIAN CRUZ
one know how to ask for help about this? Thanks, Daniel Cristian Cruz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Ubuntu 10.04 - Cannot Create TCP/IP Sockets

2010-05-04 Thread Daniel J. Summers
and there are lots of references to "socket", but it doesn't look like it's having much success. * Output is at http://djs-consulting.com/strace.txt ** Output is at http://djs-consulting.com/pg_trace.txt Daniel -- Sent via pgsql-admin mailing list (pgsql-admin@pos

Re: [ADMIN] Ubuntu 10.04 - Cannot Create TCP/IP Sockets

2010-05-03 Thread Daniel J. Summers
On 05/03/2010 02:20 PM, Tom Lane wrote: "Daniel J. Summers" writes: On 05/03/2010 01:52 PM, Tom Lane wrote: Does it work if you change listen_addresses to '*' or '127.0.0.1' ? Bingo - changing it to "*" got it started. :)

Re: [ADMIN] Ubuntu 10.04 - Cannot Create TCP/IP Sockets

2010-05-03 Thread Daniel J. Summers
vd: 85 Could this possibly be related to IPv6? I know with this version of Ubuntu (10.04), there's a known issue with LightTPD if you include the IPv6 library in the configuration file (which is on by default - heh); if you comment them out, it works just fine. Thanks for the help! D

Re: [ADMIN] Ubuntu 10.04 - Cannot Create TCP/IP Sockets

2010-05-03 Thread Daniel J. Summers
running for it. :) Thanks again... Daniel -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Ubuntu 10.04 - Cannot Create TCP/IP Sockets

2010-05-02 Thread Daniel J. Summers
olution was. Anyone remember? I'll be sure to post what I find, so that maybe others can benefit a few years from now. :) Thanks... Daniel -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] linux standard layout

2010-03-08 Thread Daniel J. Summers
en I do have to compile, I compile AND create a package (if possible), then install the package. Daniel -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Querying the same column and table across schemas

2010-03-05 Thread Daniel J. Summers
On 03/05/2010 08:44 PM, John A. Sullivan III wrote: On Fri, 2010-03-05 at 19:59 +, Daniel J. Summers wrote: On 03/05/2010 07:44 PM, John A. Sullivan III wrote: I'm trying to avoid making a thousand call like select user1.session_id from user1.sessions; when I could do it

Re: [ADMIN] Querying the same column and table across schemas

2010-03-05 Thread Daniel J. Summers
there too). Of course, the user creating and running this would need SELECT privileges on each schema's "sessions" table. Daniel -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?

2010-01-22 Thread Daniel Cristian Cruz
?column? -- t (1 registro) brd2=# SELECT 'Ã' LIKE UPPER('ã'); ?column? -- f (1 registro) brd2=# SHOW lc_collate ; lc_collate pt_BR.iso88591 (1 registro) The correct LC_COLLATE would be pt_BR.utf8 or is it a bug? -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] Very simple password for DB administrator

2010-01-13 Thread Daniel J. Summers
ou may never know if you needed it or not; but, if you don't, the time you need it will become painfully apparent. Daniel -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] COUNT(DISTINCT field) OVER (PARTITION BY another_field)

2009-07-21 Thread Daniel Cristian Cruz
group_key; Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] COUNT(DISTINCT field) OVER (PARTITION BY another_field)

2009-07-21 Thread Daniel Cristian Cruz
... 2009/7/21 Daniel Cristian Cruz > Hi list, > > Does someone knows why this is not a supported feature? > > I was happily SQL querying when I woke up from my dreams with this message: > > ERROR: DISTINCT is not implemented for window functions > LINE 6: COUNT(DISTINCT

Re: [ADMIN] how to REINDEX pg_database on

2009-07-20 Thread Joshua Daniel Franklin
On Mon, Jul 20, 2009 at 11:00 AM, Alvaro Herrera wrote: > Joshua Daniel Franklin escribió: > >> xbrain_queries=# \d >> No relations found. > > Hmmm, seems your Xid counter wrapped around.  Have you vacuumed the > system catalogs in that database?  Particularly p

Re: [ADMIN] how to REINDEX pg_database on

2009-07-20 Thread Joshua Daniel Franklin
On Mon, Jul 20, 2009 at 8:39 AM, Alvaro Herrera wrote: > Joshua Daniel Franklin escribió: >> > postgres -P -D /usr/local/databases/pgsql/data pg_database >> > FATAL: database "pg_database" does not exist >> >> So... does that 'FATAL: database &q

Re: [ADMIN] how to REINDEX pg_database on

2009-07-20 Thread Joshua Daniel Franklin
On Thu, Jul 16, 2009 at 12:18 PM, Joshua Daniel Franklin wrote: > I'm having a problem with Postgres 7.4 on RHEL  4 (Nahant Update 8). > It seems that pg_database disappeared some time ago (I think before > my oldest backups, unfortunately). > > I searched and found some mentio

[ADMIN] how to REINDEX pg_database on

2009-07-16 Thread Joshua Daniel Franklin
I'm having a problem with Postgres 7.4 on RHEL 4 (Nahant Update 8). It seems that pg_database disappeared some time ago (I think before my oldest backups, unfortunately). I searched and found some mention of REINDEX but I'm not sure if I am using it correctly since this is a system catalog. I tri

Re: [ADMIN] Problem with table lock within a function

2009-04-08 Thread Daniel Cristian Cruz
Sorry... Long time not using pg_locks... My function (on pid 20125) was running, pid 25743 requested an exclusive lock and is waiting, and all others were waiting for this one. 2009/4/8 Daniel Cristian Cruz > Hi all, > > I had a big function (the same one mentioned before) which is

[ADMIN] Problem with table lock within a function

2009-04-08 Thread Daniel Cristian Cruz
for 3 minutes and every developer is trying to kill me, because they are waiting for their results. Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[ADMIN] DEBUG message: concurrent ROOT page split

2009-04-08 Thread Daniel Cristian Cruz
Hi all, Sometimes I use RAISE DEBUG on my functions, and it showed this message on PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.3-5) 4.3.3. Is it normal? Could it be something wrong with my code? Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] Without schemas

2009-04-01 Thread Daniel J. Summers
The way I have coded my applications is to have a service user who owns the schema, and that's the user that the application uses. If you have a similar setup, that may work - if not, public is your best option. My advice would be to get it working with no punctuation in the SQL (i.e

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-03-01 Thread Daniel J. Summers
Bryan Keith wrote: Is the package postgresql-8.2 still installed? I don't know. Maybe not. How can I tell? Try dpkg --list 'postgres*' You'll see several packages - the first column will tell you the status of the package. (There's a key at the top of t

Re: [ADMIN] postgres 8.2 doesn't start after ubuntu upgrade

2009-02-28 Thread Daniel J. Summers
need this is if you change the major or minor version - for 8.3.5 to 8.3.6, for example, I believe there's no upgrade required. -- Daniel J. Summers *Owner, DJS Consulting* Support <http://support.djs-consulting.com/> • Tech Blog <http://www.djs-consulting.com/linux/blog>

Re: [ADMIN] "like" and index

2009-02-25 Thread Daniel J. Summers
Andrzej Zawadzki wrote: Daniel J. Summers wrote: Tony Liao wrote: I try to explain analyze,but it doesn't work ,it use seq scan. Generally speaking, LIKE doesn't use indexes. ?! That's not true at all!! MySQL will only use it if the wildcard isn't

Re: [ADMIN] "like" and index

2009-02-25 Thread Daniel J. Summers
ll be null. If you change "INNER" to "RIGHT", it's the opposite, but I've yet to find a good use for a right join other than confusing the next person to look at it. :) -- Daniel J. Summers *Owner, DJS Consulting* Support <http://support.djs-consulting.com/> • Tech Blog &

Re: [ADMIN] Permissions to a schema

2009-02-03 Thread Daniel J. Summers
ables, don't forget the sequences for any "serial" fields you may have. You'll get errors trying to insert, even though you've granted INSERT on that table. As best I can tell (haven't seen this in a document anywhere), your role needs SELECT and UPDATE on thos

Re: [ADMIN] Totally inappropriate by-line for a major representative of this organization

2009-02-02 Thread Daniel J. Summers
d Jesus Christ, and thou shalt be saved, thou and thy data.'" If you feel it's inappropriate, I would think that the appropriate channel for complaint would be the company itself, not this list of its users. And, to forsake this avenue of advice because of a religious quote in a

Re: [ADMIN] pgCluster and PostgreSQL

2009-01-05 Thread Daniel Cristian Cruz
erprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 > // Keyserver: www.keyserver.net Key-ID: 1C1209B4 > > -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

[ADMIN] Change user password

2008-12-08 Thread Daniel Scott
Hi, Is is possible to modify a user password using a command line script? I know about the ALTER USER command from within the client, but this looks like it's quite insecure, storing the password in the history. I know it's possible to insert the encrypted password with ALTER USER but that means g

Re: [ADMIN] Not so simple query and a half million loop

2008-12-02 Thread DANIEL CRISTIAN CRUZ
exceptions... It's somewhat complex but it returns slowly ok. Regards, "Alvaro Herrera" <[EMAIL PROTECTED]> escreveu: > Daniel Cristian Cruz escribió: >> No one knows why I got "actual time=0.014..0.570 rows=30 loops=511222" >> and "actual ti

Re: [ADMIN] Not so simple query and a half million loop

2008-12-02 Thread Daniel Cristian Cruz
, 0) ~ 1 second I've tryied to increase statistics to maximum, with no success. This is the eGroupware database schema, with a few records. Regards, 2008/12/1 Daniel Cristian Cruz <[EMAIL PROTECTED]>: > Maybe someone would like to see it without broken lines (I do). > >

Re: [ADMIN] Not so simple query and a half million loop

2008-12-01 Thread Daniel Cristian Cruz
Maybe someone would like to see it without broken lines (I do). Regards, 2008/12/1 Daniel Cristian Cruz <[EMAIL PROTECTED]>: > I've tryied 4 times to post this message to pgsql-performance without > success... No return, even an error... > > Below is my problem; a quer

[ADMIN] Not so simple query and a half million loop

2008-12-01 Thread Daniel Cristian Cruz
ing egw_cal_dates_pkey on egw_cal_dates cd (cost=0.00..1.02 rows=1 width=20) (actual time=0.108..4.281 rows=30 loops=511222) Index Cond: (cd.cal_id = cr.cal_id) Filter: ((date_part('year'::text, ('1970-01-01 00:00:00'::timestamp without tim

[ADMIN] pg_dump's table is empty

2008-11-02 Thread Daniel Punton
I am dumping postgres 7 tables under the postgres account mydb# pg_dump -O -a -t mytable > mytable.out and am getting either empty dumps ( actual db tables are populated) or no dump at all. I have file write permissions and this process has worked in the past. Any suggestions what might be wrong?

[ADMIN] DROP TABLE waiting for pg_dump

2008-10-02 Thread Daniel Cristian Cruz
tions before upgrade). Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル

Re: [ADMIN] unable to backup database -- psql not up to date

2008-09-17 Thread Daniel Christopher
What OS are you running on? How did you perform this upgrade? In a packaged form like rpm? or did you compile from source? I am running FreeBSD 6.1 I compiled from source, and followed the instructions in the documentation about upgrading to a new major release (pg_dumpall, shutdown,

[ADMIN] psql data restore not working

2008-08-28 Thread Daniel Punton
issue (between pgsql 7-> 8) sed 's/^M/\\r/' datafilename > datafilename I attempted to insert the data psql -d databasename -f database_data_file_name no errors but when I query the data - there is none .. Any ideas what I might be missing or how to see any errors or warnings?

[ADMIN] pgCluster and PostgreSQL

2008-08-15 Thread DANIEL CRISTIAN CRUZ
nd regards, -- Daniel Cristian Cruz Administrador de Banco de Dados Direção Regional - Núcleo de Tecnologia da Informação SENAI - SC Telefone: 48-3239-1422 (ramal 1422)

Re: [ADMIN] Created non-owner user cannot see database

2008-07-20 Thread Daniel J. Summers
Niklas Johansson wrote: On 20 jul 2008, at 04.47, Daniel J. Summers wrote: grant usage on database custom_database to user_no_2; Now, none of these commands failed - they all came back with "CREATE ROLE" (or the appropriate response). Are you sure? 'GRANT USAGE ON DATABASE

[ADMIN] Created non-owner user cannot see database

2008-07-19 Thread Daniel J. Summers
I'd rather not run the web application as the schema owner - I'm sure there's something I'm missing. I'd appreciate any advice anyone may have - thanks! -- Daniel J. Summers Owner, DJS Consulting E-mail -[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> We

[ADMIN] Postgres port bindings changed after box restart

2008-03-04 Thread Daniel Punton
Our redhat server was restarted and postgres is showing different databases on different ports? Could someone explain how this might happen and where this information comes from (what conf for port bindings) as is there a way of guarenteeing this will not happen on restarts. Cheers Dan

Re: [ADMIN] Can't login to 8.2.4 if not superuser...

2007-09-07 Thread Daniel Rubio
Using the older gcc version to compile, the problem disappears ... En/na Daniel Rubio ha escrit: Our new Server is a sun T2000 with the "CoolThreads" technology. Wi installed the recomended gcc version to take advantage of the new features of this technology: Using built-in spe

Re: [ADMIN] Can't login to 8.2.4 if not superuser...

2007-09-07 Thread Daniel Rubio
s/rltmp/lib -L/usr/sfw/lib -L/usr/lib -Wl,-R/usr/lib LDFLAGS_SL = LIBS = -lpgport -lpam -lssl -lcrypto -lz -lreadline -ltermcap -lrt -lresolv -lgen -lsocket -lnsl -ldl -lm VERSION = PostgreSQL 8.1.4 Now I'm going to recompile using a 3.4.3 version to see what happens... En/na Tom Lane h

Re: [ADMIN] Can't login to 8.2.4 if not superuser...

2007-09-06 Thread Daniel Rubio
0x001837f0 in ServerLoop () #4 0x00184cd8 in PostmasterMain () #5 0x001373f8 in main () regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend -- *******

[ADMIN] No pg_dumplo on 8.2.4

2007-09-05 Thread Daniel Rubio
in advance -- ******** Daniel Rubio Rodríguez OASI (Organisme Autònom Per la Societat de la Informació) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007 - Fax: 977.224.517 e-mail: drubio a oasi.org ---(end of

[ADMIN] Can't login to 8.2.4 if not superuser...

2007-09-05 Thread Daniel Rubio
yyy.yyy.yyy my laptop IP to access with pgAdmin. Some idea about what it's happening? -- **** Daniel Rubio Rodríguez OASI (Organisme Autònom Per la Societat de la Informació) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007

Re: [ADMIN] Problems connecting to postgres using JDBC Driver.

2007-08-27 Thread Daniel Muñoz
es to identify a host, only IPs and i have the name of one of my computers. I removed that host line and it works!!! The person who posted refers to this URL: http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#AUTH-PG-HBA-CONF Thanks alot for your help!! daniel On 8/

[ADMIN] Problems connecting to postgres using JDBC Driver.

2007-08-27 Thread Daniel Muñoz
rivers with the same results. My guess is that maybe this has something to do with the Fedora's distribution. I will post this same message to them as well. Thanks in advance for your help! daniel -- ==== Daniel Muñoz Honiball [EMAIL PROTECTED] www.karinasoft.com Softwa

Re: [ADMIN] select * from a 3M-row table very slow

2007-07-02 Thread Daniel Alvão Carvalho Júnior
Hi ! Tell us your hardware and software configurations. []s > - Original Message - > From: "Jessica Richard" <[EMAIL PROTECTED]> > To: pgsql-admin@postgresql.org > Subject: [ADMIN] select * from a 3M-row table very slow > Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT) > > > Is there anythin

Re: [ADMIN] select count(*) from a large table is very slow

2007-05-18 Thread Daniel Cristian Cruz
_class after an analyze. Oops... INSERT or DELETE... :) And remember that if using TRUNCATE, it will not run your trigger and you will need to reset the counter manually. Regards... -- Daniel Cristian Cruz ---(end of broadcast)--- TIP 7: You ca

Re: [ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread Daniel Cristian Cruz
2007/5/9, Scott Marlowe <[EMAIL PROTECTED]>: On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote: > Hi there! > > Is it possible to revoke usage of pg_catalog for a specific user? > > The reason is to secure PostgreSQL. If a user can connect to a > database,

[ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread Daniel Cristian Cruz
blocked, PostgreSQL could be used? Could it be possible to made queries on allowed schemas and tables? This could be an item for the wishlist? Kind regards, -- Daniel Cristian Cruz

Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

2007-03-26 Thread Daniel Ricardo Medina
ok thank, in single mode i try to erase two unique index on pg_shadow but postgres show this messages this index is used by system postgres... can´t erase it Daniel Ricardo Medina Ing. de Desarrollo Computec S.A. Tel 260 71 11 Ext 1640 De: Peter

Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

2007-03-26 Thread Daniel Ricardo Medina
After delete all, postgres said no exist the user id 1... The version is 7.4.8 Daniel Ricardo Medina Ing. de Desarrollo Computec S.A. Tel 260 71 11 Ext 1640 -Mensaje original- De: Tom Lane [mailto:[EMAIL PROTECTED] Enviado el: Sunday, March 25, 2007 1:52 PM Para: Daniel Ricardo

[ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

2007-03-24 Thread Daniel Ricardo Medina
CREATEDB CREATEUSER PASSWORD '***' SYSID 1; CREATE USER userradar PASSWORD '***' but the result is the same. thanks. Daniel Ricardo Medina Ing. de Desarrollo Computec S.A. Tel 260 71 11 Ext 1640 De: Daniel Ricardo Medina

[ADMIN] AYUDA URGENTE CON TABLA PG_SHADOW

2007-03-23 Thread Daniel Ricardo Medina
CREATEDB CREATEUSER PASSWORD '***' SYSID 1; CREATE USER userradar PASSWORD '***' Pero me crea los mismos tres usuarios en la tabla pg_shadow, el problema es que no he podido hacer el backup y ya no tengo espacio en la particion donde tengo montada la base Daniel Ri

Re: [ADMIN] no verification of client certificate?

2007-03-23 Thread Daniel Ricardo Medina
Ayuda por favor Cuando ejecuto este comando me sale una doble tupla del usuario postgres, esto me error cuando ejecuto el comando Pg_dump para realizar el respectivo backup.. radar=# select * from pg_user; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconf

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

2007-03-15 Thread Daniel Medina
pg_shadow y la creo con el dump que tengo del otro servidor funcionara ?? Daniel Medina wrote: Tengo instalado postgres en otra maquina exactamente igual a la de produccion , cree los mismos usuarios y base, pero si data,, alguien sabe cual es el archivo interno de postgres donde esta la tabla

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

2007-03-15 Thread Daniel Medina
global, de produccion al de prueba y funciona bien ,, pero no puedo replicar el problema Gracias... Daniel Medina wrote: Si señor, tiene toda la razon, el problema esta en las tablas de la base, asi que me da lo mismo. gracias.. Alvaro Herrera wrote: Daniel Medina wrote

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

2007-03-14 Thread Daniel Medina
Si señor, tiene toda la razon, el problema esta en las tablas de la base, asi que me da lo mismo. gracias.. Alvaro Herrera wrote: Daniel Medina wrote: Pregunta tengo instalado postgres en el la carpeta /usr/local/pgsql/ , tengo errores en las tablas de postgres y no me

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

2007-03-14 Thread Daniel Medina
Pregunta > > tengo instalado postgres en el la carpeta /usr/local/pgsql/ , tengo > errores en las tablas de postgres y no me deja hacer backup, he > intentado modificar las tablas por medio de una conexion stand alone y > nada... > > puedo instalar postgres en otra carpeta , por ejempo /opt/postg

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

2007-02-18 Thread Daniel Medina
= "t" (typeid = 16, len = 1, typmod = -1, byval = t) 4: usesuper = "t" (typeid = 16, len = 1, typmod = -1, byval = t) 5: usecatupd = "t" (typeid = 16, len = 1, typmod = -1, byval = t) 1: usename = "daniel" (typeid = 19, len = 64, typmod =

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

2007-02-18 Thread Daniel Medina
no tuvo el resultado esperado. > > Lo malo fue que hicimos un DELETE del usuario repetido, con el mismo > resultado: se borraron las dos tuplas :-) y no habia forma de volver a > crearlo. > > Asi que lo que hicimos fue bajar el postmaster, abrir un proceso > standalo

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

2007-02-14 Thread Daniel Ricardo Medina
Ok . Muchas gracias Alvaro.. Esto lo tengo que hacer en la madrugada entonces te contare como me fue -Mensaje original- De: Alvaro Herrera [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 14 de Febrero de 2007 04:01 p.m. Para: Daniel Ricardo Medina CC: [EMAIL PROTECTED]; pgsql

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

2007-02-14 Thread Daniel Ricardo Medina
Y me imagino que una ves subido el servicio Entro asi #psql nombre_base Y listo Hago los cambios sobre las tablas -Mensaje original- De: Alvaro Herrera [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 14 de Febrero de 2007 03:31 p.m. Para: Daniel Ricardo Medina CC: [EMAIL

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

2007-02-14 Thread Daniel Medina
Ok , pero si bajo y subo postgres sin el usuario admin no habra peligro que no suba... y si sube con que usuario haria el cambio... Gracias por tu colaboracion El mié, 14-02-2007 a las 15:52 -0300, Alvaro Herrera escribió: > Daniel Medina escribió: > > borre accidentalmente de la tabla

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

2007-02-14 Thread Daniel Medina
o admin de postgres nuevamente . El vie, 09-02-2007 a las 16:21 -0500, Daniel Medina escribió: > > Por algun motivo desconocido en la tabla pg_user esta dos veces > > registrado en usuario "postgres", por esto no me deja realizar backups > > con el comando pg_dump, como h

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

2007-02-14 Thread Daniel Medina
om pg_user_2. > > Quiza sea una locura pero es lo que se me ocurre. > > > > > Daniel Medina <[EMAIL PROTECTED]> escribió: > > > Por algun motivo desconocido en la tabla pg_user esta dos > veces > > registrado en usu

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

2007-02-14 Thread Daniel Medina
de usuarios y probaro > que todo funcione bien. si es así, problema solucionado. Si no, todavía se > tiene la versión original del directorio de datos de postgres. > > En cuanto a por qué pasó, lo siento, ni idea. > > On Friday 09 February 2007 16:20, Daniel Medina wrote: >

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

2007-02-14 Thread Daniel Medina
estos campos no hacen parte de la tabla pg_user, utilizo la version 7.4.8 y regularmente ejecuto los comandos vacuum y vacuum full por el tamaño de la base El sáb, 10-02-2007 a las 01:55 -0500, Jaime Casanova escribió: > On 2/9/07, Daniel Medina <[EMAIL PROTECTED]> wrote: > > P

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

2007-02-09 Thread Daniel Medina
> Por algun motivo desconocido en la tabla pg_user esta dos veces > registrado en usuario "postgres", por esto no me deja realizar backups > con el comando pg_dump, como hago para eliminar uno de los dos registros > teniendo en cuenta que los datos son identicos y que es el usuario admin > del sis

[ADMIN] tabla pg_user Ayuda......

2007-02-09 Thread Daniel Medina
x ej y que me > aparesca la lista numerada > > gracias > > ---(fin del mensaje)--- > TIP 4: No hagas 'kill -9' a postmaster -- Daniel Ricardo Medina R. Ing. de Desarrollo Computec S.A. - Documentos tel: 2607111 ex

Re: [ADMIN] Logging just SQL commands in an SQL script format

2007-01-25 Thread Daniel Cristian Cruz
linois 217.333.0382 http://webservices.uiuc.edu -- Daniel Cristian Cruz Analista de Sistemas Especialista postgreSQL e Linux Instrutor Certificado Mandriva ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Autovacuum not running in 8.2.0

2007-01-04 Thread Daniel Cristian Cruz
opriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Daniel Cristian Cruz Analista de Sistemas Especialista postgreSQL e Linux Instrutor Certificado Mandriva ---(end of broadca

Re: [ADMIN] Should duplicate indexes on same column and same table

2006-12-09 Thread Daniel Cristian Cruz
make a NOTICE about this? The user could see it and take some action about it. Sincerely, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] unsubscribe

2006-08-17 Thread Daniel Medina
Thanks. ** Nota: La informacion transmitida a traves de este correo electronico es confidencial y esta dirigida unicamente a su destinatario. Su reproduccion, lectura o uso esta prohibido a cualquier persona o ent

Re: [ADMIN] Unsubscribe

2006-08-15 Thread Daniel Caune
am working. > Please deactivate my subscription ASAP. > DO UNSUBSCRIBE ME !!! > http://www.postgresql.org/community/lists/subscribe Select action "Unsubscribe" -- Daniel ---(end of broadcast)--- TIP 1: if posting/reading

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-28 Thread Daniel Caune
> De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : vendredi, juillet 28, 2006 09:38 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > "Daniel Caune" <[EMAIL PROTEC

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-28 Thread Daniel Caune
> -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : jeudi, juillet 27, 2006 19:26 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > &qu

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-27 Thread Daniel CAUNE
> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > De la part de D'Arcy J.M. Cain > Envoyé : jeudi 27 juillet 2006 19:49 > À : Daniel Caune > Cc : [EMAIL PROTECTED]; pgsql-admin@postgresql.org; pgsql- > [EMAIL PROTECTED] > O

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-27 Thread Daniel CAUNE
> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > De la part de Tom Lane > Envoyé : jeudi 27 juillet 2006 19:26 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org; pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-27 Thread Daniel Caune
> -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : jeudi, juillet 27, 2006 16:06 > À : Daniel Caune > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > "Daniel Caune" <[E

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-27 Thread Daniel Caune
> -Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] De la part de Jeff Frost > Envoyé : jeudi, juillet 27, 2006 15:36 > À : Daniel Caune > Cc : pgsql-admin@postgresql.org > Objet : Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 1

[ADMIN] Index row maximum size and crash

2006-07-27 Thread Daniel Caune
. The connection to the server was lost. Attempting reset: Failed. The server crashes again! Sniff! :-( Seems that the database is corrupted somewhere, no? -- Daniel CAUNE Ubisoft Online Technology (514) 490 2040 ext. 3613 ---(end of broadcast

Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11

2006-07-27 Thread Daniel Caune
> De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] De la part de Jeff Frost > Envoyé : jeudi, juillet 27, 2006 12:07 > À : Daniel Caune > Cc : pgsql-sql@postgresql.org; pgsql-admin@postgresql.org > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > On Thu, 2

[ADMIN] Buffers to Nest Loop Join

2006-06-23 Thread Daniel Xavier de Sousa
.Thanks, I hope that somebody can help me. By Daniel Abra sua conta no Yahoo! Mail - 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz.

Re: [ADMIN] recover of data directory

2006-05-29 Thread Daniel Drotos
solve it, just for fun, and to get experience how can it be done. Daniel ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message

  1   2   >