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

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

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

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

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

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] Schema sizes with large objects

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

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

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

Re: [ADMIN] schema sizes

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

[ADMIN] schema sizes

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

[ADMIN] Problem with permanent connections from Tomcat

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

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

erform the upgrade I'll be pleased to know it ... And sorry for my poor english ... -- Mensaje original -- Date: Tue, 06 Jul 2004 11:06:25 +0200 From: Daniel Rubio <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [ADMIN] Upgrade problems with OID type ... Hi all! I'm trying to upgrad

[ADMIN] Upgrade problems with OID type ...

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] possible bug with sequences

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] Randomly error using php persistent connections

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] Randomly error using php persistent connections

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

[ADMIN] pg_lo_import alternative ...

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

Re: [ADMIN] pg_dump still requires password

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

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

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

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

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] Limiting database size ...

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

[ADMIN] Limiting database size ...

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