[ADMIN] configure error with C compiler

1999-03-11 Thread Daniel
ation problem: C compiler cannot create executables. Can anyone point me some directions? Thanks. Daniel

[ADMIN] install problem

1999-01-06 Thread Daniel Fong
Hello, This actually has to do with a module(DBD-Pg-o.89), so I'm not sure if this is the right place to ask. But, I'm having trouble building it. I'm using Perl 5.004.04 and I was able to compile DBI-1.05 just fine. If this isn't the right place to ask please point me in the right direction. T

[ADMIN]

2000-05-02 Thread Daniel Kern
looks like this: /usr/bin/postmaster -S -D /var/lib/psql My configuration is as follows: postgresql ver. 6.5.2 release C2 Red Hat running Linux kernel 2.2.12C3 Thank you very much. daniel kern [EMAIL PROTECTED]

[ADMIN] PostgreSQL authentication via PAM/Radius available?

2001-04-09 Thread Daniel Tepas
the src/backend/libpq/auth.[ch] to add another authentication scheme like pam or radius, has anybody written something like that? --  MfG Daniel Tepas Evangelisches u. Johanniter Klinikum Duisburg/Dinslaken/Oberhausen gGmbH Abteilung für Krankenhausinformatik, Gerrickstr. 21, 47137 Duisburg Tel

[ADMIN] Backup when the database is missing all of the pg_* tables

2005-05-06 Thread Daniel Browning
from a backup, and then write a script that will COPY each table, then COPY them back after the initdb. Thanks, -- Daniel Browning <[EMAIL PROTECTED]> - Kavod Technologies. Random Fortune: Consider well the proportions of things. It is better to be a young June-bug than

[ADMIN] Schema sizes with large objects

2005-05-17 Thread Daniel Rubio
h the large objects, because it seems that they're stored in a separate schema (pg_catalog) and I can't find how to relate them with their schema in a manner easy to make this operation. Someone knows how I could do it? -- **** Daniel

[ADMIN] What does log mean

2005-08-31 Thread Daniel Drotos
"elapsed" value contain exactly? Does it include client-server communication time or just the query running time? How can I examine what is the network overhead between the client and the server? Daniel ---(end of broadcast)--- TIP 2: Don&

[ADMIN] Problem with SSL - Server went 100% Busy - Part II

2006-01-25 Thread Daniel M
ith SSL - Server went 100% Busy Date: Wed, 11 May 2005 12:41:34 +1200 Thank in advance Daniel Michulke _ Você sabia que com o seu MSN Messenger você faz ligações de PC-papa- PC, grátis e para qualquer lugar do mundo? É só acessar

[ADMIN] recover of data directory

2006-05-29 Thread Daniel Drotos
quot;, sizes of recovered directory files are 0, so I have no filenames and directory structure. Is there any chance of recover data directory if only dumped file contents are available? Daniel ---(end of broadcast)--- TIP 1: if posting/reading throu

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

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 : [email protected]; [email protected] > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > On Thu, 2

[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
> -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 : [email protected] > Objet : Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 1

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 : [email protected] > 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 Tom Lane > Envoyé : jeudi 27 juillet 2006 19:26 > À : Daniel Caune > Cc : [email protected]; [email protected] > 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 : [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]; [email protected]; pgsql- > [EMAIL PROTECTED] > O

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 : [email protected]; [email protected] > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > &qu

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 : [email protected]; [email protected] > Objet : Re: [SQL] PostgreSQL server terminated by signal 11 > > "Daniel Caune" <[EMAIL PROTEC

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

[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

[ADMIN] Security Problem

2003-10-14 Thread Daniel Rubio
x FROM PUBLIC; REVOKE ALL PRIVILEGES ON SCHEMA public FROM PUBLIC; REVOKE ALL PRIVILEGES ON SCHEMA public FROM GROUP users; ... And I still can to look at the others database structure (connecting as a non privileged user) ... How I could solve this? Thanks -- **

Re: [ADMIN] pg_dump still requires password

2003-11-12 Thread Daniel Rubio
-- 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: [EMAIL PROTECTED

[ADMIN] pg_lo_import alternative ...

2003-11-26 Thread Daniel Rubio
something? -- ******** 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: [EMAIL

[ADMIN] Randomly error using php persistent connections

2003-11-28 Thread Daniel Rubio
lem on the client side, but i can't find nothing that helps me. The web server is a Netscape Enterprise 3.6, and PHP version is 4.3.2. Someone has been the same problem or knows what is happening? Thanks in advance. -- **** Daniel Rubio

Re: [ADMIN] Randomly error using php persistent connections

2003-11-28 Thread Daniel Rubio
We found it! The database host was over the firewall which had the port for postgres opened, but the persistent connections were killed by the firewall due to timeouts. :D Daniel Rubio wrote: Hi all One of our clients (sometimes I think that all freak clients come to our ISP) is using

[ADMIN] Can someone tell me the default installation directory for PostgreSQL 7.4 on linux ?

2003-12-06 Thread Daniel Fitzgerald
I'm a newbie. I just installed it ( from RPMs at the .org for SUSE 8.2 ) and I can't find it anywhere on my hard drive. I can see the package listed in YaST and psql is in the /usr/bin directory. I tried 'find' and 'whereis' to no avail. I installed the docs RPM as well and haven't a clue how t

[ADMIN] unexpected EOF on client connection + createdb

2003-12-15 Thread Daniel García
When I tried to create a database with createdb I receive this message: "unexpected EOF on client connection". I need your help! Thanks, Daniel ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregist

Re: [ADMIN] possible bug with sequences

2004-04-06 Thread Daniel Rubio
ger | not null default nextval('admin.sometable_id_seq'::text) name | text| == cut here = Voila! pg_restore will now return an error on trying to execute SELECT pg_catalog.setval('sometable_id_seq', 4, true); because this sequence has

Re: [ADMIN] [PERFORM] Quad processor options

2004-05-12 Thread Daniel Kalchev
y has to do with the fast disk, the former with the lots of RAM). In any case, proper optimization of queries always helps. :-) Daniel >>>Halford Dace said: > > On 12 May 2004, at 12:17 PM, Manfred Koizar wrote: > > > On Tue, 11 May 2004 15:46:25 -0700, P

[ADMIN] Upgrade problems with OID type ...

2004-07-06 Thread Daniel Rubio
e dump without the -o, but now I use it and the problem persists ... Ideas? Thanks 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 - Fa

Re: [ADMIN] Upgrade problems with OID type ...

2004-07-08 Thread Daniel Rubio
[EMAIL PROTECTED] wrote: Hello Daniel, Have you tried using the -Ft option when doing the dump, and pg_restore instead of psql ? I've seen the thread you started with a similar problem, and it has been useful to solve the problem with the concrete database, but my problem is that we ho

Re: [ADMIN] [PHP] Secure DB Systems - How to

2004-07-13 Thread Daniel Struck
earches using a hash or encrypted value. You can also perform regex searches. Here is an example to get you started: CREATE TABLE crypto ( id SERIAL PRIMARY KEY, title VARCHAR(50), crypted_contentBYTEA ); INSERT INTO crypto VALUES (1,'test1',encrypt_

Re: [ADMIN] [PHP] Secure DB Systems - How to

2004-07-13 Thread Daniel Struck
able to get the log-file of postgresql. So one would also have to make attention that the information like sql statements don't leak that way. Are there other places where this kind of information could leak? Greetings, Daniel Struck -- Retrovirology Laboratory Luxembourg Centre Hospitalie

[ADMIN] Problem with permanent connections from Tomcat

2005-02-07 Thread Daniel Rubio
nothing happens ... :( -- **** 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: dr

[ADMIN] schema sizes

2005-03-02 Thread Daniel Rubio
vance. -- 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 broa

Re: [ADMIN] schema sizes

2005-03-03 Thread Daniel Rubio
Thanks, it works fine!! Morus Walter wrote: Daniel Rubio writes: Hi all! We want to obtain the size of the diferent schemas of some databases. We've installed dbsize and it works fine, but it returns the size of all the database. Exists some method to determine the size of a concrete schem

Re: [ADMIN] Too many clients----A big problem for my team

2005-03-09 Thread Daniel Rubio
e something by which i can overcome this problem. I referred few threads but none of them are of my case. Waiting for your valuable suggestion.. Thanks and Regards Ram -- **** Daniel Rubio Rodríguez OASI (Organisme

[ADMIN] Clustering

2005-03-23 Thread Joao Daniel
Hy guys,  where can I find some information over clustering postgreSQL ?   Yahoo! Acesso Grátis: Internet rápida e grátis. Instale o discador agora!

[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] 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

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-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: [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: [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
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-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-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 =

[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: [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

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-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

[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] 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] 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

[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

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 -- *******

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-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

[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

[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?

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] 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] 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

[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

[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] 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] 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

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] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[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] 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!

RE: [ADMIN] Postgres Startup trouble

2001-08-27 Thread Daniel Bakken
Thanks a lot. Your solution fixed the problem. Glad to be a part of such a knowledgeable mailing list. > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 27, 2001 5:43 PM > To: root > Cc: [EMAIL PROTECTED] > Subject: Re: [ADMIN] Postgres Startup troubl

Re: [ADMIN] Help request

2001-08-30 Thread Daniel Bakken
I think it will run on the cygwin package (a Unix-like environment for windows), but not on native windows OS.   I'm not sure where you can get Cygwin (maybe www.cygwin.org), but you can get the latest Postgres at www.postgresql.org.     Daniel Bakken, Systems Administrator [

[ADMIN] BLOBs

2001-08-30 Thread Daniel Bakken
PostgreSQL field. Any chance it will work? If so, where do I find out how to do it? Daniel Bakken, Systems Administrator [EMAIL PROTECTED] Encore Trading West | www.encoretrading.com 254.771.3508 phone 254.771.3786 fax ---(end of broadcast)--- TIP

[ADMIN] Load problems...

2001-12-18 Thread Daniel Andersen
nd crashes and burns, at which point i have to restart it. Could anyone shed any light on a possible solution to these problems? Thanks, Daniel Andersen ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Load problems...

2001-12-18 Thread Daniel Andersen
> > Does postgresql have any problems managing load? I'm running a medium > > sized (30k customers) ISP off a postgresql database but it can't seem to > > manage very well with the dozen or so requests per second it receives. > > The machine we are handling is plenty powerful enough for a database

Re: [ADMIN] Load problems...

2001-12-18 Thread Daniel Andersen
> Hello Daniel, > > I can't answer your specific question, but I _can_ > tell you that the gurus will probably need more information > that you presented. > > 1) What operating system and version? Slackware linux 8.0, with the kernel upgraded to 2.4.16, strip

Re: [ADMIN] "dumpProcLangs(): handler procedure for language

2002-12-09 Thread Daniel Kalchev
from SELECT whatever FROM wherever WHERE oid = value; to SELECT whatever FROM wherever WHERE oid = oid(value); This has bitten me many times already :) I guess all your dump troubles are related to oid overflow. Daniel >>>Brian Fujito said: > Thanks again for your input. I think

Re: [ADMIN] "dumpProcLangs(): handler procedure for language

2002-12-09 Thread Daniel Kalchev
from perfect but saved my database(s). It also fixes other oid-related troubles of pg_dump. See attached file. Daniel >>>Brian Fujito said: > Thanks for your input-- > > I've tried both ways: > > createlang/droplang from the command line as user postgres >

Re: [ADMIN] Large objects - SOS

2003-02-06 Thread Daniel Schuchardt
Hi, in 7.3 this changed. type : CREATE DOMAIN lo AS oid; And everything works well. Daniel <[EMAIL PROTECTED]> schrieb im Newsbeitrag OF0B8A93EA.20F6C498-ON65256CC3.0043C73A@LocalDomain">news:OF0B8A93EA.20F6C498-ON65256CC3.0043C73A@LocalDomain... > Hi, > I need to creat

[ADMIN] system indices growing huge

2003-02-09 Thread daniel alvarez
in size? How can I prevent it? I'm stuck with this. Any help is welcome. Regards, Daniel Alvarez <[EMAIL PROTECTED]> web41@julius64:~ > uname -a Linux julius64 2.4.14 #34 Wed Jan 23 17:41:57 MET 2002 i686 unknown web41@julius64:~ > psql -V psql (PostgreSQL) 7.2 Port

[ADMIN] compress the data sended via network???

2003-02-10 Thread Daniel Schuchardt
exspecially with large TEXT-Fields (RTF-Format). Is this is possible with postgres??? Or what do you think about this feature??? Daniel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

2003-02-15 Thread daniel alvarez
> > > I have a problem with the "vacuum full". every time I run the vacuum > > > command I loose data from the parent tables. maybe also from the > > > subtables (haven't checked yet). I tried it a few times up to now an I > > > can reproduce the phenomena. > > > > That sounds ugly ... but are you

[ADMIN] Limiting database size ...

2003-02-26 Thread Daniel Rubio
sistence if the operating system doesn't permit to complete an operation in course). Someone has the same problem? How can I make that? What would happen to the consistence if the quota is full while postgres is writing? Thank you, and sorry for my english :( -- ****

Re: [ADMIN] Vacuum Question

2003-03-01 Thread Daniel Schuchardt
Do a VACUUM FULL on your database. This should be the solution. Daniel ""Pascal PEYRE"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi, > > I use postgresql 7.2.x on Linux 2.4.18-6mdksmp #1 SMP i686 > > I have some big postg

Re: [ADMIN] Limiting database size ...

2003-02-26 Thread Daniel Rubio
on what your trying to do). 200 Postgresql running? No, thanks :) -- 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: [EMAIL

Re: [ADMIN] How to compile contribs ...

2003-03-13 Thread Daniel Rubio
broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- **** 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

Re: [ADMIN] database size

2003-05-28 Thread Daniel Rubio
size of the specific database in Postgres? Thx. in advance. -Anagha -- 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

[ADMIN] Run 4 postgresql session on ONE server?

2003-06-12 Thread Daniel Seichter
ductive server as soon as the second database is ready. Thank you in advance for your answers Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--- TIP 6: H

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-14 Thread Daniel Seichter
g this weekend to start at the next week with the configuration. Daniel ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-15 Thread Daniel Seichter
but not to a directory. So I sit on my server and wait 15 minuten until postgreSQL is compiled..*g* Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--

[ADMIN] Backup up Users and grants

2003-06-16 Thread Daniel Seichter
Hello, is it possible, to backup all users with their grants to the tables or the database? Thank you Daniel Seichter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-16 Thread Daniel Seichter
le, but not to a directory. So I sit on my server and wait 15 minuten until postgreSQL is compiled..*g* Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-16 Thread Daniel Seichter
ossible, but not to a directory. So I sit on my server and wait 15 minuten until postgreSQL is compiled..*g* Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)---

[ADMIN] postgreSQL users = LDAP users?

2003-06-29 Thread Daniel Seichter
Hello, is it possible, to create all users of the databaseserver through LDAP? An schema extension is maybe required, but is it possible, yes or no?! If yes, where to find more information? Thank you Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org

Re: [ADMIN] postgreSQL users = LDAP users?

2003-07-01 Thread Daniel Seichter
Hello, thank you for you links, I will take a look to it. Daniel -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org -- you wrote --- Look at this http://www.mandrakesecure.net/en/docs/samba-ldap-advanced.php http://www.mandrakesecure.net/en/docs/ldap-auth2.php if you

[ADMIN] Advantages and disadvantages of more than one dbserver on one server

2003-07-02 Thread Daniel Seichter
. What things I should do? Each db got his own user, like postgres1, postgres2 or pgsql7331,... I sometimes need to log everything, but this is maybe once or twice a week, but I can't restart the server during the day. Daniel ---(end of broa

Re: [ADMIN] Advantages and disadvantages of more than one dbserver

2003-07-02 Thread Daniel Seichter
it and then I can't restart the db without notifiy all users and even about this I want to try to let run all databases in its own instance (or thread). Hope I explained it right, some words only know in german, not in english. Daniel ---(end of broadcast)--

Re: [ADMIN] Advantages and disadvantages of more than one dbserver on one server

2003-07-03 Thread Daniel Seichter
gh to work without any timeout or waiting times greater then 2 seconds. Thanks to all which helped. Daniel P.S.: I hope the new release of postgreSQL for netware will be available soon, so the same I can do without compiling. -- postgreSQL on Netware - the red elephant http://postgresql.dseichte

Re: [ADMIN] Advantages and disadvantages of more than one dbserver

2003-07-03 Thread Daniel Seichter
d use for cacheing. We only use this server as postgreSQL server, and no apache, no mail no php or something like this works on it. And if the main database grows up to some GB of capacity, we had to migrate to an new server. BTW, Dual 750's will be great for me *g* Daniel -

  1   2   >